diff options
| author | Bruce Momjian <bruce@momjian.us> | 2018-08-25 13:35:14 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2018-08-25 13:35:14 -0400 |
| commit | cc2e457fe8a3f685b4f9b9dce05b0c027b39459f (patch) | |
| tree | 5cd14b11891f580a50b3c707d414dd0829ca95eb | |
| parent | dcb2efdbdd8fe46be35069ea58acebbc4ff2723a (diff) | |
| download | postgresql-cc2e457fe8a3f685b4f9b9dce05b0c027b39459f.tar.gz postgresql-cc2e457fe8a3f685b4f9b9dce05b0c027b39459f.zip | |
doc: "Latest checkpoint location" will not match in pg_upgrade
Mention that "Latest checkpoint location" will not match in pg_upgrade
if the standby server is still running during the upgrade, which is
possible. "Match" text first appeared in PG 9.5.
Reported-by: Paul Bonaud
Discussion: https://postgr.es/m/c7268794-edb4-1772-3bfd-04c54585c24e@trainline.com
Backpatch-through: 9.5
| -rw-r--r-- | doc/src/sgml/ref/pgupgrade.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml index 6dafb404a11..d51146d641d 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -326,7 +326,8 @@ NET STOP postgresql-&majorversion; 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.) Also, change <varname>wal_level</varname> to + before the old primary or if the old standby servers are still running.) + Also, change <varname>wal_level</varname> to <literal>replica</literal> in the <filename>postgresql.conf</filename> file on the new primary cluster. </para> |