PGLOGICAL subscription status down and not able to restart

[xi-relay]

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]

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';