AutoPostgreSQLBackup is a shell script (usually executed from a cron job) designed to provide a fully automated tool to make periodic backups of PostgreSQL databases.
AutoPostgreSQLBackup extract databases into flat files in a daily, weekly or monthly basis.
Version 2.0 is a full rewrite.
It supports:
On Debian (or derived):
Install: apt install autopostgresqlbackup
If the default options are not suitable for you, change them: ${EDITOR} /etc/default/autopostgresqlbackup
That's it!
See the documentation.
Encryption (asymmetric) is now done with GnuPG, you just need to add the
public key (armored or not) you want to encrypt the data to in the file pointed by the ${ENCRYPTION_PUBLIC_KEY}
configuration setting.
Export your public key:
gpg --export 0xY0URK3Y1D --output mypubkey.gpg
or
gpg --export --armor 0xY0URK3Y1D --output mypubkey.asc
then copy mypubkey.asc
or mypubkey.gpg
to the path pointed by the ${ENCRYPTION_PUBLIC_KEY}
configuration setting and set the ${ENCRYPTION}
setting to yes
.
Starting from version 2.0 encryption with OpenSSL is no longer supported as it was discovered (but also known for quite some time) that encrypting large files with OpenSSL silently fail and that decrypting these files is close to be impossible.