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 1ggmjs-0002pz-PF for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 08:27: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 1ggmjq-00026J-PQ for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 08:27:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggjM6-0004A0-HM for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 04:51:10 +0000 Received: from mail-it1-x12b.google.com ([2607:f8b0:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggjM4-0002zH-8N for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 04:51:10 +0000 Received: by mail-it1-x12b.google.com with SMTP id a6so4392425itl.4 for ; Mon, 07 Jan 2019 20:51:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:date:subject:message-id :to; bh=+hSjzVdft6dikXnzrup5aefXU7rQuRyxiTn/yyxLb7I=; b=ecjfjCkHRd76KozmUnrgyMF3X6ubFI3WIOY17an8swFX34iVLYyvZ5BU422Z5wlVIM oKlQD+OidC84Ir1aDjv0VmsucYTAKSLP/ZQaNEVaMmAwijZ4Tz5mbt81RYIhy4sa9fvV HhL2vQ0ylddvM7Hc+kJ9yNx21oNFQ3BFQBoba+0434m2qgP5RrmMp2A0k51ihRFLAnC2 9BVoaDZj+lI1rncf1ymRGKKAn/6GgyGpstD41i8n4l3TfadGt9Vyg2VI+aZ8MDW2VRTU ujMUIqt/dnWrCrMT4OULuz6NQpGeJlgqLmqKgEFRluhDtRwdINYq8u8PH7aQh5kTUX7k UAxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version:date :subject:message-id:to; bh=+hSjzVdft6dikXnzrup5aefXU7rQuRyxiTn/yyxLb7I=; b=ZEYZWzIVu5uxSdmQinSUkdVOd4bzWq0GkQgmwIp/H4+kO+98o/ssOWN0VlmdNHtFu4 zlMFiESd00+J/5SF9K2O3QJWEAcEREvBzuZLpT5yPT9tJSTtl7S+erRVFSx9mqB4EdlM VH3rrgLZWiEmlDIyiP+cPQe5TtH6FqMlJVBPmB1rdTkigSQvnILNNBUw9zdRWyv5+t4T J/L1u4r9UXi+EA5jqQBdV4M9MFluXKuGr6lGTfNgeE4zKsDum/2ojEjz2pr8xiGyrEzC h7FuniX+sr+j59QiWycUDooUbervkWhh2T8cmFQstmIw2Oaxdo16qidYe8CiOB7baEYk eOAg== X-Gm-Message-State: AJcUukf81fM97RupOlQwhPa3p9TReZVsmIlyJRCJoLEpsy+aoeVldo9J NT7S53lxtxPQRXWxpkpxDw7MOwvC X-Google-Smtp-Source: ALg8bN783jR2PZYBdKfBTuTjfifyKpQLhKZifmz9cuYw7tLXvpUqEKbFv2PgEnHPZOEjK1KKyka/7g== X-Received: by 2002:a24:cb07:: with SMTP id u7mr388799itg.118.1546923065594; Mon, 07 Jan 2019 20:51:05 -0800 (PST) Received: from [172.16.3.133] ([67.148.93.60]) by smtp.gmail.com with ESMTPSA id p132sm5237405itb.35.2019.01.07.20.51.04 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 07 Jan 2019 20:51:04 -0800 (PST) From: Natalie Wenz Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Date: Mon, 7 Jan 2019 22:51:03 -0600 Subject: Database migration across different operating systems Message-Id: To: pgsql-admin@lists.postgresql.org X-Mailer: iPhone Mail (16C101) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 ser= vers in another data center running Red Hat Linux 7.6 (also with ZFS), with m= inimal downtime.=20 I understand that the recommended, safest, approach would be to dump/restore= . We intend to do that wherever possible.=20 However, we have some databases that require high availability/minimal downt= ime that are also very large. (50 TB, for example) Because we use ZFS on all of our current FreeBSD database hosts, one idea th= at we are exploring is to use filesystem replication to move the data ahead o= f time, and keep it in sync. Then we could start the databases on the Linux h= osts at any time and it would be up to date. With that option, there=E2=80=99= s almost no downtime.=20 We=E2=80=99ve tested this procedure on a small database, and it starts, it r= uns, returns queries. There seems to be no issues.=20 Is this a reasonable approach? Are there any known concerns/things to invest= igate before choosing this course?=20 If it helps:=20 The cpu architecture is the same on both hosts, and we=E2=80=99ll be running= Postgres with the same version and same build options.=20 Many thanks, Natalie=20=