craftypenguins/autopostgresqlbackup repository overview

⁠docker-autopostgresqlbackup

Alpine-based Docker that includes OpenSSH and autopostgresqlbackup script.

The autopostgresqlbackup script was taken from Debian⁠ and not its home at SourceForge⁠ because the Deb version has sensible improvements, such as commenting out some example configurations, and loading settings from /etc/default/autopostgresqlbackup.

Key environment variables:

• DBHOST: hostname of PostgreSQL server
• USERNAME: PostgreSQL username
• DBPASS: PostgreSQL password
• DBNAMES: space-separated list of DBs to back up (omit to back up everything)
• DBEXCLUDE: space-separated list of DBs to exlcude

See backup-postgresql and configure-autopostgresqlbackup for a more complete list of variables.

These files should be mounted from somewhere persistent:

• /root/.ssh/authorized_keys
• /etc/ssh/ssh_host_dsa_key
• /etc/ssh/ssh_host_dsa_key.pub
• /etc/ssh/ssh_host_ecdsa_key
• /etc/ssh/ssh_host_ecdsa_key.pub
• /etc/ssh/ssh_host_ed25519_key
• /etc/ssh/ssh_host_ed25519_key.pub
• /etc/ssh/ssh_host_rsa_key
• /etc/ssh/ssh_host_rsa_key.pub

⁠Usage:

ssh into the container and run backup-postgresql. Backup files will be placed in /backups or as defined by ${BACKUPDIR}.