From: Laurenz Albe <laurenz.albe@cybertec.at>
To: zhigang wang <zhigang.wang@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Database file compatibility between OS
Date: Fri, 22 Dec 2017 22:38:38 +0100
Message-ID: <1513978718.4332.1.camel@cybertec.at> (raw)
In-Reply-To: <CAOvNZZryC-1L2hGqtaZ5pB_G8s1Sshw04w5bbG3xemjb6WUtVw@mail.gmail.com>
References: <CAOvNZZryC-1L2hGqtaZ5pB_G8s1Sshw04w5bbG3xemjb6WUtVw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, zhigang.wang@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Database file compatibility between OS
In-Reply-To: <1513978718.4332.1.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox