From: | Peter Smith <smithpb2250(at)gmail(dot)com> |
---|---|
To: | vignesh C <vignesh21(at)gmail(dot)com> |
Cc: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Documentation to upgrade logical replication cluster |
Date: | 2024-01-29 01:04:18 |
Message-ID: | CAHut+Pudr6H-MBurXXGpw-bkc0K9QPGPFr7khv7rVrQwEwByKw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Vignesh,
Here are some review comments for patch v4.
These are cosmetic only; otherwise v4 LGTM.
======
doc/src/sgml/ref/pgupgrade.sgml
1.
Configure the servers for log shipping. (You do not need to run
<function>pg_backup_start()</function> and
<function>pg_backup_stop()</function>
or take a file system backup as the standbys are still synchronized
- with the primary.) Only logical slots on the primary are copied to the
- new standby, but other slots on the old standby are not copied so must
- be recreated manually.
+ with the primary.) If the old cluster is prior to 17.0, then no slots
+ on the primary are copied to the new standby, so all the slots must be
+ recreated manually. If the old cluster is 17.0 or later, then only
+ logical slots on the primary are copied to the new standby, but other
+ slots on the old standby are not copied so must be recreated manually.
</para>
Perhaps the part from "If the old cluster is prior..." should be in a
new paragraph.
======
doc/src/sgml/logical-replication.sgml
2.
+ <para>
+ Setup the <link linkend="logical-replication-config-subscriber">
+ subscriber configurations</link> in the new subscriber.
+ <application>pg_upgrade</application> attempts to migrate subscription
+ dependencies which includes the subscription's table information present in
+ <link linkend="catalog-pg-subscription-rel">pg_subscription_rel</link>
+ system catalog and also the subscription's replication origin. This allows
+ logical replication on the new subscriber to continue from where the
+ old subscriber was up to. Migration of subscription dependencies is only
+ supported when the old cluster is version 17.0 or later. Subscription
+ dependencies on clusters before version 17.0 will silently be ignored.
+ </para>
Perhaps the part from "pg_upgrade attempts..." should be in a new paragraph.
======
Kind Regards,
Peter Smith.
Fujitsu Australia
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira | 2024-01-29 01:10:45 | Re: speed up a logical replica setup |
Previous Message | David G. Johnston | 2024-01-29 00:19:47 | Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row |