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>

Reply via email to