MIME-Version: 1.0
References: <175682776043.778.6556350471379069615@wrigleys.postgresql.org>
 <f80622aa9f68adb5e3434b1471a91b96f1fc3c8a.camel@cybertec.at>
In-Reply-To: <f80622aa9f68adb5e3434b1471a91b96f1fc3c8a.camel@cybertec.at>
From: David Booth <davidnbooth@gmail.com>
Date: Wed, 3 Sep 2025 16:45:56 -0400
Message-ID: 
 <CAJSePyew0BZW7wrhBzDAkvWFaH2yVJZW+NXKrF5XzQv1DL2CBA@mail.gmail.com>
Subject: Re: pg_upgrade, can you use the rsync method of upgrading a standby
 if you used clone mode?
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000bf8b71063debb18b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJSePyew0BZW7wrhBzDAkvWFaH2yVJZW%2BNXKrF5XzQv1DL2CBA%40mail.gmail.com>
Precedence: bulk

--000000000000bf8b71063debb18b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks for the feedback Laurenz!  I will avoid this procedure for my
upgrades then.

On Wed, Sep 3, 2025 at 3:44=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec.=
at>
wrote:

> On Tue, 2025-09-02 at 15:42 +0000, PG Doc comments form wrote:
> > In the documentation for pgupgrade
> > (https://www.postgresql.org/docs/17/pgupgrade.html), step 13 gives
> > instructions for quickly upgrading standby servers with rsync, and says
> that
> > it only works if you used link mode.  However, step 12 gives the
> impression
> > that clone mode is very similar to link mode.  I think the documentatio=
n
> for
> > step 13 would be improved by explicitly stating whether clone mode is
> > compatible with the rsync method or not.
>
> That would be interesting to know, right.
>
> But after the slightly frustrating experience that I had when I tried to
> improve that section of the documentation [1], I am not sure if it would
> be wise to recommend the rsync procedure in more cases.
>
> The sentence from the thread that stuck in my memory was Robert Haas'
>
>   Also, let me express my general terror at the idea of anyone actually
>   using this procedure.
>
> Yours,
> Laurenz Albe
>
>
>  [1]:
> https://www.postgresql.org/message-id/flat/22f129004bb66cd91e1dfd3345a978=
7f5039f3ae.camel%40cybertec.at
>

--000000000000bf8b71063debb18b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks for the feedback Laurenz!=C2=A0 I will avoid this p=
rocedure for my upgrades then.</div><br><div class=3D"gmail_quote gmail_quo=
te_container"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Sep 3, 2025 at =
3:44=E2=80=AFAM Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at=
">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex">On Tue, 2025-09-02 at 15:42 +0000, PG Doc comment=
s form wrote:<br>
&gt; In the documentation for pgupgrade<br>
&gt; (<a href=3D"https://www.postgresql.org/docs/17/pgupgrade.html" rel=3D"=
noreferrer" target=3D"_blank">https://www.postgresql.org/docs/17/pgupgrade.=
html</a>), step 13 gives<br>
&gt; instructions for quickly upgrading standby servers with rsync, and say=
s that<br>
&gt; it only works if you used link mode.=C2=A0 However, step 12 gives the =
impression<br>
&gt; that clone mode is very similar to link mode.=C2=A0 I think the docume=
ntation for<br>
&gt; step 13 would be improved by explicitly stating whether clone mode is<=
br>
&gt; compatible with the rsync method or not.<br>
<br>
That would be interesting to know, right.<br>
<br>
But after the slightly frustrating experience that I had when I tried to<br=
>
improve that section of the documentation [1], I am not sure if it would<br=
>
be wise to recommend the rsync procedure in more cases.<br>
<br>
The sentence from the thread that stuck in my memory was Robert Haas&#39;<b=
r>
<br>
=C2=A0 Also, let me express my general terror at the idea of anyone actuall=
y<br>
=C2=A0 using this procedure.<br>
<br>
Yours,<br>
Laurenz Albe<br>
<br>
<br>
=C2=A0[1]: <a href=3D"https://www.postgresql.org/message-id/flat/22f129004b=
b66cd91e1dfd3345a9787f5039f3ae.camel%40cybertec.at" rel=3D"noreferrer" targ=
et=3D"_blank">https://www.postgresql.org/message-id/flat/22f129004bb66cd91e=
1dfd3345a9787f5039f3ae.camel%40cybertec.at</a><br>
</blockquote></div>

--000000000000bf8b71063debb18b--