pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase file compatibility between OS
3+ messages / 3 participants
[nested] [flat]
* Database file compatibility between OS
@ 2017-12-22 21:35 zhigang wang <zhigang.wang@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: zhigang wang @ 2017-12-22 21:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database file compatibility between OS
@ 2017-12-22 21:38 Laurenz Albe <laurenz.albe@cybertec.at>
parent: zhigang wang <zhigang.wang@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2017-12-22 21:38 UTC (permalink / raw)
To: zhigang wang <zhigang.wang@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database file compatibility between OS
@ 2017-12-22 21:40 Scott Whitney <scott@journyx.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 3+ messages in thread
From: Scott Whitney @ 2017-12-22 21:40 UTC (permalink / raw)
To: zhigang wang <zhigang.wang@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; Laurenz Albe <laurenz.albe@cybertec.at>
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.
Yours,
Laurenz Albe
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here <http://journyx.com/communication-preferences; or visit http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2017-12-22 21:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-12-22 21:35 Database file compatibility between OS zhigang wang <zhigang.wang@gmail.com>
2017-12-22 21:38 ` Laurenz Albe <laurenz.albe@cybertec.at>
2017-12-22 21:40 ` Scott Whitney <scott@journyx.com>
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