postgres.git / summary / log / commit / refs
commit 813e08123bd9eb7d7eb7bc6eac43b74f5a9a1ef8
Author: Bruce Momjian <bruce@momjian.us>
Date: Tue Sep 01 20:42:43 2015 +0000
First released in: 9.6.0, 9.5.0
pg_upgrade docs: clarify rsync and move verification step
These are adjustments based on someone using the new standby upgrade
steps.
Report by Andy Colson
Backpatch through 9.5
doc/src/sgml/ref/pgupgrade.sgml | 33 ++++++++++++++++++---------------
1 file changed, 18 insertions(+), 15 deletions(-)
diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml
index ebc0d58887e..fcb03161edf 100644
--- a/doc/src/sgml/ref/pgupgrade.sgml
+++ b/doc/src/sgml/ref/pgupgrade.sgml
@@ -310,8 +310,21 @@ NET STOP postgresql-9.0
</para>
<para>
- Streaming replication and log-shipping standby servers can remain running until
- a later step.
+ Streaming replication and log-shipping standby servers can
+ remain running until a later step.
+ </para>
+ </step>
+
+ <step>
+ <title>Verify standby servers</title>
+
+ <para>
+ If you are upgrading Streaming Replication and Log-Shipping standby
+ servers, verify that the old standby servers are caught up by running
+ <application>pg_controldata</> against the old primary and standby
+ clusters. Verify that the <quote>Latest checkpoint location</>
+ values match in all clusters. (There will be a mismatch if old
+ standby servers were shut down before the old primary.)
</para>
</step>
@@ -404,7 +417,9 @@ pg_upgrade.exe
If you have Streaming Replication (<xref
linkend="streaming-replication">) or Log-Shipping (<xref
linkend="warm-standby">) standby servers, follow these steps to
- upgrade them (before starting any servers):
+ upgrade them. You will not be running <application>pg_upgrade</>
+ on the standby servers, but rather <application>rsync</>. Do not
+ start any servers yet.
</para>
<substeps>
@@ -447,18 +462,6 @@ pg_upgrade.exe
</para>
</step>
- <step>
- <title>Verify standby servers</title>
-
- <para>
- To prevent old standby servers from being modified, run
- <application>pg_controldata</> against the primary and standby
- clusters and verify that the <quote>Latest checkpoint location</>
- values match in all clusters. (This requires the standbys to be
- shut down after the primary.)
- </para>
- </step>
-
<step>
<title>Save configuration files</title>
[parent: b8a439b650c4]