Re: Resurrecting pg_upgrade

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: Resurrecting pg_upgrade
Дата
Msg-id 1071262744.30118.43.camel@zedora.zeut.net
обсуждение исходный текст
Ответ на Re: Resurrecting pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Resurrecting pg_upgrade  (Thomas Swan <tswan@idigx.com>)
Список pgsql-hackers
On Fri, 2003-12-12 at 15:42, Tom Lane wrote:
> Alternative thought: just recommend that if possible, people take
> a filesystem dump of their old PGDATA directory after stopping
> the old postmaster.  This would be sufficient for retreating to
> the prior version if needed.  It might or might not be slower
> than copying all the files to a new PGDATA ...

Certainly the easier path code wise :-)  Being the belt, suspenders and
steel tip boots (foot gun protection) type that I am, I would make a
backup even if pg_upgrade copies all the data files.  Having pg_upgrade
copy the data files give you an extra layer of protection if desired,
and can possibly save an admin who fails to get a good backup of the old
PGDATA for what ever reason.  



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

Предыдущее
От: Manfred Spraul
Дата:
Сообщение: Re: fsync method checking
Следующее
От: Thomas Swan
Дата:
Сообщение: Re: Resurrecting pg_upgrade