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
