search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 154 forks source link

Stale pglogical extension process breaking logical replication #443

Open Viralshah009 opened 1 year ago

Viralshah009 commented 1 year ago

Environment:

pglogical version: 2.4.3
PostgreSQL version: 14.8
Two production servers

Symptoms:

pg_replication_slots says that the logical replication subscriptions are replicating and active
No data is getting replicated from publisher to subscriber
Stale pglogical extension process found on the subscriber server

Steps taken:

Recreated subscription (no help)
Killed stale pglogical extension process on the subscriber server
Dropped pglogical extension on the subscriber server
Recreated pglogical extension, subscription, etc. on the subscriber server

Outcome:

Replication resumed

Question:

Has anyone else come across this issue? If not, can it be fixed?

Additional notes:

We have tried to recreate this issue in our test environments but are unable to do so.