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 1hNOBf-0001oD-FV for pgsql-admin@arkaria.postgresql.org; Sun, 05 May 2019 20:56:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hNOBe-0000i7-22 for pgsql-admin@arkaria.postgresql.org; Sun, 05 May 2019 20:56:42 +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 1hNOBd-0000i0-P4 for pgsql-admin@lists.postgresql.org; Sun, 05 May 2019 20:56:41 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hNOBW-0004Kt-PG for pgsql-admin@lists.postgresql.org; Sun, 05 May 2019 20:56:41 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 02CBCBF924; Sun, 5 May 2019 20:56:32 +0000 (UTC) Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo04-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id b0wiwQjwALus; Sun, 5 May 2019 20:56:31 +0000 (UTC) Received: from [192.168.2.16] (unknown [8.39.228.117]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 1D217BF98C; Sun, 5 May 2019 20:56:28 +0000 (UTC) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.8\)) Subject: Re: old cluster does not use data checksums but the new one does From: Scott Ribe In-Reply-To: Date: Sun, 5 May 2019 14:56:27 -0600 Cc: Bruce Momjian , pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <20190505120454.2zgsqcudz4eqquvy@momjian.us> To: Mariel Cherkassky X-Mailer: Apple Mail (2.3445.104.8) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > On May 5, 2019, at 2:42 PM, Mariel Cherkassky = wrote: >=20 > in aspect of upgrade, what will be faster, pg_upgrade or dump and = restore each db in the cluster ? >=20 > =E2=80=AB=D7=91=D7=AA=D7=90=D7=A8=D7=99=D7=9A =D7=99=D7=95=D7=9D =D7=90=D7= =B3, 5 =D7=91=D7=9E=D7=90=D7=99 2019 =D7=91-19:11 =D7=9E=D7=90=D7=AA = =E2=80=AAScott Ribe=E2=80=AC=E2=80=8F = <=E2=80=AAscott_ribe@elevated-dev.com=E2=80=AC=E2=80=8F>:=E2=80=AC > > On May 5, 2019, at 9:58 AM, Mariel Cherkassky = wrote: > >=20 > > My only option is doing the upgrade with other tools and not with = pg_upgrade ? >=20 > Dump & restore; you're changing the on-disk file format, so attempts = to use current disk files cannot work. In my opinion, depends on your confidence in your disks & file system = etc. For instance, given enterprisey hardware (channel per disk, no = half-backed SATA multipliers, decent disks) + ZFS with appropriate = redundancy, I wouldn't see the need. On the other hand, a desktop PC = with some multi-disk USB box, and hell yeah I want checksums. Systems in = between, harder judgment call...=