Improve documentation of upgrade for streaming replication section.
Hi,
Currently the documentation of upgrade for streaming replication
section says that logical replication slots will be copied
irrespective of the version, but the logical replication slots are
copied only if the old primary is version 17.0 or later. The changes
for the same are in the attached patch.
Thanks and Regards,
Shubham Khanna.
Attachments:
v1-0001-Improve-documentation-of-upgrade-for-streaming-re (2).patchapplication/octet-stream; name="v1-0001-Improve-documentation-of-upgrade-for-streaming-re (2).patch"Download
From 6f8ee97ae2895707facc36c256b3bfaed03020b8 Mon Sep 17 00:00:00 2001
From: Shubham Khanna <khannashubham1197@gmail.com>
Date: Fri, 9 Feb 2024 20:53:05 +0530
Subject: [PATCH v1] Improve documentation of upgrade for streaming replication
section.
Currently the documentation of upgrade for streaming replication section
says that logical replication slots will be copied, but the logical
replication slots are copied only if the old primary is version 17.0 or
later. The same has been updated.
---
doc/src/sgml/ref/pgupgrade.sgml | 9 ++++++---
1 file changed, 6 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml
index ae6d3c49a6..68ec68f47b 100644
--- a/doc/src/sgml/ref/pgupgrade.sgml
+++ b/doc/src/sgml/ref/pgupgrade.sgml
@@ -767,9 +767,12 @@ rsync --archive --delete --hard-links --size-only --no-inc-recursive /vol1/pg_tb
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 primary is prior to version 17.0, then no
+ slots on the primary are copied to the new standby, so all the slots on
+ the old standby must be recreated manually. If the old primary is
+ version 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>
</step>
--
2.34.1
On Fri, Feb 9, 2024 at 9:32 PM Shubham Khanna
<khannashubham1197@gmail.com> wrote:
Currently the documentation of upgrade for streaming replication
section says that logical replication slots will be copied
irrespective of the version, but the logical replication slots are
copied only if the old primary is version 17.0 or later. The changes
for the same are in the attached patch.
LGTM. I'll push this tomorrow unless I see any comments or objections
for the same.
--
With Regards,
Amit Kapila.
On Mon, Feb 12, 2024 at 7:59 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
On Fri, Feb 9, 2024 at 9:32 PM Shubham Khanna
<khannashubham1197@gmail.com> wrote:Currently the documentation of upgrade for streaming replication
section says that logical replication slots will be copied
irrespective of the version, but the logical replication slots are
copied only if the old primary is version 17.0 or later. The changes
for the same are in the attached patch.LGTM. I'll push this tomorrow unless I see any comments or objections
for the same.
Pushed!
--
With Regards,
Amit Kapila.