Re: Fix slot synchronization with two_phase decoding enabled

From: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
To: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix slot synchronization with two_phase decoding enabled
Date: 2025-04-29 12:00:03
Message-ID: CABdArM56P3sZ-5z0NXWa7V=4DYFWgkAxgwDP0vC8hY60rj_xtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Apr 29, 2025 at 2:51 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> On Mon, Apr 28, 2025 at 4:33 PM Nisha Moond <nisha(dot)moond412(at)gmail(dot)com> wrote:
> >
> > Please find the v9 patch, addressing the above and all other comments as well.
> >
>
> Thanks for the patch.
>
> 1)
>
> + The default is false. This option cannot be set together with
> + <literal>two_phase</literal> when creating the slot. However, once
> + the slot is created with <literal>two_phase=true</literal>, the
> + <literal>failover</literal> can be set to true after the
> + <literal>restart_lsn</literal> has advanced beyond its
> + <literal>two_phase_at</literal> value
>
> As the user is not aware of two_phase_at, we shall change all the docs
> to have a more user friendly explanation.
>

Done.

> 2)
> # Confirm that the invalidated slot has been dropped.
> $standby1->wait_for_log(
> - qr/dropped replication slot "lsub1_slot" of database with OID
> [0-9]+/, $log_offset);
> + qr/dropped replication slot "lsub1_slot" of database with OID [0-9]+/,
> + $log_offset);
>
> I think this change is not needed.
>

The perltidy is auto-correcting it now, though it didn't for earlier
patches. I've kept the original for now.
~~~

Thanks for review, please find the updated patch v10.

--
Thanks,
Nisha

Attachment Content-Type Size
v10-0001-PG17-Approach-3-Fix-slot-synchronization-for-two.patch application/x-patch 23.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2025-04-29 12:01:09 Re: POC: make mxidoff 64 bits
Previous Message Alexander Korotkov 2025-04-29 11:27:25 Re: Implement waiting for wal lsn replay: reloaded