diff options
author | Bruce Momjian <bruce@momjian.us> | 2023-09-26 18:54:10 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2023-09-26 18:54:10 -0400 |
commit | b21ec201c0526d61ce22cb1f5e97df2c02279347 (patch) | |
tree | e3967b641569bc5b5d2ee866821ec53f08840ad4 | |
parent | 17cd48de3ce3061059257b56b4ae689e45137668 (diff) |
doc: pg_upgrade, clarify standby servers must remain running
Also mention that mismatching primary/standby LSNs should never
happen.
Reported-by: Nikolay Samokhvalov
Discussion: https://postgr.es/m/CAM527d8heqkjG5VrvjU3Xjsqxg41ufUyabD9QZccdAxnpbRH-Q@mail.gmail.com
Backpatch-through: 11
-rw-r--r-- | doc/src/sgml/ref/pgupgrade.sgml | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml index 7816b4c6859..f9c16a5cdb7 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -380,8 +380,8 @@ NET STOP postgresql-&majorversion; </para> <para> - Streaming replication and log-shipping standby servers can - remain running until a later step. + Streaming replication and log-shipping standby servers must be + running during this shutdown so they receive all changes. </para> </step> @@ -394,8 +394,6 @@ NET STOP postgresql-&majorversion; servers are caught up by running <application>pg_controldata</application> against the old primary and standby clusters. Verify that the <quote>Latest checkpoint location</quote> values match in all clusters. - (There will be a mismatch if old standby servers were shut down - before the old primary or if the old standby servers are still running.) Also, make sure <varname>wal_level</varname> is not set to <literal>minimal</literal> in the <filename>postgresql.conf</filename> file on the new primary cluster. |