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 | 29dec9f04313fff014a43941edd1ebfeaeecb20e (patch) | |
| tree | 3af8ac6a2c364ea2c2c0de9657d14d7021b4a9fa | |
| parent | 3a9a1b821e07f1d223d2161e46286ee8d134163c (diff) | |
| download | postgresql-29dec9f04313fff014a43941edd1ebfeaeecb20e.tar.gz postgresql-29dec9f04313fff014a43941edd1ebfeaeecb20e.zip | |
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 8f7a3025c36..a38a8a977e5 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -370,8 +370,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> @@ -384,8 +384,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. |