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.
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: