pg_upgrade, can you use the rsync method of upgrading a standby if you used clone mode?
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/pgupgrade.html
Description:
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.
Thanks!
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]/messages/by-id/22f129004bb66cd91e1dfd3345a9787f5039f3ae.camel@cybertec.at, 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]: /messages/by-id/22f129004bb66cd91e1dfd3345a9787f5039f3ae.camel@cybertec.at
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 <laurenz.albe@cybertec.at>
wrote:
Show quoted text
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 saysthat
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]:
/messages/by-id/22f129004bb66cd91e1dfd3345a9787f5039f3ae.camel@cybertec.at