Charmed PostgreSQL

Channel Revision Published Runs on
latest/stable 345 09 Nov 2023
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04
14/stable 336 18 Oct 2023
Ubuntu 22.04
14/candidate 336 18 Oct 2023
Ubuntu 22.04
14/beta 336 18 Oct 2023
Ubuntu 22.04
14/edge 350 02 Dec 2023
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
22.04

Charmed PostgreSQL backup can be stored on any S3 compatible storage, e.g. on Ceph via RadosGW. The S3 access and configurations are managed with the s3-integrator charm. Deploy and configure the s3-integrator charm for RadosGW (click here to backup on AWS S3):

# Install MinIO client and create a bucket:
mc config host add dest https://radosgw.mycompany.fqdn <access-key> <secret-key> --api S3v4 --lookup path
mc mb dest/backups-bucket

juju deploy s3-integrator
juju run-action s3-integrator/leader sync-s3-credentials access-key=<access-key> secret-key=<secret-key> --wait
juju config s3-integrator \
    endpoint="https://radosgw.mycompany.fqdn" \
    bucket="backups-bucket" \
    path="/postgresql" \
    region="" \
    s3-api-version="" \
    s3-uri-style="path"

To pass these configurations to Charmed PostgreSQL, relate the two applications:

juju relate s3-integrator postgresql

You can create/list/restore backups now:

juju run-action postgresql/leader list-backups --wait
juju run-action postgresql/leader create-backup --wait
juju run-action postgresql/leader list-backups --wait
juju run-action postgresql/leader restore backup-id=<backup-id-here> --wait

You can also update your S3 configuration options after relating, using:

juju config s3-integrator <option>=<value>

The s3-integrator charm accepts many configurations - enter whatever configurations are necessary for your S3 storage.


Help improve this document in the forum (guidelines). Last updated 7 months ago.