postgres.git / summary / log / commit / refs

commit    474d8102466e7d3a4aaa9ec4e68d38371247faac
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 302e543e426..975236774f9 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</> 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>replica</> in the <filename>postgresql.conf</> file on the new primary cluster. </para> [parent: 943f75d543e1]