Re: Issue with logical replication slot during switchover

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: Alexander Kukushkin <cyberdemn(at)gmail(dot)com>
Cc: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: Issue with logical replication slot during switchover
Date: 2025-10-31 04:31:55
Message-ID: CAJpy0uBrEFeHz5VmOez17fSg0hHf7czcnUGcNJ7gZoz_+cfW0w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 28, 2025 at 6:33 PM Alexander Kukushkin <cyberdemn(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2025-10-31 04:40:52 Re: Logical Replication of sequences
Previous Message Bertrand Drouvot 2025-10-31 04:31:41 Re: Consistently use the XLogRecPtrIsInvalid() macro