From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Natalie Wenz <nataliewenz@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Database migration across different operating systems
Date: Tue, 08 Jan 2019 09:06:46 +0000
Message-ID: <875zuzr06z.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <A740E5D2-34BE-46AA-A9FE-50F510E771EC@gmail.com>
References: <A740E5D2-34BE-46AA-A9FE-50F510E771EC@gmail.com>
>>>>> "Natalie" == Natalie Wenz <nataliewenz@gmail.com> writes:
Natalie> We are in an unusual circumstance, where we need to move all
Natalie> of our Postgres 10 databases from their homes on servers
Natalie> running FreeBSD 11 with ZFS to servers in another data center
Natalie> running Red Hat Linux 7.6 (also with ZFS), with minimal
Natalie> downtime.
[...]
Natalie> We’ve tested this procedure on a small database, and it
Natalie> starts, it runs, returns queries. There seems to be no issues.
Natalie> Is this a reasonable approach? Are there any known
Natalie> concerns/things to investigate before choosing this course?
Locales will bite you unless your databases all have lc_collate=C or
you're using ICU for all collations); you will need, at minimum, to
reindex every index containing a collatable column with an OS-provided
collation (i.e. not ICU and not C / POSIX).
--
Andrew (irc:RhodiumToad)
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: andrew@tao11.riddles.org.uk, nataliewenz@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Database migration across different operating systems
In-Reply-To: <875zuzr06z.fsf@news-spur.riddles.org.uk>
* 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