Re: Differential backup in database migration

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Differential backup in database migration
Date: 2022-02-16 13:42:28
Message-ID: c80ce4a7-2c4f-9c08-e926-27418c6aa058@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alex Balashov schrieb am 16.02.2022 um 12:24:
> 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, so I will
> have to dump out the DB & import it into the target DB, live via a
> network pipe.

pg_upgrade will happily do the migration from 9.6 directly to 14

If the length of the downtime is a concern, the --link option will make this quite fast.

Thomas

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Daulat 2022-02-18 04:37:24 Re: Object movement
Previous Message Alex Balashov 2022-02-16 12:36:48 Re: Differential backup in database migration