Database Restore

[jlangy]

Overview

We use the following backup container in our instance to handle taking and restoring backups. Their readme covers this information in more depth.

The backup container pod in our namespaces can be found from the prefix patroni-backup-storage.

Taking a backup

To take a backup, get a terminal to the backup pod, either through the UI or with oc rsh <podname>
From the root directory, run the backup script with ./backup.sh -1

Restoring a backup

1. To restore, you will need to end any active connections to the database. So first take down all of the pods in the sso-keycloak deployment.
2. You will need the database spec of the database you are restoring to. This can be found in the configMaps section of openshift, under patroni-backup-storage-config, and will look like sso-pgsql-master-prod:5432/rhsso
3. Get a terminal to the backup pod, either through the UI or with oc rsh
4. To restore the most recent version, you can run ./backup.sh -r <DatabaseSpec/>, using the database spec you got from the configmap.

In addition to the above steps, you can run the ./backup.sh -r <DatabaseSpec/> with a -f flag to specify a specific backup file. To find a specific file, you can look in the /backups/<daily|weekly|monthly> folder. You can also use ./backup.sh -h for more information on how to use the script.