public inbox for [email protected]  

help / color / mirror / Atom feed
From: David Booth <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: pg_upgrade, can you use the rsync method of upgrading a standby if you used clone mode?
Date: Wed, 3 Sep 2025 16:45:56 -0400
Message-ID: <CAJSePyew0BZW7wrhBzDAkvWFaH2yVJZW+NXKrF5XzQv1DL2CBA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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

On Wed, Sep 3, 2025 at 3:44 AM Laurenz Albe <[email protected]>
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 documentation
> 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/22f129004bb66cd91e1dfd3345a9787f5039f3ae.camel%40cybertec...
>


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_upgrade, can you use the rsync method of upgrading a standby if you used clone mode?
  In-Reply-To: <CAJSePyew0BZW7wrhBzDAkvWFaH2yVJZW+NXKrF5XzQv1DL2CBA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox