Re: Issue with logical replication slot during switchover

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
Cc: 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-09-30 09:44:57
Message-ID: CAJpy0uBVKEr1mM_nbjZ2W+Ugu+PsgwPnDT1wqL9KvNgkwst0Jw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 30, 2025 at 3:11 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> On Tue, Sep 30, 2025 at 12:17 PM Fabrice Chapuis
> <fabrice636861(at)gmail(dot)com> wrote:
> >
> > Hi,
> >
> > Here the generated v2 of the Patch.
> >
>
> Thanks. I have refactored the code for synchronize_one_slot() as there
> was some code-repetition. Please take it if you find it okay.
>
> Also I felt that when we create a slot through slot-synchronization,
> we should create it with allow_overwrite as false. And thus in the
> attached patch, I have changed that part as well.
>
> It is a top up patch. Attached it as txt, please rename before
> applying atop your changes. Attached the steps for your reference.
>

Next, pg_replication_slots (pg_get_replication_slots) can be modified
to display the new property. And the corresponding doc for
pg_replication_slots (doc/src/sgml/system-views.sgml) can be updated.

thanks
Shveta

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Frits Hoogland 2025-09-30 10:01:40 The ability of postgres to determine loss of files of the main fork
Previous Message shveta malik 2025-09-30 09:41:05 Re: Issue with logical replication slot during switchover