[Bucardo-general] Replication failure because of duplicate key violation

2020-02-14 Thread Sai Prasad
Hi all, I've configured two RHEL machines with redundancy configuration (master- master setup) with below software versions. Database version : PostgreSQL 9.5 Bucardo version : Bucardo 5.4 Database replication goes smoothly till some point of time, After that replica

Re: [Bucardo-general] Replication failure because of duplicate key violation

2020-02-14 Thread David Christensen
On Feb 14, 2020, at 5:24 AM, Sai Prasad wrote: > (22825) [Wed Feb 12 12:10:05 2020] KID (database_sync) Kid 22825 exiting at > cleanup_kid. Sync "database_sync" public.interface Reason: DBD::Pg::db > pg_putcopyend failed: ERROR: duplicate key value violates unique constraint > "interface_node