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>