Date: Fri, 28 Jul 2017 16:35:08 +0200 (CEST)
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-hackers@postgresql.org
Message-ID: <VisenaEmail.10.2b4049e43870bd16.15d898d696f@tc7-visena>
Subject: Clarification in pg10's pgupgrade.html step 10 (upgrading standby
 servers)
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_77_1040031328.1501252508938"
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

------=_Part_75_27070484.1501252508928
Content-Type: multipart/related; 
	boundary="----=_Part_76_238465399.1501252508928"

------=_Part_76_238465399.1501252508928
Content-Type: multipart/alternative; 
	boundary="----=_Part_77_1040031328.1501252508938"

------=_Part_77_1040031328.1501252508938
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi -hackers.
=C2=A0
I'm reading https://www.postgresql.org/docs/10/static/pgupgrade.html=C2=A0t=
o try to=20
understand how to upgrade standby-servers using pg_upgrade with pg10.
=C2=A0
The text in step 10 sais:
"You will not be running pg_upgrade on the standby servers, but rather rsyn=
c",=20
which to me sounds like rsync, in step 10-f, should be issued on the standy=
=20
servers. Is this the case? If so I don't understand how the standby's data =
is=20
upgraded and what "remote_dir" is. If rsync is supposed to be issued on the=
=20
primary then I think it should be explicitly mentioned, and step 10-f shoul=
d=20
provide a clarer example with more detailed values for the directory-struct=
ures=20
involved.
=C2=A0
I really think section 10 needs improvement as I'm certainly not comfortabl=
e=20
upgrading standbys following the existing procedure.
=C2=A0
Thanks.
=C2=A0
--
Andreas Joseph Krogh

------=_Part_77_1040031328.1501252508938
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>Hi -hackers.</div>

<div>=C2=A0</div>

<div>I'm reading https://www.postgresql.org/docs/10/static/pgupgrade.html=
=C2=A0to try to understand how to upgrade standby-servers using pg_upgrade =
with pg10.</div>

<div>=C2=A0</div>

<div>The text in step 10 sais:</div>

<div>&quot;You will not be running pg_upgrade on the standby servers, but r=
ather rsync&quot;, which to me sounds like rsync, in step 10-f, should be i=
ssued on the standy servers. Is this the case? If so I don't understand how=
 the standby's data is upgraded and what &quot;remote_dir&quot; is. If rsyn=
c is supposed to be issued on the primary then I think it should be explici=
tly mentioned, and step 10-f should provide a clarer example with more deta=
iled values for the directory-structures involved.</div>

<div>=C2=A0</div>

<div>I really think section 10 needs improvement as I'm certainly not comfo=
rtable upgrading standbys following the existing procedure.</div>

<div>=C2=A0</div>

<div>Thanks.</div>

<div>=C2=A0</div>

<div class=3D"origo-email-signature">--</div>

<div class=3D"origo-email-signature">Andreas Joseph Krogh</div>
------=_Part_77_1040031328.1501252508938--

------=_Part_76_238465399.1501252508928--

------=_Part_75_27070484.1501252508928--