Re: [GENERAL] Lag in asynchronous replication - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] Lag in asynchronous replication
Date
Msg-id CAB7nPqS99Tipg+YdNd-ugA3ubGiUjBukcB1RWmq-rEinrW7bfw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Lag in asynchronous replication  (Subhankar Chattopadhyay <subho.atg@gmail.com>)
List pgsql-general
On Fri, Mar 24, 2017 at 3:11 PM, Subhankar Chattopadhyay
<subho.atg@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


pgsql-general by date:

Previous
From: Subhankar Chattopadhyay
Date:
Subject: Re: [GENERAL] Lag in asynchronous replication
Next
From: Glen Huang
Date:
Subject: Re: [GENERAL] How to create unique index on multiple columns wherethe combination doesn't matter?