Re: [GENERAL] Lag in asynchronous replication

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] Lag in asynchronous replication
Дата
Msg-id CAB7nPqS99Tipg+YdNd-ugA3ubGiUjBukcB1RWmq-rEinrW7bfw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Lag in asynchronous replication  (Subhankar Chattopadhyay <subho.atg@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Subhankar Chattopadhyay
Дата:
Сообщение: Re: [GENERAL] Lag in asynchronous replication
Следующее
От: Glen Huang
Дата:
Сообщение: Re: [GENERAL] How to create unique index on multiple columns wherethe combination doesn't matter?