Charmed PostgreSQL K8s How To - Create and List backups

charm
, , ,
1

How to create and list backups

Prerequisites

Note: All commands are written for juju >= v.3.0

If you are using an earlier version, be aware that:

  • juju run replaces juju run-action --wait in juju v.2.9
  • juju integrate replaces juju relate and juju add-relation in juju v.2.9

For more information, check the Juju 3.0 Release Notes.

Create backups

Once you have a three-node cluster with configurations set for S3 storage, check that Charmed PostgreSQL is active and idle with juju status.

Once Charmed PostgreSQL is active and idle, you can create your first backup with the create-backup command:

juju run postgresql-k8s/leader create-backup

Tip: To avoid unnecessary service downtime, always use non-primary units for the action create-backup. Keep in mind that:

  • TLS enabled: disables the command from running on primary units.
  • TLS not enabled: disables the command from running on non-primary units.

List backups

You can list your available, failed, and in-progress backups by running the list-backups command:

juju run postgresql-k8s/leader list-backups