Re: Postgres 9.6 active-passive HA cluster

2019-10-16 Thread Michael Lewis
"pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters' timelines have diverged. A typical scenario is to bring an old master server back online after failover as a standby that follows the new master." -https://www.postgresql.org/docs/

Postgres 9.6 active-passive HA cluster

2019-10-16 Thread Jairam Gauns
Hi guys, We are in process of testing a Postgres 9.6 active-passive HA cluster using streaming replication on Rhel 7.6. We have setup Postgres 9.6 primary/warm standby streaming synchorous replication. We have set synchronous_standby_names=* and synchronous_commit=on. To test we have 5