I have a publication/subscription replication.
Then this week started to see this message on Log of replica server.

Message is "duplicate key value violates unique constraint "pksyslookup""
Detail is "Key (lookup_id)=(56) already exists." 

and on production server message is
"logical decoding found consistent point at 5D5/5CD64ED0"


I have 200 schemas on that database and every schema has that table, so ho
can I discover what table is having that violation ? 
There is a way to know what WAL is being processed and get the command
should run to discover what table should be updated ?




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


Reply via email to