Postgres major version upgrades

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.

Single node and High Availability clusters

Learn how to do a major version upgrade on a single node or High Availability cluster on Hybrid Manager.

AHA and DHA PG major version upgrades

Learn how to do a Postgres major version upgrade on an Advanced High Availability cluster or a Distributed High Availability cluster


Could this page be better? Report a problem or suggest an addition!