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

Add the ability to configure a dedicated pgBackRest server #379

Closed vitabaks closed 1 year ago

vitabaks commented 1 year ago

This PR introduces significant improvements to our backup and recovery capabilities with pgBackRest.

The main feature is the ability to configure and manage the dedicated pgBackRest servers (pgbackrest_server_conf variable). Previously, backup configuration was limited to the database servers only.

In addition to these improvements, add pgBackRest cron jobs via the "pgbackrest_cron_jobs" variable. Backup Jobs will be automatically configured. By default, the cron jobs is created on the database server. If 'pgbackrest_repo_host' is defined, the cron jobs will be created on the dedicated pgBackRest server.

Updated the pgBackRest configuration template to enable configuration of a single dedicated pgBackRest server for multiple Postgres clusters.