WAL Shipping and streaming replication - Mailing list pgsql-general

From CS DBA
Subject WAL Shipping and streaming replication
Date
Msg-id 5609535B.1050002@consistentstate.com
Whole thread Raw
Responses Re: WAL Shipping and streaming replication
List pgsql-general
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




pgsql-general by date:

Previous
From: Ben Primrose
Date:
Subject: Re: Extract giving wrong week of year
Next
From: Scott Marlowe
Date:
Subject: Re: WAL Shipping and streaming replication