Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggnLc-0004k3-46 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 09:06:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggnLa-00034r-RC for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 09:06:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggnLa-00034e-G4 for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 09:06:54 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggnLX-0004lr-87 for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 09:06:53 +0000 Received: from [192.168.127.1] (port=46971 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1ggnLT-000Ctg-Tk; Tue, 08 Jan 2019 09:06:47 +0000 Received: from [127.0.0.1] (port=57681 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1ggnLT-0008jV-2j; Tue, 08 Jan 2019 09:06:47 +0000 From: Andrew Gierth To: Natalie Wenz Cc: pgsql-admin@lists.postgresql.org Subject: Re: Database migration across different operating systems In-Reply-To: (Natalie Wenz's message of "Mon, 7 Jan 2019 22:51:03 -0600") Message-ID: <875zuzr06z.fsf@news-spur.riddles.org.uk> References: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Tue, 08 Jan 2019 09:06:46 +0000 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Natalie" =3D=3D Natalie Wenz 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=E2=80=99ve 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=3DC 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). --=20 Andrew (irc:RhodiumToad)