Re: Documentation to upgrade logical replication cluster

vignesh C <vignesh21@gmail.com>

From: vignesh C <vignesh21@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>, "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Date: 2024-09-20T12:04:52Z
Lists: pgsql-hackers

Attachments

On Fri, 20 Sept 2024 at 16:24, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Mon, May 6, 2024 at 10:40 AM vignesh C <vignesh21@gmail.com> wrote:
> >
> > The v9 version patch was not applying on top of HEAD because of few
> > commits, the updated v10 version patch is rebased on top of HEAD.
> >
>
> Let's say publisher is in <literal>node1</literal> and subscriber is
> +      in <literal>node2</literal>. The subscriber <literal>node2</literal> has
> +      two subscriptions <literal>sub1_node1_node2</literal> and
> +      <literal>sub2_node1_node2</literal> which are subscribing the changes
> +      from <literal>node1</literal>.
>
> Do we need to show multiple subscriptions? You are following the same
> steps for both subscriptions, so it may not add much value to show
> steps for two subscriptions. You can write steps for one and add a
> note to say it has to be done for other subscriptions present.

I didn’t include a note because each disable/enable statement
specifies: a) Disable all subscriptions on the node, b) Enable all
subscriptions on the node. The attached v11 version patch just to show
the examples with one subscription.

Regards,
Vignesh

Commits

  1. Doc: Add a note in the upgrade of logical replication clusters.

  2. Doc: Add the steps for upgrading the logical replication cluster.