Re: Issue with logical replication slot during switchover - Mailing list pgsql-hackers

From Fabrice Chapuis
Subject Re: Issue with logical replication slot during switchover
Date
Msg-id CAA5-nLAUgxXCKKH+Gv2sFgXXV4TAcb+qpwMpGZ9babEOGe5Bfw@mail.gmail.com
Whole thread Raw
In response to Re: Issue with logical replication slot during switchover  (shveta malik <shveta.malik@gmail.com>)
Responses Re: Issue with logical replication slot during switchover
List pgsql-hackers
Hi, 
I indeed proposed a solution at the top of this thread to modify only the value of the synced attribute, but the discussion was redirected to adding an extra parameter to the function pg_create_logical_replication_slot() to overwrite a failover slot

Regards,

Fabrice

On Fri, Oct 31, 2025 at 5:32 AM shveta malik <shveta.malik@gmail.com> wrote:
On Tue, Oct 28, 2025 at 6:33 PM Alexander Kukushkin <cyberdemn@gmail.com> wrote:
>
> Hi all,
>
> I don't think we really need to have allow_overwrite.
> It is not possible to create logical slots on standby with failover=true, therefore we can safely rely on failover being true to understand that at some point this node was a primary and that this slot is supposed to be synced.
> Please see the patch attached.
>

We had discussed this point in another thread, please see [1]. After
discussion it was decided to not go this way.

[1]: https://www.postgresql.org/message-id/OS0PR01MB57161FF469DE049765DD53A89475A%40OS0PR01MB5716.jpnprd01.prod.outlook.com

thanks
Shveta

pgsql-hackers by date:

Previous
From: wenhui qiu
Date:
Subject: Re: Report oldest xmin source when autovacuum cannot remove tuples
Next
From: Chao Li
Date:
Subject: Re: Fully documenting the design of nbtree row comparison scan keys