postgres.git / summary / log / commit / refs

commit    cc2e457fe8a3f685b4f9b9dce05b0c027b39459f
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 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> [parent: dcb2efdbdd8f]