Hello All, Please find attached a patch that explains Log-Shipping standby server major upgrades. We agreed to do this in https://www.postgresql.org/message-id/CAA4eK1%2Bo6ErVAh484VtE91wow1-uOysohSvb0TS52Ei76PzOKg%40mail.gmail.com
Thanks, Konstantin Evteev
diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml index 0c4b16d32c..de0046c482 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -346,7 +346,7 @@ NET STOP postgresql-&majorversion; </para> </step> - <step> + <step id="pgupgrade-step-prepare-standby-server-upgrades"> <title>Prepare for standby server upgrades</title> <para> @@ -361,6 +361,20 @@ NET STOP postgresql-&majorversion; <literal>replica</literal> in the <filename>postgresql.conf</filename> file on the new primary cluster. </para> + + <caution> + <para> + If you use Log-Shipping standby servers (without streaming), the last + file in which shutdown checkpoint record is written won't be archived. + To make the standby servers caught up you need to copy the last WAL + file from primary to the standby servers and wait till it is applied. + After that standby servers can issue restartpoint at the same location + as in the stopped master. As alternative before <xref + linkend="pgupgrade-step-prepare-standby-server-upgrades"/> you can + switch from Log-Shipping + to Streaming Replication. + </para> + </caution> </step> <step>