Sample Header Ad - 728x90

Resuming PostgreSQL logical replication (missing pg_stat_replication entry)

2 votes
0 answers
241 views
I implemented a logical replication on PostgreSQL 14 (from AWS to on-premise) via windows. A few days we experience internet lags. When i checked the pg_stat_replication in publication source, it was totally empty but the pg_replication_slots has one row entry. I tried executing "alter subscription refresh publication" and also "alter subscription disable/enable" in the subscriber side but still no entry on the pg_stat_replication under publication source. What is the proper way to resume/continue the logical replication on the subscriber side?
Asked by starting dba jr (85 rep)
Dec 21, 2022, 04:45 AM
Last activity: Dec 22, 2022, 01:00 AM