postgres.git / summary / log / commit / refs

commit    3e8382996ffaea16e4202172d32ca72b672056b4
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sat Aug 25 17:35:14 2018 +0000

    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


doc/src/sgml/ref/pgupgrade.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml index 6816abad489..ac3e08300da 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -326,7 +326,8 @@ NET STOP postgresql-9.0 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.) Also, change <varname>wal_level</> to + before the old primary or if the old standby servers are still running.) + Also, change <varname>wal_level</varname> to <literal>hot_standby</> in the <filename>postgresql.conf</> file on the new primary cluster. </para> [parent: 56c1d751cf16]