← Home

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.

← Home

Erben Systems GmbH

Watterstrasse 81, c/o Sarbach Treuhand AG, 8105 Regensdorf, Switzerland

CHE-174.268.027 MwSt