| From: | Paul Smith <paul(at)pscs(dot)co(dot)uk> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Differential backup in database migration |
| Date: | 2022-02-16 12:08:14 |
| Message-ID: | 3608d5cd-5d62-473f-0c09-20973b0e9a52@pscs.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Balashov | 2022-02-16 12:36:48 | Re: Differential backup in database migration |
| Previous Message | Alex Balashov | 2022-02-16 11:36:05 | Re: Differential backup in database migration |