Postgres Pro
Downloads
Home   >   mailing lists

Re: Cascade publication with pg_stat_replication empty - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Cascade publication with pg_stat_replication empty
Date
Msg-id 0c8a60a9895500562950be147398e2099d4a4aa5.camel@cybertec.at
Whole thread Raw
In response to Cascade publication with pg_stat_replication empty  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Cascade publication with pg_stat_replication empty  (PegoraroF10 <marcos@f10.com.br>)
Re: Cascade publication with pg_stat_replication empty  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
Tree view 
On Wed, 2021-04-07 at 04:16 -0700, PegoraroF10 wrote:
> 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.

Look into the PostgreSQL log on both machines.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: Cascade publication with pg_stat_replication empty
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Using indexes through a plpgsql procedure