pgo update cluster
pgo update cluster
Update a PostgreSQL cluster
Synopsis
Update a PostgreSQL cluster. For example:
pgo update cluster mycluster --disable-autofail
pgo update cluster mycluster myothercluster --disable-autofail
pgo update cluster --selector=name=mycluster --disable-autofail
pgo update cluster --all --enable-autofail
pgo update cluster [flags]
Options
--all all resources.
--annotation strings Add an Annotation to all of the managed deployments (PostgreSQL, pgBackRest, pgBouncer)
The format to add an annotation is "name=value"
The format to remove an annotation is "name-"
For example, to add two annotations: "--annotation=hippo=awesome,elephant=cool"
--annotation-pgbackrest strings Add an Annotation specifically to pgBackRest deployments
The format to add an annotation is "name=value"
The format to remove an annotation is "name-"
--annotation-pgbouncer strings Add an Annotation specifically to pgBouncer deployments
The format to add an annotation is "name=value"
The format to remove an annotation is "name-"
--annotation-postgres strings Add an Annotation specifically to PostgreSQL deploymentsThe format to add an annotation is "name=value"
The format to remove an annotation is "name-"
--cpu string Set the number of millicores to request for the CPU, e.g. "100m" or "0.1".
--cpu-limit string Set the number of millicores to limit for the CPU, e.g. "100m" or "0.1".
--disable-autofail Disables autofail capabitilies in the cluster.
--disable-metrics Disable the metrics collection sidecar. May cause brief downtime.
--disable-pgbadger Disable the pgBadger sidecar. May cause brief downtime.
--disable-server-tls Remove TLS from the cluster.
--disable-tls-only Remove TLS enforcement for the cluster.
--enable-autofail Enables autofail capabitilies in the cluster.
--enable-metrics Enable the metrics collection sidecar. May cause brief downtime.
--enable-pgbadger Enable the pgBadger sidecar. May cause brief downtime.
--enable-standby Enables standby mode in the cluster(s) specified.
--enable-tls-only Enforce TLS on the cluster.
--exporter-cpu string Set the number of millicores to request for CPU for the Crunchy Postgres Exporter sidecar container, e.g. "100m" or "0.1".
--exporter-cpu-limit string Set the number of millicores to limit for CPU for the Crunchy Postgres Exporter sidecar container, e.g. "100m" or "0.1".
--exporter-memory string Set the amount of memory to request for the Crunchy Postgres Exporter sidecar container.
--exporter-memory-limit string Set the amount of memory to limit for the Crunchy Postgres Exporter sidecar container.
--exporter-rotate-password Used to rotate the password for the metrics collection agent.
-h, --help help for cluster
--memory string Set the amount of RAM to request, e.g. 1GiB.
--memory-limit string Set the amount of RAM to limit, e.g. 1GiB.
--no-prompt No command line confirmation.
--pgbackrest-cpu string Set the number of millicores to request for CPU for the pgBackRest repository.
--pgbackrest-cpu-limit string Set the number of millicores to limit for CPU for the pgBackRest repository.
--pgbackrest-memory string Set the amount of memory to request for the pgBackRest repository.
--pgbackrest-memory-limit string Set the amount of memory to limit for the pgBackRest repository.
--pgbackrest-pvc-size string The size of the PVC capacity for the pgBackRest repository. Overrides the value set in the storage class. This is ignored if the storage type of "posix" is not used. Must follow the standard Kubernetes format, e.g. "10.1Gi"
--promote-standby Disables standby mode (if enabled) and promotes the cluster(s) specified.
--pvc-size string The size of the PVC capacity for primary and replica PostgreSQL instances. Must follow the standard Kubernetes format, e.g. "10.1Gi"
--replication-tls-secret string The name of the secret that contains the TLS keypair to use for enabling certificate-based authentication between PostgreSQL instances, particularly for the purpose of replication. TLS must be enabled in the cluster.
-s, --selector string The selector to use for cluster filtering.
--server-ca-secret string The name of the secret that contains the certficate authority (CA) to use for enabling the PostgreSQL cluster to accept TLS connections. Must be used with "server-tls-secret".
--server-tls-secret string The name of the secret that contains the TLS keypair to use for enabling the PostgreSQL cluster to accept TLS connections. Must be used with "server-ca-secret"
--service-type string The Service type to use for the PostgreSQL cluster. If not set, the pgo.yaml default will be used.
--shutdown Shutdown the database cluster if it is currently running.
--startup Restart the database cluster if it is currently shutdown.
--tablespace strings Add a PostgreSQL tablespace on the cluster, e.g. "name=ts1:storageconfig=nfsstorage". The format is a key/value map that is delimited by "=" and separated by ":". The following parameters are available:
- name (required): the name of the PostgreSQL tablespace
- storageconfig (required): the storage configuration to use, as specified in the list available in the "pgo-config" ConfigMap (aka "pgo.yaml")
- pvcsize: the size of the PVC capacity, which overrides the value set in the specified storageconfig. Follows the Kubernetes quantity format.
For example, to create a tablespace with the NFS storage configuration with a PVC of size 10GiB:
--tablespace=name=ts1:storageconfig=nfsstorage:pvcsize=10Gi
--toleration strings Set Pod tolerations for each PostgreSQL instance in a cluster.
The general format is "key=value:Effect"
For example, to add an Exists and an Equals toleration: "--toleration=ssd:NoSchedule,zone=east:NoSchedule"
A toleration can be removed by adding a "-" to the end, for example:
--toleration=ssd:NoSchedule-
--wal-pvc-size string The size of the capacity for WAL storage, which overrides any value in the storage configuration. Must follow the standard Kubernetes format, e.g. "10.1Gi".
Options inherited from parent commands
--apiserver-url string The URL for the PostgreSQL Operator apiserver that will process the request from the pgo client. Note that the URL should **not** end in a '/'.
--debug Enable additional output for debugging.
--disable-tls Disable TLS authentication to the Postgres Operator.
--exclude-os-trust Exclude CA certs from OS default trust store
-n, --namespace string The namespace to use for pgo requests.
--pgo-ca-cert string The CA Certificate file path for authenticating to the PostgreSQL Operator apiserver.
--pgo-client-cert string The Client Certificate file path for authenticating to the PostgreSQL Operator apiserver.
--pgo-client-key string The Client Key file path for authenticating to the PostgreSQL Operator apiserver.
SEE ALSO
- pgo update - Update a pgouser, pgorole, or cluster