ageres210784.ansible_walg

Role for wal-g installation and configuration.

Requirements

Ansible Galaxy

Role Variables

You can see all vars in default/main.yml vars file.

To restore by a certain time you should use the tag of "restore" and the following variables:

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

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 use postgresql in docker you should install wal-g in a docker container and configuring it with environment variables. In this case this role configure crontab for periodic archiving.

Config:

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

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