CODEWITHSUNDEEP
postgresql
Fabrice Chapuis
Fabrice Chapuis

Reputation: 498

Upgrade to postgres version 14

Can we upgrade directly from postgres version 10 to postgres version 14 with pg_upgrade. Is there any tool to determine if data storage format has changed with the new version.

Upvotes: 0

Views: 1618

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246043

There is no such tool, but the storage format hasn't changed, and you can use pg_upgrade.

The old and the new cluster must have the same encoding and locale, and the bootstrap superuser's name must be the same. Block size, WAL segment size and similar settings must be the same, and both must have data checksums on or off.

Upvotes: 1

Related Questions