diff options
| author | Bruce Momjian <bruce@momjian.us> | 2015-09-01 16:42:43 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2015-09-01 16:42:43 -0400 |
| commit | 46bd95e2a873feb4799b77eca7276cf758e36cca (patch) | |
| tree | bcb98b7ebd053a46e9f4d3c3baf6a30c7ce1e64f | |
| parent | 8a02b3d732cf3ec13e089768bf9ce9abbdcc8a3e (diff) | |
| download | postgresql-46bd95e2a873feb4799b77eca7276cf758e36cca.tar.gz postgresql-46bd95e2a873feb4799b77eca7276cf758e36cca.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/pgupgrade.sgml | 33 |
1 files 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> @@ -448,18 +463,6 @@ pg_upgrade.exe </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> <para> |