dokku

Recovering Dokku Postgres Backups

Dokku with its Postgres plugin can be used to manage Postgres databases, this includes automated backups.

Once automated backups are implemented, you end up having encrypted database dumps in your backup location (which usually is some S3 storage).

These are the steps needed to decrypt, unpack and apply the backups to Postgres instance managed by Dokku where the backup was created of.

gpg --pinentry-mode=loopback --passphrase "<passphrase>" -d -o <decrypted>.tgz <encrypted>.tgz.gpg

mkdir <backup>

tar zxvf <decrypted>.tgz -C <backup>

docker exec -i <container_name> pg_restore -U admin -d dev --no-owner < <backup>

I feel like these steps could be part of the great Dokku Postgres Plugin.