public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: pg_upgrade, can you use the rsync method of upgrading a standby if you used clone mode?
Date: Wed, 03 Sep 2025 09:44:43 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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: <[email protected]>

* 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