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
