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 | 429 | 26 Jun 2024 | |
14/candidate | 430 | 26 Jun 2024 | |
14/beta | 430 | 26 Jun 2024 | |
14/beta | 429 | 26 Jun 2024 | |
14/edge | 444 | 22 Jul 2024 | |
14/edge | 443 | 22 Jul 2024 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
22.04
20.04
18.04
16.04
14.04
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 restore a local backup
This is a guide on how to restore a locally made backup.
To restore a backup that was made from a different cluster, (i.e. cluster migration via restore), see How to migrate cluster using backups:
Prerequisites
- Deployments have been scaled-down to a single PostgreSQL unit (scale it up after the backup is restored)
- Access to S3 storage
- Configured settings for S3 storage
- Existing backups in your S3storage
List backups
To view the available backups to restore, use the command list-backups
:
juju run postgresql/leader list-backups
This should show your available backups like in the sample output below:
backups: |-
backup-id | backup-type | backup-status
----------------------------------------------------
YYYY-MM-DDTHH:MM:SSZ | physical | finished
Restore backup
To restore a backup from that list, run the restore
command and pass the corresponding backup-id
:
juju run postgresql/leader restore backup-id=YYYY-MM-DDTHH:MM:SSZ
Your restore will then be in progress.