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-nLB822QxuU3AyXxKKO6tcQZavY_dhUBPXZhRMzvJ3H6RQQ@mail.gmail.com
Whole thread Raw
In response to Re: Issue with logical replication slot during switchover  (shveta malik <shveta.malik@gmail.com>)
List pgsql-hackers
Hi Shveta,
Here is the v4 of the patch with pg_replication_slots view modified to display the field allow_overwrite. Doc was also updated.

Regards,

Fabrice

On Tue, Sep 30, 2025 at 11:45 AM shveta malik <shveta.malik@gmail.com> wrote:
On Tue, Sep 30, 2025 at 3:11 PM shveta malik <shveta.malik@gmail.com> wrote:
>
> On Tue, Sep 30, 2025 at 12:17 PM Fabrice Chapuis
> <fabrice636861@gmail.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
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Add stats_reset to pg_stat_all_tables|indexes and related views
Next
From: Daniel Gustafsson
Date:
Subject: Re: Support getrandom() for pg_strong_random() source