I have a server which replicates using Publication/Subscription. On
subscriber server I have some ETL processes running on it and from this
second server I´ve created a new publication to send this database to a
third server. While this second server was copying data with COPY to third,
everything was fine but when COPY finished and it would start streaming
data, both replication just stopped.
View pg_stat_replication is empty on first server and subscriber server is
not connected to it.
Exactly same occurs on second, its pg_stat_replication is empty and
subscriber, the third server, is not connected to it.
But WAL is being generated on first server, which seems that it is waiting
the second to connect to it.
So, pg_publication are filled correctly on publishers but
pg_stat_replication is empty on both
First and second servers are version 11.11 and third one is 13.0
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html