Postgres Pro
Downloads
Home   >   mailing lists

Thread: Database file compatibility between OS

Database file compatibility between OS

From
zhigang wang
Date:
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?
Thanks,
Zhigang

Re: Database file compatibility between OS

From
Laurenz Albe
Date:
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

Re: Database file compatibility between OS

From
Scott Whitney
Date:
Ubuntu 16.04 will be 64 bit, yes? I would be surprised if that works.
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Friday, December 22, 2017 3:38:38 PM
To: zhigang wang; pgsql-admin@lists.postgresql.org
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



Journyx, Inc.
7600 Burnet Road #300
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.