ageres210784.ansible_walg

This is a role for installing and configuring wal-g.

Requirements

You need Ansible Galaxy.

Role Variables

You can find all variables in the default/main.yml file.

To restore from a specific time, use the "restore" tag and these variables:

• postgresql_conf_recovery - configuration settings for PostgreSQL (see more at https://postgrespro.ru/docs/postgresql/12/runtime-config-wal?lang=en#RUNTIME-CONFIG-WAL-RECOVERY-TARGET)
• walg_restore_name - the name of the backup (more info at https://github.com/wal-g/wal-g/blob/master/docs/PostgreSQL.md#backup-fetch)

Example configuration:

postgresql_conf_recovery:
  - recovery_target_action='promote'
  - recovery_target_time='2021-07-15 11:35:04'
  - recovery_target_timeline='current'
walg_restore_name: base_0000000300000000000000DA

Postgres in Docker

If you are using PostgreSQL with Docker, install wal-g in a Docker container and configure it using environment variables. This role will set up a cron job for regular archiving.

Configuration example:

walg_in_docker: true
walg_cron_time:
  minute: "*"
  hour: "*"
walg_pgdata: "/var/lib/postgresql/data"
walg_cron_user: "root"

To run:

ansible-playbook -t crontab run-walg.yml

Dependencies

None

Tested with Ansible

2.9

Example Playbook

- hosts: servers
  roles:
    - role: ageres210784.ansible_walg

License

Apache 2.0

Author Information

Evseev Sergey