Re: Standby Replication and Replication Delay

2019-09-14 Thread Thomas Rosenstein
On 14 Sep 2019, at 22:08, Tomas Vondra wrote: On Sat, Sep 14, 2019 at 09:26:26PM +0200, Thomas Rosenstein wrote: Hi Tomas, I'm using Postgresql 10.10 on the standbys and 10.5 on the primary. On 14 Sep 2019, at 21:16, Tomas Vondra wrote: On Sat, Sep 14, 2019 at 06:03:34PM +0200, Thomas Rosen

Re: Standby Replication and Replication Delay

2019-09-14 Thread Thomas Rosenstein
Hi Tomas, I'm using Postgresql 10.10 on the standbys and 10.5 on the primary. On 14 Sep 2019, at 21:16, Tomas Vondra wrote: On Sat, Sep 14, 2019 at 06:03:34PM +0200, Thomas Rosenstein wrote: Hi, so I got two questions: 1) I have multiple Postgresql Standby servers replicating over WAN, and

Re: Standby Replication and Replication Delay

2019-09-14 Thread Tomas Vondra
On Sat, Sep 14, 2019 at 09:26:26PM +0200, Thomas Rosenstein wrote: Hi Tomas, I'm using Postgresql 10.10 on the standbys and 10.5 on the primary. On 14 Sep 2019, at 21:16, Tomas Vondra wrote: On Sat, Sep 14, 2019 at 06:03:34PM +0200, Thomas Rosenstein wrote: Hi, so I got two questions: 1) I

Re: Standby Replication and Replication Delay

2019-09-14 Thread Tomas Vondra
On Sat, Sep 14, 2019 at 06:03:34PM +0200, Thomas Rosenstein wrote: Hi, so I got two questions: 1) I have multiple Postgresql Standby servers replicating over WAN, and I would like to reduce that to a single connection. Presumably the standbys are all located on the same LAN / in the same DC?

Standby Replication and Replication Delay

2019-09-14 Thread Thomas Rosenstein
Hi, so I got two questions: 1) I have multiple Postgresql Standby servers replicating over WAN, and I would like to reduce that to a single connection. Is there a utility that can be put in between and store the wal files from the primary and provide it to the standby server, even if they are