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