search

vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
https://postgresql-cluster.org
MIT License
1.69k stars 411 forks source link

Automate cron jobs configuration for WAL-G and minor fixes #395

Closed vitabaks closed 1 year ago

vitabaks commented 1 year ago
  1. If wal_g_install: true, configure cron jobs for WAl-G
  2. Added a cron job to delete backups and WAL archives (older than 30 days by default)
  3. Change the WAL-G config example to use with AWS S3
  4. Add the ability to pass AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, WALG_S3_PREFIX variables via --extra-vars
  5. Move "cron_jobs" variable to vars/system.yml
  6. Add the local replication rule to pg_hba.conf for WAl-G
  7. Add the path to the data directory for the wal-g backup-push command

New variable "wal_g_cron_jobs"