Re: Database file compatibility between OS

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Database file compatibility between OS
Дата
Msg-id 1513978718.4332.1.camel@cybertec.at
обсуждение исходный текст
Ответ на Database file compatibility between OS  (zhigang wang <zhigang.wang@gmail.com>)
Ответы Re: Database file compatibility between OS  (Scott Whitney <scott@journyx.com>)
Список pgsql-admin
zhigang wang wrote:
> My instance of PostgreSQL 10.1 is running on Solaris 10 x86. I am going to change the OS to Ubuntu 16.04. Here is my
planfor the database server:
 
> - Shutdown the server
> - Copy the local db folder /data/db/pgsql to a storage server.
> - Install Ubuntu and PostgreSQL 10.1
> - Copy /data/db/pgsql from storage server back to local.
> - Start the server.
> Will this work? Or I have to pg_dump then pg_restore to recreate the database instance?

No; you'll have to dump and restore to migrate to a different architecture.

Yours,
Laurenz Albe


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

Предыдущее
От: zhigang wang
Дата:
Сообщение: Database file compatibility between OS
Следующее
От: Scott Whitney
Дата:
Сообщение: Re: Database file compatibility between OS