Re: issue with synchronized_standby_slots

From: Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, Alexander Kukushkin <cyberdemn(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: issue with synchronized_standby_slots
Date: 2025-10-23 08:14:50
Message-ID: CANhcyEV9PKOLu8uaKHab4Py9bBTyOfRSVv02Ug-tnxRobWryQw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 23 Oct 2025 at 13:19, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> wrote:
>
> On Thu, 23 Oct 2025 at 09:36, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > On Thu, Oct 9, 2025 at 10:53 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > >
> > > On Wed, Oct 8, 2025 at 9:05 PM Fabrice Chapuis <fabrice636861(at)gmail(dot)com> wrote:
> > > >
> > > > As Ashutosh suggests I will go more for the backpatching approach because the synchronized_standby_slots parameter impacts the last 2 major versions and this problem is critical on production environments.
> > > >
> > >
> > > Fair enough. Let's wait for the related issue being discussed in email
> > > [1] to be fixed.
> > >
> >
> > As the other patch is committed
> > (f33e60a53a9ca89b5078df49416acae20affe1f5), can you update and prepare
> > backbranch patches for this fix as well?
> >
> Hi Amit,
>
> Please find the updated patch.
>
> v6-0001 : It applies on HEAD and REL_18_STABLE branches
> v6_REL_17-0001 : It applies on REL_17_STABLE branch.
>
> Since this GUC was introduced in PG_17, we do not need to back-patch
> to PG_16 or prior.
>
The CFbot was failing due to the merge conflict. It happened because
CFbot tried to apply v6_REL_17 on top of v6-0001 patch. Added
v6_REL_17 as a .txt file so this merge conflict do not happen.

Thanks,
Shlok Kyal

Attachment Content-Type Size
v6_REL_17-0001-Remove-the-validation-from-the-GUC-check-h.txt text/plain 5.5 KB
v6-0001-Remove-the-validation-from-the-GUC-check-hook-and.patch application/octet-stream 6.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2025-10-23 08:15:01 RE: issue with synchronized_standby_slots
Previous Message shveta malik 2025-10-23 08:12:43 Re: POC: enable logical decoding when wal_level = 'replica' without a server restart