Re: pg_upgrade and rsync

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: pg_upgrade and rsync
Дата
Msg-id 20150129050730.GO3854@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: pg_upgrade and rsync  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: pg_upgrade and rsync
Следующее
От: Matt Kelly
Дата:
Сообщение: Exposing the stats snapshot timestamp to SQL