Re: pg_upgrade and rsync - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: pg_upgrade and rsync
Date
Msg-id 20150129050730.GO3854@tamriel.snowman.net
Whole thread Raw
In response to Re: pg_upgrade and rsync  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
* Josh Berkus (josh@agliodbs.com) wrote:
> On 01/28/2015 02:28 PM, Josh Berkus wrote:
> > On 01/28/2015 02:10 PM, Josh Berkus wrote:
> >> So 390MB were transferred out of a possible 474MB.  That certainly seems
> >> like we're still transferring the majority of the data, even though I
> >> verified that the hard links are being sent as hard links.  No?
> >
> > Looks like the majority of that was pg_xlog.  Going to tear this down
> > and start over, and --exclude pg_xlog.
> >
>
> So, having redone this without the pg_xlog lag, this appears to work in
> terms of cutting down the rsync volume.
>
> I'm concerned about putting this in the main docs, though.  This is a
> complex, and fragile procedure, which is very easy to get wrong, and
> hard to explain for a generic case.

So, for my 2c, I'm on the fence about it.  On the one hand, I agree,
it's a bit of a complex process to get right.  On the other hand, it's
far better if we put something out there along the lines of "if you
really want to, this is how to do it" than having folks try to fumble
through to find the correct steps themselves.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: pg_upgrade and rsync
Next
From: Matt Kelly
Date:
Subject: Exposing the stats snapshot timestamp to SQL