Ubuntu 16.04 will be 64 bit, yes? I would be surprised if that works.
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Sent: Friday, December 22, 2017 3:38:38 PM
To: zhigang wang; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Database file compatibility between OS
Sent: Friday, December 22, 2017 3:38:38 PM
To: zhigang wang; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Database file compatibility between OS
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 plan for 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
> 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 plan for 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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click
here or visit http://journyx.com/communication-preferences to unsubscribe.
