Charmed PostgreSQL
- By Canonical Data Platform
- Databases
| Channel | Revision | Published | Runs on |
|---|---|---|---|
| latest/stable | 345 | 09 Nov 2023 | |
| 14/stable | 336 | 18 Oct 2023 | |
| 14/candidate | 336 | 18 Oct 2023 | |
| 14/beta | 336 | 18 Oct 2023 | |
| 14/edge | 350 | 02 Dec 2023 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
22.04
This is a How-To for performing a basic restore (restoring a locally made backup). To restore a backup that was made from the a different cluster, (i.e. cluster migration via restore), please reference the Cluster Migration via Restore How-To:
Restoring from a backup requires that you:
- Scale-down to the single PostgreSQL unit (scale it up after the backup is restored).
- Access to S3 storage
- Have configured settings for S3 storage
- Have existing backups in your S3-storage
To view the available backups to restore you can enter the command list-backups:
juju run-action postgresql/leader list-backups --wait
This should show your available backups
backups: |-
backup-id | backup-type | backup-status
----------------------------------------------------
YYYY-MM-DDTHH:MM:SSZ | physical | finished
To restore a backup from that list, run the restore command and pass the backup-id to restore:
juju run-action postgresql/leader restore backup-id=YYYY-MM-DDTHH:MM:SSZ --wait
Your restore will then be in progress.