Pause/resume PostgreSQL Cluster

There may be external situations when it is needed to pause your Cluster for a while and then start it back up (some works related to the maintenance of the enterprise infrastructure, etc.).

The deploy/cr.yaml file contains a special spec.pause key for this. Setting it to true gracefully stops the cluster:

spec:
  .......
  pause: true

To start the cluster after it was paused just revert the spec.pause key to false.

Note

There is an option also to put the cluster into a standby (read-only) mode instead of completely shutting it down. This is done by a special spec.standby key, which should be set to true for read-only state or should be set to false for normal cluster operation:

spec:
  .......
  standby: false

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services. Join K8S Squad to benefit from early access to features and “ask me anything” sessions with the Experts.

Community Forum Get a Percona Expert