All; We have a 3 node replication setup:
Master (node1) --> Cascading Replication Node (node2) --> Downstream Standby node (node3)
We will be deploying WAL archiving from the master for PITR backups and we'll use the staged WAL files in the recovery.conf files in case the standbys need to revert to log shipping.
Question: whats the best way to ensure consistency of WAL archiving in the case of changes (failover, etc)? can we setup the cascade node to archive wals only if it's the master? is this a case where we should deploy repmgr?
Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
