Charmed PostgreSQL K8s
- By Canonical Data Platform
- Databases
| Channel | Revision | Published | Runs on |
|---|---|---|---|
| latest/stable | 20 | 20 Sep 2022 | |
| 14/stable | 193 | 13 Mar 2024 | |
| 14/candidate | 193 | 31 Jan 2024 | |
| 14/beta | 211 | 13 Mar 2024 | |
| 14/edge | 237 | 16 Apr 2024 |
juju deploy postgresql-k8s --channel 14/stable
Deploy Kubernetes operators easily with Juju, the Universal Operator Lifecycle Manager. Need a Kubernetes cluster? Install MicroK8s to create a full CNCF-certified Kubernetes system in under 60 seconds.
Platform:
How to create and list backups
Prerequisites
- A cluster with at least three-nodes deployed
- Access to S3 storage
- Configured settings for S3 storage
Note: All commands are written for juju >= v.3.0
If you are using an earlier version, be aware that:
juju runreplacesjuju run-action --waitinjuju v.2.9juju integratereplacesjuju relateandjuju add-relationinjuju 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