From: | Shubham Khanna <khannashubham1197(at)gmail(dot)com> |
---|---|
To: | Shlok Kyal <shlok(dot)kyal(dot)oss(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 07:04:23 |
Message-ID: | CAHv8RjKxeXN9XaOG4kq64uQ7kmgrKHpZf9APfKQ5=2bA6na5SA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
Thanks and regards,
Shubham Khanna.
Attachment | Content-Type | Size |
---|---|---|
v11-0001-Validate-max_slot_wal_keep_size-in-pg_createsubs.patch | application/octet-stream | 7.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Nisha Moond | 2025-01-16 07:05:16 | Re: Introduce XID age and inactive timeout based replication slot invalidation |
Previous Message | Bertrand Drouvot | 2025-01-16 06:48:58 | Re: per backend I/O statistics |