Re: pg_upgrade and rsync

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: pg_upgrade and rsync
Дата
Msg-id
11643.1422370259@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Andres Freund <andres@2ndquadrant.com>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Andres Freund <andres@2ndquadrant.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Andres Freund <andres@2ndquadrant.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Andres Freund <andres@2ndquadrant.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Andres Freund <andres@2ndquadrant.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Robert Haas <robertmhaas@gmail.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Robert Haas <robertmhaas@gmail.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync Robert Haas <robertmhaas@gmail.com>
Re: pg_upgrade and rsync Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_upgrade and rsync Robert Haas <robertmhaas@gmail.com>
Re: pg_upgrade and rsync Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Andres Freund <andres@2ndquadrant.com>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Stephen Frost <sfrost@snowman.net>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync David Steele <david@pgmasters.net>
Re: pg_upgrade and rsync Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: pg_upgrade and rsync Heikki Linnakangas <hlinnakangas@vmware.com>
Re: pg_upgrade and rsync Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: pg_upgrade and rsync Heikki Linnakangas <hlinnakangas@vmware.com>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade and rsync Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: pg_upgrade and rsync Bruce Momjian <bruce@momjian.us>
Robert Haas  writes:
> On Fri, Jan 23, 2015 at 1:48 PM, Andres Freund  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
FAQ