Why Postgres major upgrades are important
You should always upgrade if you want to take full advantage of PostgreSQL. New major versions provide performance benefits as well as new features.
But a lot of PostgreSQL users are wary of major version updates because they present a challenge; namely, they require some downtime. How much downtime depends on how you upgrade.
Aiven has that downtime down to seconds.
Aiven makes major PG upgrades easy
Aiven's in-place upgrades for PostgreSQL take out multiple steps from the upgrade process and reduces downtime exponentially. Upgrading smaller instances will take seconds; larger instances often no more than one minute.
Here's what happens during an in-place upgrade:
- An automatic process checks that the upgrade is possible.
- Possible standby nodes are shut down.
- The primary node is upgraded.
- A full backup is created.
- New standby nodes are created.
- A possible read-only replica service is upgraded by the same process.
But that's all done by Aiven - all you have to do is to click a button in the Aiven Console to get it started.
Feel free to check out the PostgreSQL in-place major upgrades documentation for more details.
Aiven for PostgreSQL®
Fully managed and hosted PostgreSQL with high performance and all the extensions you want out of the box.Try our open source service!
Jun 9, 2022
What is PostgreSQL®?
Join us for a browse about the ins and outs of PostgreSQL® on this page of information and resources.
Feb 17, 2021
Discover exoplanets with PostgreSQL® sample data
In this post, Lorna Mitchell populates an empty PostgreSQL database for testing with cool data about exoplanets. Read to learn how!
Aug 31, 2021
Solving the knapsack problem in PostgreSQL®
The knapsack problem: how to fit all the items you're most likely to need on holiday? Find out how to use the world's best OS database to help you pack.
Subscribe to the Aiven newsletter
All things open source, plus our product updates and news in a monthly newsletter.