Re: Documentation to upgrade logical replication cluster

Amit Kapila <amit.kapila16@gmail.com>

From: Amit Kapila <amit.kapila16@gmail.com>
To: vignesh C <vignesh21@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-25T08:36:44Z
Lists: pgsql-hackers
On Tue, Sep 24, 2024 at 9:42 PM vignesh C <vignesh21@gmail.com> wrote:
>
> Reordered the docs to enable the subscription before creating the
> table. For bi-directional replication, a publication refresh is
> necessary on both nodes: a) First, refresh the publication on the old
> version server to set the newly added tables to a ready state in the
> pg_subscription_rel catalog.
>

This is not required for table-specific publications and isn't needed
for the examples mentioned in the patch. So, I have removed this part
and pushed the patch. BTW, you choose to upgrade the publisher first
but one can upgrade the subscriber first as well. If so, we can add a
note to the documentation.

-- 
With Regards,
Amit Kapila.



Commits

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

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