Re: Issue with logical replication slot during switchover
| От | Fabrice Chapuis |
|---|---|
| Тема | Re: Issue with logical replication slot during switchover |
| Дата | |
| Msg-id | CAA5-nLAUgxXCKKH+Gv2sFgXXV4TAcb+qpwMpGZ9babEOGe5Bfw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Issue with logical replication slot during switchover (shveta malik <shveta.malik@gmail.com>) |
| Ответы |
Re: Issue with logical replication slot during switchover
|
| Список | 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
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 по дате отправления: