Обсуждение: pgbackrest with PAF(corosync and pacmaker)
pg1-host=pgprimary
pg1-path=/var/lib/pgsql/10/data
pg2-host=pgsec
pg2-path=/var/lib/pgsql/10/data
[global]
backup-standby=y
process-max=3
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2
start-fast=y
pg1-host=main
pg1-path=/var/lib/pgsql/10/data
pg2-host=sec
pg2-path=/var/lib/pgsql/10/data
[global]
backup-standby=n
process-max=3
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2
start-fast=y
Disclaimer: The information in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Drishti is neither liable for the improper, incomplete transmission of the information contained in this communication nor any delay in its receipt. The communication is not intended to operate as an electronic signature under any applicable law. Drishti assumes no responsibility for any loss or damage resulting from the use of e-mails.
On 10/17/19 9:48 AM, Ajay Pratap wrote: > > I am using pacemaker and corosync to setup two nodes High availability > cluster for postgreSQL 10. In the scenario I want to setup timely backup > with pgbackrest. > Using the _backup from standby_ feature I could able to take backup from > my secondary postgres. But if secondary postgres is down, it does not > take backup from primary. This is entirely on purpose. Backup from standby is designed to reduce load on the primary so we believe it is counter-intuitive to put load back on the primary when the standby is down. Running backups *at all* when degraded is usually a bad idea. > Is there any way to achieve this? You can run more than one standby and pgBackRest will automatically select the first one it finds that is up. If you must take a backup when degraded then you can specify --no-backup-standby on the command line to disable standby for that one backup. Regards, -- -David david@pgmasters.net