Hi
We are currently on PostgreSQL 9.6 and our HA is configured as master/slave with wal streaming replication.
We would like to setup a second slave which replicates from the same master.
Eg:
Current setup:
Slave ß Master
Slave is setup for automatic failover and we use pg_rewind after failover to rewind the old master as new slave.
New setup:
Slave1 ß Master à Slave2
Slave 2 (new) is for reporting and nightly pg_dumps, as we have some very big databases.
Slave 1 is for HA and is setup automatic failover.
After a failover (promote) to the Slave1, is it easily resync the Slave2 to the new master (old slave1)? Do we need to do full rebuild of the Slave2 from new master everytime we failover to Slave1 from Master? Can we use pg_rewind on Slave2 to resyn it with new master (old slave1)?
Thanks
Dylan