Re: pg_upgrade and rsync

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_upgrade and rsync
Дата
Msg-id 11643.1422370259@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_upgrade and rsync  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: pg_upgrade and rsync  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Jan 23, 2015 at 1:48 PM, Andres Freund <andres@2ndquadrant.com> wrote:
>> I don't understand why that'd be better than simply fixing (yes, that's
>> imo the correct term) pg_upgrade to retain relfilenodes across the
>> upgrade. Afaics there's no conflict risk and it'd make the clusters much
>> more similar, which would be good; independent of rsyncing standbys.

> +1.

That's certainly impossible for the system catalogs, which means you
have to be able to deal with relfilenode discrepancies for them, which
means that maintaining the same relfilenodes for user tables is of
dubious value.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: pg_upgrade and rsync
Следующее
От: David Fetter
Дата:
Сообщение: Re: Parallel Seq Scan