Postgres Pro
Downloads
Home   >   mailing lists

Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4 - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4
Date
Msg-id CAKFQuwaNA8XKPS7HVuG6=cjLL=oQfLYTCGaKJmmxpVzfGMvXGg@mail.gmail.com
Whole thread Raw
In response to Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: User to get locked after three wrong login attempts.
Next
From: pavan95
Date:
Subject: Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4