:21
An: Sascha Zenglein
Cc: simon.ri...@enterprisedb.com ;
pgsql-general@lists.postgresql.org
Betreff: Re: AW: Reducing bandwidth usage of database replication
At Fri, 4 Nov 2022 09:25:44 +, Sascha Zenglein wrote
in
> I have set the status interval to 600s and it still sends a statu
At Fri, 4 Nov 2022 09:25:44 +, Sascha Zenglein wrote
in
> I have set the status interval to 600s and it still sends a status message
> every 30s.
> I also tried setting every available option higher, with no success:
I guess you are not setting wal_sender_timeout on the primary side.
Stat
tag, 4. November 2022 10:16
An: Sascha Zenglein
Cc: pgsql-general@lists.postgresql.org
Betreff: Re: Reducing bandwidth usage of database replication
On Thu, 3 Nov 2022 at 08:40, Sascha Zenglein
mailto:zengl...@gessler.de>> wrote:
It is, unfortunately, too much for our requirements.
I was able
On Thu, 3 Nov 2022 at 15:28, Ben Chobot wrote:
> I want to use the postgres-native logical replication to have multiple
> clients receive and send data to a central database.
> Real-time is far less important than network usage, and with my current test
> setup it appears both instances communi
On Thu, 3 Nov 2022 at 08:40, Sascha Zenglein wrote:
> It is, unfortunately, too much for our requirements.
> I was able to increase wal_receiver_status_interval so that the publisher
> only contacts the subscriber every 30 seconds instead of every 10.
> But I am not able to increase it further.
>
Sascha Zenglein wrote on 11/2/22 7:56 AM:
Hi all,
I want to use the postgres-native logical replication to have multiple
clients receive and send data to a central database.
Real-time is far less important than network usage, and with my
current test setup it appears both instances communicate
bidden.
Von: Ron
Gesendet: Mittwoch, 2. November 2022 17:29
An: pgsql-general@lists.postgresql.org
Betreff: Re: Reducing bandwidth usage of database replication
On 11/2/22 09:56, Sascha Zenglein wrote:
Hi all,
I want to use the postgres-native logical replicat
On 11/2/22 09:56, Sascha Zenglein wrote:
Hi all,
I want to use the postgres-native logical replication to have multiple
clients receive and send data to a central database.
Real-time is far less important than network usage, and with my current
test setup it appears both instances communicate
Hi all,
I want to use the postgres-native logical replication to have multiple clients
receive and send data to a central database.
Real-time is far less important than network usage, and with my current test
setup it appears both instances communicate frequently if a subscription is
active, ev
