Charmed PostgreSQL VM
- By Canonical Data Platform
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 345 | 09 Nov 2023 | |
latest/stable | 239 | 09 Feb 2022 | |
latest/stable | 226 | 01 Apr 2021 | |
14/stable | 430 | 28 Jun 2024 | |
14/stable | 429 | 28 Jun 2024 | |
14/candidate | 468 | 02 Sep 2024 | |
14/candidate | 467 | 02 Sep 2024 | |
14/beta | 468 | 02 Sep 2024 | |
14/beta | 467 | 02 Sep 2024 | |
14/edge | 472 | Yesterday | |
14/edge | 471 | Yesterday |
juju deploy postgresql --channel 14/edge
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
Note: All commands are written for juju >= v.3.0
If you are using an earlier version, check the Juju 3.0 Release Notes.
How to create and list backups
This guide contains recommended steps and useful commands for creating and managing backups to ensure smooth restores.
Prerequisites
- A cluster with at least three nodes deployed
- Access to S3 storage
- Configured settings for S3 storage
Summary
- Save your current cluster credentials, as you’ll need them for restoring
- Create a backup
- List backups to check the availability and status of your backups
Save your current cluster credentials
For security reasons, charm credentials are not stored inside backups. So, if you plan to restore to a backup at any point in the future, you will need theoperator
, replication
, and rewind
user passwords for your existing cluster.
You can retrieve them with:
juju run postgresql/leader get-password username=operator
juju run postgresql/leader get-password username=replication
juju run postgresql/leader get-password username=rewind
For more context about passwords during a restore, check How to migrate a cluster > Manage cluster passwords.
Create a backup
Once you have a three-node cluster with configurations set for S3 storage, check that Charmed PostgreSQL isactive
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/leader create-backup
By default, backups created with command above will be full backups: a copy of all your data will be stored in S3. There are 2 other supported types of backups (available in revision 416+, currently in channel 14/edge
only):
- Differential: Only modified files since the last full backup will be stored.
- Incremental: Only modified files since the last successful backup (of any type) will be stored.
To specify the desired backup type, use the type
parameter:
juju run postgresql/leader create-backup type={full|differential|incremental}
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 thelist-backups
command:
juju run postgresql/leader list-backups