Postgres major version upgrades

Suggest edits

Major version upgrades allow you to access new features, enhancements, and performance improvements introduced in the latest version of PostgreSQL. However, they may include changes that are not backward-compatible, requiring careful planning and validation.

Major version upgrades typically occur annually and can bring significant advancements, such as new SQL functionality, enhanced performance, or improved compatibility with modern standards.

To ensure a smooth upgrade process, it's essential to test your applications and extensions against the new version and review the release notes for deprecated or modified features.

With Hybrid Manager (HM), users can manage major version upgrades at their discretion. Once a new major version has been validated and published, it soon becomes available in HM's image library, enabling controlled upgrades for existing clusters.

Note

PG major version upgrades require a data restart. Downtime is expected.

While major upgrades offer significant benefits, they require careful preparation.

It is strongly recommended to perform a full backup of your cluster and validate a comprehensive recovery plan before proceeding. This ensures you can restore your data if any compatibility or operational issues arise during the upgrade process.

Major version upgrades by database cluster type

You can easily upgrade Postgres major versions with HM for both single node and High Availability (HA) clusters, as well as Advanced High Availability (AHA) clusters and Distributed High Availability (DHA) clusters.