pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

Tables are in replicating state, but different content on master and replica

Open ZiBiS opened this issue 3 years ago • 0 comments

PGLogical 2.3.2 on Debian servers. All replicated tables are in state replicating - when checked by pglogical.show_subscription_table() or by pglogical.local_sync_status, but pglogical.queue is not empty - with Q and A messages, and number of rows in some tables on master and replica are different - no filters are defined in replication_set. Should pglogical.queue be empty or how to flush this queue, just delete records from it?

ZiBiS avatar Sep 02 '20 10:09 ZiBiS