Re: Migration of PGDATA

Поиск
Список
Период
Сортировка
От Robert Joosten
Тема Re: Migration of PGDATA
Дата
Msg-id 20100329101857.GC1188@ismet.erje.net
обсуждение исходный текст
Ответ на Migration of PGDATA  ("Martin Münstermann" <mmuenst@gmx.de>)
Ответы Re: Migration of PGDATA  ("Martin Münstermann" <mmuenst@gmx.de>)
Список pgsql-admin
Hi,

> is it safe to move the PGDATA directory from one system to another when migrating from one operating system to
another?
> For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5?
> The database is of course shutdown properly, and the PG major versions match.
> Or is a dump/restore necessary in these cases?

Besides the other reply, take into account little- versus bigendian
changes if you switch hardware.

But just out of curiosity: why propose against a dump/restore ? I mean:
when I upgrade between major releases I dump as well, as it is
recommended. I never ran into trouble, you know.

Regards,
Robert

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Migration of PGDATA
Следующее
От: "Martin Münstermann"
Дата:
Сообщение: Re: Migration of PGDATA