Postgres Pro
Downloads
Home   >   mailing lists

Database file compatibility between OS - Mailing list pgsql-admin

From zhigang wang
Subject Database file compatibility between OS
Date
Msg-id CAOvNZZryC-1L2hGqtaZ5pB_G8s1Sshw04w5bbG3xemjb6WUtVw@mail.gmail.com
Whole thread Raw
Responses Re: Database file compatibility between OS  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Damir Colak
Date:
Subject: Process watcher not showing on Mac pgAdmin version 2.0
Next
From: Laurenz Albe
Date:
Subject: Re: Database file compatibility between OS