Moving data directory from one server to another

Поиск
Список
Период
Сортировка
От Ehsan Haq
Тема Moving data directory from one server to another
Дата
Msg-id 741639.12107.qm@web31802.mail.mud.yahoo.com
обсуждение исходный текст
Список pgsql-general
Hi,
   I have two Linux servers both having same Hardware architecture one have ES5 and the other having ES4. Both the servers have same version of PostGres installed (8.3). I want to move all my DBs from ES5 server to ES4 server. I have tried the pg_dump but there are a lot of encoding problems, so can I copy the whole data directory from ES5 server to ES4 server when the PostGres server is not running? Will it be safe?

Thanks
Ehsan

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error 42501 permission denied for schema
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Warm Standby Setup Documentation