PostgreSQL in place major version upgrades allow you to upgrade your PostgreSQL instances to a major version. The best part is that they typically take 60 seconds or less.

This means that you will be able to upgrade to the next major version without the manual work, such as forking and redirecting your traffic. Let's look at the steps involved:

1. Select the instance you want to upgrade

This will take you to the instance overview tab.

2. Click the Upgrade PostgreSQL button in the PostgreSQL version section 

3. Select the version you want to upgrade to

When you select the version you want to upgrade to, the system will check for version upgrade compatibility.

4. Click upgrade

Once the system confirms compatibility, all you have to do is click upgrade and the system will handle the rest.

A technical overview of the process is summarised below:

  1. Standby nodes are removed and then replacements are created for the new version.
  2. The primary node (sometimes known as: master) starts an in-place upgrade to the new major version.
  3. Once successful, the replacement standby nodes will point to the new primary node to replicate from.

Details on other upgrade processes (cloud migrations, plan upgrades and downgrades etc) can be found in this help article.

Do note though that once the upgrade has started, there is no going back and this will render your pre-existing PostgreSQL backups unusable for things like Point In Time Recovery since they were made for an earlier PostgreSQL major version.

To learn more about PostgreSQL in place major version upgrades, read our blog post detailing why we built it into our platform.

Got here by accident? Learn how Aiven simplifies Postgres:

Did this answer your question?