Re: Migration of PGDATA

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Migration of PGDATA
Дата
Msg-id 12898.1269874065@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Migration of PGDATA  ("Martin Münstermann" <mmuenst@gmx.de>)
Список pgsql-admin
=?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= <mmuenst@gmx.de> writes:
> In case it does not work great, what kind of problems would we experience?

In theory pg_control contains enough information to detect such
compatibility problems, so that you'd get a refusal to start.
In practice, maybe not, and the consequences could be arbitrarily
unpleasant.  Better keep a pg_dump backup just in case.

One thing I'd particularly caution you to check is that the locale
settings on the new platform are equivalent to those on the old.
We have seen cases where the same locale name produces different
sort orderings on different platforms.  That will result in corrupt
(malfunctioning) indexes on text columns.

            regards, tom lane

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

Предыдущее
От: ALEXANDER JOSE
Дата:
Сообщение: Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory
Следующее
От: Ramiro Barreca
Дата:
Сообщение: Virtualization vs. sharing a server