On Fri, Mar 24, 2017 at 3:11 PM, Subhankar Chattopadhyay <subho.atg@xxxxxxxxx> wrote: > Are you asking to have slave with synchronous replication? (top-posting is annoying) No, slaves cannot do synchronous replication. I am just telling that once you are sure that a sync state has been achieved on the master, you have the guarantee that data gets synchronously replicated on the standbys as long as you do *not* change synchronous_standby_names. So there is no actual need to know what's the state of the master during a failover to a sync standby. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general