On Monday, September 3, 2018, pavan95 <
pavan.postgresdba@gmail.com> wrote:
Hi Achilleas,
>>>Either you created the subscription while the subscriber already had
existing data in the tables
I had taken a backup(along with data) and restored on both publisher and
subscriber. Later which I have created Publication and Subscription on both
the nodes.
I don’t know if this can be made to function properly but it’s definitely not the expected usage pattern.
Expected is that one node publishes and the other one subscribes. The subscriber starts from scratch and synchronizes from the publisher.
Lacking any more specific responses you should consider dropping (truncating?) the relevant tables and subscription from the subscriber node and starting from scratch so as to conform to the expected usage pattern. Have not used the feature myself so can’t be of much more help than this...
David J.