mash-playbook/docs/services/postgres-backup.md

2.5 KiB

Postgres Backup

This playbook can configure docker-postgres-backup-local for you via the com.devture.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