Re: BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load - Mailing list pgsql-bugs

From Zane Duffield
Subject Re: BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load
Date
Msg-id CACMiCkW8_3RdjTw07Ds_REMHXH-6-GCvTO2M5Thy=Y8rHyydZw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load  (vignesh C <vignesh21@gmail.com>)
List pgsql-bugs
On Mon, Apr 28, 2025 at 2:58 PM vignesh C <vignesh21@gmail.com> wrote:
As an alternative, we could set recovery_target_inclusive to false in
the setup_recovery function. This way, recovery would stop just before
the recovery target, allowing the publisher to start replicating
exactly from the consistent point.
Thoughts?

This sounds to me like a simpler and more correct solution.

Thanks,
Zane

pgsql-bugs by date:

Previous
From: marcos sicat
Date:
Subject: Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE
Next
From: Pavel Stehule
Date:
Subject: Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE