Re: Documentation to upgrade logical replication cluster

From: vignesh C <vignesh21(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Subject: Re: Documentation to upgrade logical replication cluster
Date: 2024-09-20 12:04:52
Message-ID: CALDaNm3whMgUUYBAwMJzbtubWLnbWFJkHKhxv817eg69UK_ysg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 20 Sept 2024 at 16:24, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Mon, May 6, 2024 at 10:40 AM vignesh C <vignesh21(at)gmail(dot)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

Attachment Content-Type Size
v11-0001-Documentation-for-upgrading-logical-replication-.patch text/x-patch 32.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2024-09-20 12:06:27 Re: SQLFunctionCache and generic plans
Previous Message Alexander Korotkov 2024-09-20 12:00:20 Re: pgsql: Implement pg_wal_replay_wait() stored procedure