From: Natalie Wenz <nataliewenz@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Database migration across different operating systems
Date: Mon, 7 Jan 2019 22:51:03 -0600
Message-ID: <A740E5D2-34BE-46AA-A9FE-50F510E771EC@gmail.com> (raw)
We are in an unusual circumstance, where we need to move all of our Postgres 10 databases from their homes on servers running FreeBSD 11 with ZFS to servers in another data center running Red Hat Linux 7.6 (also with ZFS), with minimal downtime.
I understand that the recommended, safest, approach would be to dump/restore. We intend to do that wherever possible.
However, we have some databases that require high availability/minimal downtime that are also very large. (50 TB, for example)
Because we use ZFS on all of our current FreeBSD database hosts, one idea that we are exploring is to use filesystem replication to move the data ahead of time, and keep it in sync. Then we could start the databases on the Linux hosts at any time and it would be up to date. With that option, there’s almost no downtime.
We’ve tested this procedure on a small database, and it starts, it runs, returns queries. There seems to be no issues.
Is this a reasonable approach? Are there any known concerns/things to investigate before choosing this course?
If it helps:
The cpu architecture is the same on both hosts, and we’ll be running Postgres with the same version and same build options.
Many thanks,
Natalie
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: nataliewenz@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Database migration across different operating systems
In-Reply-To: <A740E5D2-34BE-46AA-A9FE-50F510E771EC@gmail.com>
* 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