From: Alex Balashov <abalashov@evaristesys.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Differential backup in database migration
Date: Wed, 16 Feb 2022 07:36:48 -0500
Message-ID: <A98302EE-531C-4E12-998F-E81AC3ABC847@evaristesys.com> (raw)
In-Reply-To: <3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk>
References: <F804329E-8A76-42F8-BCD0-A32FE6FA243D@evaristesys.com>
<3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk>
Huh! I suppose I don’t know; I just assumed it would take a bunch of fragile, error-prone upgrade jumps across major releases to get five major releases forward.
I’ll definitely follow up on your suggestion, as it is by far the simplest!
> On Feb 16, 2022, at 7:08 AM, Paul Smith <paul@pscs.co.uk> wrote:
>
> On 16/02/2022 11:24, Alex Balashov wrote:
>> I’m 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,
>
> How do you know it will not be binary compatible?
>
> 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.
>
> I'd take a backup, put it on a test machine with 9.5 and try to upgrade it. You may be pleasantly surprised
>
>
> Paul
>
>
> --
>
>
> Paul Smith Computer Services
> Tel: 01484 855800
> Vat No: GB 685 6987 53
>
> Sign up for news & updates at http://www.pscs.co.uk/go/subscribe
>
>
--
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/
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: abalashov@evaristesys.com, pgsql-admin@lists.postgresql.org
Subject: Re: Differential backup in database migration
In-Reply-To: <A98302EE-531C-4E12-998F-E81AC3ABC847@evaristesys.com>
* 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