From: Paul Smith <paul@pscs.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Differential backup in database migration
Date: Wed, 16 Feb 2022 12:08:14 +0000
Message-ID: <3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk> (raw)
In-Reply-To: <F804329E-8A76-42F8-BCD0-A32FE6FA243D@evaristesys.com>
References: <F804329E-8A76-42F8-BCD0-A32FE6FA243D@evaristesys.com>
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
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: paul@pscs.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: Differential backup in database migration
In-Reply-To: <3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk>
* 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