Re: Improve documentation for pg_upgrade, standbys and rsync

2022-04-07 Thread Laurenz Albe
On Tue, 2022-04-05 at 13:10 -0400, Stephen Frost wrote: > * Robert Haas (robertmh...@gmail.com) wrote: > On Mon, Jul 26, 2021 at 3:11 PM Stephen Frost wrote: > > * Laurenz Albe (laurenz.a...@cybertec.at) wrote: > > > > Thanks for looking at this! > > > > > > Sure.  Thanks for working on it! > >

Re: Improve documentation for pg_upgrade, standbys and rsync

2022-04-06 Thread Laurenz Albe
On Tue, 2022-04-05 at 12:38 -0400, Robert Haas wrote: > Also, let me express my general terror at the idea of anyone actually > using this procedure. I did, and I couldn't get it to work with absolute paths, and using relative paths seemed to me to be more intuitive anyway, hence the patch.

Re: Improve documentation for pg_upgrade, standbys and rsync

2022-04-05 Thread Bruce Momjian
On Tue, Apr 5, 2022 at 01:10:38PM -0400, Stephen Frost wrote: > To be more explicit though- we should write a tool to do this. We > shouldn't try to document a way to do it because it's hard to get right. > While rsync is very capable, what's needed to really do this goes beyond > what we could

Re: Improve documentation for pg_upgrade, standbys and rsync

2022-04-05 Thread Stephen Frost
Greetings, * Robert Haas (robertmh...@gmail.com) wrote: > On Mon, Jul 26, 2021 at 3:11 PM Stephen Frost wrote: > > * Laurenz Albe (laurenz.a...@cybertec.at) wrote: > > > Thanks for looking at this! > > > > Sure. Thanks for working on it! > > Stephen, do you intend to do something about this

Re: Improve documentation for pg_upgrade, standbys and rsync

2022-04-05 Thread Robert Haas
On Mon, Jul 26, 2021 at 3:11 PM Stephen Frost wrote: > * Laurenz Albe (laurenz.a...@cybertec.at) wrote: > > Thanks for looking at this! > > Sure. Thanks for working on it! Stephen, do you intend to do something about this patch in terms of getting it committed? You're the only reviewer but

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-08-18 Thread Laurenz Albe
On Mon, 2021-07-26 at 15:11 -0400, Stephen Frost wrote: > > > > > 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 > >

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-07-22 Thread Laurenz Albe
Thanks for looking at this! On Fri, 2021-07-16 at 09:17 -0400, Stephen Frost wrote: > > > 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

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-07-16 Thread Stephen Frost
Greetings, * Laurenz Albe (laurenz.a...@cybertec.at) wrote: > On Wed, 2021-05-19 at 10:31 -0400, Stephen Frost wrote: > > * Laurenz Albe (laurenz.a...@cybertec.at) wrote: > > > I revently tried to upgrade a standby following the documentation, > > > but I found it hard to understand, and it took

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-07-15 Thread Laurenz Albe
On Wed, 2021-05-19 at 10:31 -0400, Stephen Frost wrote: > * Laurenz Albe (laurenz.a...@cybertec.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

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-05-19 Thread Laurenz Albe
On Wed, 2021-05-19 at 10:31 -0400, Stephen Frost wrote: > * Laurenz Albe (laurenz.a...@cybertec.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

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-05-19 Thread Stephen Frost
Greetings, * Laurenz Albe (laurenz.a...@cybertec.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

Improve documentation for pg_upgrade, standbys and rsync

2021-05-18 Thread Laurenz Albe
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