pglogical
pglogical copied to clipboard
Stale pglogical extension process breaking logical replication
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.