On Fri, Mar 24, 2017 at 3:11 PM, Subhankar Chattopadhyay <subho....@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general