postgres-backup.md

Postgres Backup

This playbook can configure docker-postgres-backup-local for you via the mother-of-all-self-hosting/ansible-role-postgres-backup Ansible role.

For a more complete backup solution (one that includes not only Postgres, but also other configuration/data files), you may wish to look into borg backup.

Configuration

To enable this service, add the following configuration to your vars.yml file and re-run the installation process:

########################################################################
#                                                                      #
# postgres-backup                                                      #
#                                                                      #
########################################################################

postgres_backup_enabled: true

########################################################################
#                                                                      #
# /postgres-backup                                                     #
#                                                                      #
########################################################################

Refer to the table below for additional configuration variables and their default values.

Name	Default value	Description
postgres_backup_enabled	false	Set to true to use docker-postgres-backup-local to create automatic database backups
postgres_backup_schedule	'@daily'	Cron-schedule specifying the interval between postgres backups.
postgres_backup_keep_days	7	Number of daily backups to keep
postgres_backup_keep_weeks	4	Number of weekly backups to keep
postgres_backup_keep_months	12	Number of monthly backups to keep
postgres_backup_base_path	"{{ mash_playbook_base_path }}/postgres-backup"	Base path for postgres-backup. Also see postgres_backup_data_path
postgres_backup_data_path	"{{ postgres_backup_base_path }}/data"	Storage path for postgres-backup database backups