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.