Re: Improve documentation for pg_upgrade, standbys and rsync

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

On Wed, 2021-05-19 at 10:31 -0400, Stephen Frost wrote:
> * 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, [...]
>
> 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
> want.

Thanks for the feedback and the suggestion.
CCing -hackers so that I can add it to the commitfest.

Yours,
Laurenz Albe

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Michael Paquier 2021-05-20 00:05:16 Re: Error building for 64-bit Windows (10)
Previous Message Andrew Dunstan 2021-05-19 14:56:23 Re: Error building for 64-bit Windows (10)

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2021-05-19 16:58:12 Commitfest app vs. pgsql-docs
Previous Message Bharath Rupireddy 2021-05-19 16:18:56 Re: Inaccurate error message when set fdw batch_size to 0