Re: Improve documentation for pg_upgrade, standbys and rsync

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Improve documentation for pg_upgrade, standbys and rsync
Date: 2021-05-19 14:31:35
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-docs pgsql-hackers


* Laurenz Albe (laurenz(dot)albe(at)cybertec(dot)at) wrote:
> I revently tried to upgrade a standby following the documentation,
> but I found it hard to understand, and it took me several tries to
> get it right. This is of course owing to my lack of expertise with
> rsync, but I think the documentation and examples could be clearer.
> I think it would be a good idea to recommend the --relative option
> of rsync.
> Here is a patch that does that, as well as update the versions in
> the code samples to something more recent. Also, I think it makes
> sense to place the data directory in the sample in /var/lib/postgresql,
> which is similar to what many people will have in real life.

Haven't had a chance to look at this in depth but improving things here
would be good.

An additional thing that we should really be mentioning is to tell
people to go in and TRUNCATE all of their UNLOGGED tables before going
through this process, otherwise the rsync will end up spending a bunch
of time copying the files for UNLOGGED relations which you really don't



In response to


Browse pgsql-docs by date

  From Date Subject
Next Message Andrew Dunstan 2021-05-19 14:56:23 Re: Error building for 64-bit Windows (10)
Previous Message 2021-05-19 01:09:45 RE: typo in doc for "Miscellaneous Coding Conventions"

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2021-05-19 14:39:08 Re: PG 14 release notes, first draft
Previous Message vignesh C 2021-05-19 14:28:04 Re: Added missing tab completion for alter subscription set option