Re: Database file compatibility between OS

Ubuntu 16.04 will be 64 bit, yes? I would be surprised if that works.
________________________________
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sent: Friday, December 22, 2017 3:38:38 PM
To: zhigang wang; pgsql-admin(at)lists(dot)postgresql(dot)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 <http://journyx.com/communication-preferences> or visit http://journyx.com/communication-preferences to unsubscribe.