Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4
Дата
Msg-id CAKFQuwaNA8XKPS7HVuG6=cjLL=oQfLYTCGaKJmmxpVzfGMvXGg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4  (pavan95 <pavan.postgresdba@gmail.com>)
Ответы Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4  (pavan95 <pavan.postgresdba@gmail.com>)
Список pgsql-admin
On Tuesday, September 4, 2018, pavan95 <pavan.postgresdba@gmail.com> wrote:
Now when an application user tries to insert another 50 records will the
replication for "country" table now starts for the differential part, that
is 50 records or it starts from the scratch?? 

Starting from scratch every time would make the feature unusable so, no, it doesn't do that.  It should only sync from scratch during initial subscription creation.

David J.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: User to get locked after three wrong login attempts.
Следующее
От: pavan95
Дата:
Сообщение: Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4