Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKJYM-0008FW-II for pgsql-admin@arkaria.postgresql.org; Wed, 16 Feb 2022 12:37:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKJYL-0000SO-Ev for pgsql-admin@arkaria.postgresql.org; Wed, 16 Feb 2022 12:37:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKJYL-0000SE-2h for pgsql-admin@lists.postgresql.org; Wed, 16 Feb 2022 12:37:01 +0000 Received: from evariste01.clarocloud.co.za ([196.13.181.165] helo=evaristesys.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKJYH-0006uA-Ld for pgsql-admin@lists.postgresql.org; Wed, 16 Feb 2022 12:36:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=evaristesys.com; s=defaultdkim; h=Sender:Message-Id:In-Reply-To:To: References:Date:Subject:Mime-Version:Content-Transfer-Encoding:Content-Type: From:Reply-To:Cc:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=LdLWuWHoT8Q4RFukx4E0t0CNeD9rIMDSkMn5LwkRDNM=; b=OT+vP0oy9pWku/fQmfauWcZzcl rlXjq8FOSdxptHWMhpOAGp8fP4bVrMaASlg/OEVbMgt7Mfv3Z8g9QScVQZ2gYgCSsBKB2tzSJrH+F HTSjr3sd86gJhaG5BfQ03YVDpxx6FQeQfZK4cceb/ZUE8kHfXLqXSj+8JOeWiQ27s3os=; Received: from 047-032-094-182.res.spectrum.com ([47.32.94.182] helo=smtpclient.apple) by evaristesys.com with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKJYC-00026g-KN for pgsql-admin@lists.postgresql.org; Wed, 16 Feb 2022 14:36:52 +0200 From: Alex Balashov Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\)) Subject: Re: Differential backup in database migration Date: Wed, 16 Feb 2022 07:36:48 -0500 References: <3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk> To: pgsql-admin@lists.postgresql.org In-Reply-To: <3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk> Message-Id: X-Mailer: Apple Mail (2.3693.40.0.1.81) Sender: sasha@evaristesys.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Huh! I suppose I don=E2=80=99t know; I just assumed it would take a = bunch of fragile, error-prone upgrade jumps across major releases to get = five major releases forward.=20 I=E2=80=99ll definitely follow up on your suggestion, as it is by far = the simplest! > On Feb 16, 2022, at 7:08 AM, Paul Smith wrote: >=20 > On 16/02/2022 11:24, Alex Balashov wrote: >> I=E2=80=99m faced with the daunting prospect of upgrading a PG 9.6 = installation to 14, in the process migrating a ~400 GB database. Due to = the large jump in major versions, the on-disk block storage of course = will not be in the slightest bit binary-compatible, >=20 > How do you know it will not be binary compatible? >=20 > I'm fairly sure I've upgraded 9.5 to 14 using pg_upgrade... If you use = the 'link' option in pg_upgrade it just takes a few minutes with = databases that big. >=20 > I'd take a backup, put it on a test machine with 9.5 and try to = upgrade it. You may be pleasantly surprised >=20 >=20 > Paul >=20 >=20 > --=20 >=20 >=20 > Paul Smith Computer Services > Tel: 01484 855800 > Vat No: GB 685 6987 53 >=20 > Sign up for news & updates at http://www.pscs.co.uk/go/subscribe >=20 >=20 --=20 Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/