Cascade publication with pg_stat_replication empty

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Cascade publication with pg_stat_replication empty
Date: 2021-04-07 11:16:06
Message-ID: 1617794166899-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-04-07 14:18:02 Re: Cascade publication with pg_stat_replication empty
Previous Message Ciaran Doherty 2021-04-07 11:15:37 Using indexes through a plpgsql procedure