Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.

From: Shubham Khanna <khannashubham1197(at)gmail(dot)com>
To: Ajin Cherian <itsajin(at)gmail(dot)com>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.
Date: 2025-03-10 07:06:22
Message-ID: CAHv8Rj+37ja589BzqB5bz0ZYGWb5gpnP9of8SoqKc=DqLmvxBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 6, 2025 at 9:18 AM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
>
> On Fri, Feb 28, 2025 at 11:34 PM Shubham Khanna
> <khannashubham1197(at)gmail(dot)com> wrote:
> >
> >
> > The attached Patch contains the suggested changes.
> >
> > Thanks and regards,
> > Shubham Khanna.
>
> Some comments:
> 1.
> + <varlistentry>
> + <term><option>-a</option></term>
> + <term><option>--all</option></term>
> + <listitem>
> + <para>
> + For all source server non-template databases create subscriptions for
> + create subscriptions for databases with the same names on the
> + target server.
> + Subscription names, publication names, and replication slot names are
> + automatically generated. Cannot be used together with
> + <option>--database</option>, <option>--publication</option>,
> + <option>--replication-slot</option> or <option>--subscription</option>.
>
> Don't start the sentence with "Cannot". Change the sentence to "This
> option cannot be used together with ..."
> similar sentences used in 3 other places below this as well. Change all of them.
>

Fixed.

> 2.
> +# Verify that only user databases got subscriptions (not template databases)
>
> change to "Verify that only user databases have subscriptions"
>

Fixed.

The attached patch contains the suggested changes.

Thanks and regards,
Shubham Khanna.

Attachment Content-Type Size
v12-0001-Enhance-pg_createsubscriber-to-fetch-and-append-.patch application/octet-stream 41.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mats Kindahl 2025-03-10 07:08:09 Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py
Previous Message Shubham Khanna 2025-03-10 07:04:27 Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.