|
I am using PostgreSQL 9.4 with pglogical replication. I have 1 provider node and 1 subscriber in 2 separate locations. The subscriber subscribes to 1 database on the provider. Every evening a function runs that DELETE's & INSERT's to tables that are replicated
to the subscriber and causes CONFLICT messages to be logged:-
CONFLICT: remote UPDATE on relation db1.schedule. Resolution: (null).
CONFLICT: remote UPDATE on relation db1.schedule (tuple not found). Resolution: skip. When I run the individual DELETE & INSERT statements to the schedule table manually I don't get any conflicts.
I have also compared the provider and subscribers data and they appear to be consistent with each other.
Any help or suggestions would be much appreciated.
|
