Re: Reducing bandwidth usage of database replication

2022-11-04 Thread Simon Riggs
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

Re: Reducing bandwidth usage of database replication

2022-11-04 Thread Simon Riggs
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. >

Re: Reducing bandwidth usage of database replication

2022-11-03 Thread Ben Chobot
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

Re: Reducing bandwidth usage of database replication

2022-11-02 Thread Ron
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