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, T

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 ove

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

Re: Logical Replication and triggers

2017-11-21 Thread Thomas Rosenstein
On 22 November 2017 at 08:35, Robert Haas wrote: On Tue, Nov 21, 2017 at 4:28 PM, Simon Riggs wrote: I would have acted on this myself a few days back if I thought the patch was correct, but I see multiple command counter increments there, so suspect an alternate fix is correct. Oh, well, I'

Re: Logical Replication and triggers

2017-11-21 Thread Thomas Rosenstein
On Tue, Nov 21, 2017 at 3:29 PM, Simon Riggs wrote: You realize we're talking about a bug fix, right? And for a feature that was developed and committed by your colleagues? Craig is asking Thomas to confirm the proposed bug fix works. How is this not normal? That's not exactly how I read Cr

Logical Replication and triggers

2017-11-15 Thread Thomas Rosenstein
I would like somebody to consider Petr Jelineks patch for worker.c from here (https://www.postgresql.org/message-id/619c557d-93e6-1833-1692-b010b176ff77%402ndquadrant.com) I'm was facing the same issue with 10.1 and BEFORE INSERT OR UPDATE triggers. BR Thomas Rosenstein