hapostgres / pg_auto_failover

Postgres extension and service for automated failover and high-availability
Other
1.07k stars 112 forks source link

Integration/Support of pgbackrest #1038

Open mroissetgem opened 1 week ago

mroissetgem commented 1 week ago

Hello, first thanks a lot for this opensource project.

We use pg_autofailover for more than a year and half with this kind of setup: 1 monitor and 3 nodes num sync standby 1. givent the size of the database(more than 5TB) and requirements for frequent non production refresh. We use pgbackest for backup restore purpose. I understand that pgbackrest is not officialy supported but could you please clarify the risks that we take to use pgbackrest in our configuration (archiving on replica), restore command.. Thanks