Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size

From: Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>
To: Shubham Khanna <khannashubham1197(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size
Date: 2025-01-16 11:06:44
Message-ID: CANhcyEUPqtF6Ob0OTB+r+c-Nbo=_HENJ4cBhgiKk7Q47M3QmKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 16 Jan 2025 at 12:34, Shubham Khanna
<khannashubham1197(at)gmail(dot)com> wrote:
>
> On Thu, Jan 16, 2025 at 12:12 PM Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> wrote:
> >
> > On Thu, 16 Jan 2025 at 10:48, Shubham Khanna
> > <khannashubham1197(at)gmail(dot)com> wrote:
> > >
> > > On Wed, Jan 15, 2025 at 3:28 AM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> > > >
> > > > Hi Shubham.
> > > >
> > > > Patch v9-0001 LGTM.
> > > >
> > >
> > > Upon reviewing the v9-0001 patch, I noticed that running 'pg perltidy'
> > > was necessary. To ensure the patch adheres to the required coding
> > > standards, I have applied 'pg perltidy' and made the necessary
> > > adjustments.
> > > The attached patch includes these formatting fixes along with the
> > > latest changes.
> > >
> > Hi Shubham,
> >
> > I reviewed the v10 patch. I have following comments:
> >
> > 1. The documentation is added under the prerequisite section. And the
> > prerequisite section states that
> > ' There are some prerequisites for
> > <application>pg_createsubscriber</application> to convert the target server
> > into a logical replica. If these are not met, an error will be reported.'
> >
> > But for our case we are giving a warning only during the dry run. So,
> > I feel we should add the documentation under the 'Warnings' section.
> >
> > 2. Spacing is not consistent with the rest of document:
> >
> > + Replication failures can occur if required WAL files are missing. To prevent
> > + this, the source server must set <xref
> > linkend="guc-max-slot-wal-keep-size"/>
> > + to <literal>-1</literal> to ensure that required WAL files are not
> > + prematurely removed.
> >
> > For the above added line, we should add a space before each line.
> >
>
> Fixed the given comments. The attached patch contains the suggested changes.
>
Hi Shubham,

I reviewed the v11 patch and it looks good to me.

Thanks and Regards,
Shlok Kyal

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shubham Khanna 2025-01-16 11:16:06 Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.
Previous Message Amit Kapila 2025-01-16 10:56:39 Re: Conflict detection for update_deleted in logical replication