diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml new file mode 100644 index 60011d8..146b3af *** a/doc/src/sgml/ref/pgupgrade.sgml --- b/doc/src/sgml/ref/pgupgrade.sgml *************** NET STOP postgresql-&majorversion; *** 320,339 **** Prepare for standby server upgrades ! If you are upgrading standby servers (as outlined in section ), verify that the old standby servers are caught up by running pg_controldata against the old primary and standby clusters. Verify that the Latest checkpoint location values match in all clusters. (There will be a mismatch if old standby servers were shut down before the old primary.) - - - Also, if upgrading standby servers, change wal_level - to replica in the postgresql.conf file on - the new primary cluster. - --- 320,333 ---- Prepare for standby server upgrades ! If you are upgrading standby servers using methods outlined in section , verify that the old standby servers are caught up by running pg_controldata against the old primary and standby clusters. Verify that the Latest checkpoint location values match in all clusters. (There will be a mismatch if old standby servers were shut down before the old primary.) *************** pg_upgrade.exe *** 423,434 **** If you used link mode and have Streaming Replication (see ) or Log-Shipping (see ) standby servers, follow these steps to ! upgrade them. You will not be running pg_upgrade on the standby servers, but rather rsync on the primary. ! Do not start any servers yet. If you did not use link ! mode, skip the instructions in this section and simply recreate the ! standby servers. --- 417,434 ---- If you used link mode and have Streaming Replication (see ) or Log-Shipping (see ) standby servers, you can follow these steps to ! quickly upgrade them. You will not be running pg_upgrade on the standby servers, but rather rsync on the primary. ! Do not start any servers yet. ! ! ! ! If you did not use link mode, do not have or do not ! want to use rsync, or want an easier solution, skip ! the instructions in this section and simply recreate the standby ! servers once pg_upgrade completes and the new primary ! is running. *************** pg_upgrade.exe *** 448,454 **** Make sure the new standby data directories do not exist or are empty. If initdb was run, delete ! the standby server data directories. --- 448,454 ---- Make sure the new standby data directories do not exist or are empty. If initdb was run, delete ! the standby servers' new data directories. *************** pg_upgrade.exe *** 474,482 **** Save configuration files ! Save any configuration files from the standbys you need to keep, ! e.g. postgresql.conf, recovery.conf, ! as these will be overwritten or removed in the next step. --- 474,483 ---- Save configuration files ! Save any configuration files from the old standbys' data ! directories you need to keep, e.g. postgresql.conf, ! recovery.conf, because these will be overwritten or ! removed in the next step. *************** rsync --archive --delete --hard-links -- *** 507,512 **** --- 508,519 ---- /opt/PostgreSQL/9.6/data standby.example.com:/opt/PostgreSQL + You can verify what the command will do using + rsync's