Charmed PostgreSQL K8s

Channel Revision Published Runs on
latest/stable 20 20 Sep 2022
Ubuntu 20.04
14/stable 193 13 Mar 2024
Ubuntu 22.04
14/candidate 248 04 May 2024
Ubuntu 22.04
14/beta 248 04 May 2024
Ubuntu 22.04
14/edge 253 Today
Ubuntu 22.04
juju deploy postgresql-k8s --channel 14/stable
Show information

Platform:

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.

Note: All commands are written for juju >= v.3.0

If you are using an earlier version, be aware that:

  • juju run replaces juju run-action --wait in juju v.2.9
  • juju integrate replaces juju relate and juju add-relation in juju v.2.9

For more information, check the Juju 3.0 Release Notes.

Prerequisites

List backups

To view the available backups to restore, use the command list-backups:

juju run postgresql-k8s/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-k8s/leader restore backup-id=YYYY-MM-DDTHH:MM:SSZ

Your restore will then be in progress.


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