Database file compatibility between OS
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject
: Database file compatibility between OS
From
: zhigang wang <zhigang.wang@xxxxxxxxx>
Date
: Fri, 22 Dec 2017 16:35:14 -0500
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
Follow-Ups
:
Re: Database file compatibility between OS
From:
Laurenz Albe
Prev by Date:
Process watcher not showing on Mac pgAdmin version 2.0
Next by Date:
Re: Database file compatibility between OS
Previous by thread:
Process watcher not showing on Mac pgAdmin version 2.0
Next by thread:
Re: Database file compatibility between OS
Index(es):
Date
Thread
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]