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 153 forks source link

PGLOGICAL subscription status down and not able to restart #384

Open xi-relay opened 2 years ago

xi-relay commented 2 years ago

Our pglogical set up on production db sometime would show the subscription status is down, and I am not able to get it back to replicating. The postgres log is not helpful also. The only way that would work is to re-create the whole set up which include re-initializing all the tables first and it takes 10+hours.

What is the best way to deal with down status without recreating the whole set up?

eulerto commented 1 year ago

You didn't provide enough information to investigate this issue. What's your pglogical version? What's your Postgres version? Did you check the logs? Could you execute the following SQL command?

SELECT * FROM pglogical.local_sync_status WHERE sync_status <> 'r';