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.
--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.
--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.
--promote-standby Disables standby mode (if enabled) and promotes the cluster(s) specified.
-s, --selector string The selector to use for cluster filtering.
--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-
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