Recovering Dokku Postgres 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.