+39 0574 159 3000Upgrade PostgreSQL
Why Upgrade?
To run a system optimally, it is important to ensure you are running the most up-to-date version of PostgreSQL. Below are some of the top reasons why you should upgrade your PostgreSQL database:
- Access to new features
- Community support
- Increase robustness
- Improve performance
- Keep up to date with patches
In order to receive continuous community support, it is critical for your system to be running on a supported version. Each major version of PostgreSQL is supported by the community for 5 years, until it reaches EOL.
Upgrades can be a tricky business, so careful planning and testing is required to ensure a smooth, low-downtime upgrade between PostgreSQL major versions.
How can you Upgrade PostgreSQL with Zero Downtime?
When upgrading your PostgreSQL databases, there are a number of options available.
Using PostgreSQL built-in tools, such as pg_upgrade, can involve significant downtime.
Performing a PostgreSQL Upgrade for large or high volume databases using tools such as logical replication can minimize downtime to almost zero. 2ndQuadrant engineers developed the code for logical replication, which forms the basis of the popular PostgreSQL extension, pglogical.
Our experts use first-hand knowledge of the code-base to help upgrade your current PostgreSQL database with almost zero downtime.
Our Customers’ Experiences
The Alfred Wegener Institute (AWI) is an internationally recognized institute known for expertise in polar and marine research. AWI operates on a variety of research stations which constantly collect an enormous amount of data.
As the demand presented itself, AWI invested in various PostgreSQL versions and operating systems for their applications. This decision inevitably led to a complex database infrastructure where a mixture of different PostgreSQL and OS versions were rarely working in sync.
Read more about how 2ndQuadrant helped AWI set up an homogenous PostgreSQL and OS versions environment with a standardized backup plan.
Keep your libraries updated and nobody gets hurt
/0 Comments/in Jimmy's Planet PostgreSQL /by Jimmy AngelakosDon’t make people practice software archaeology – keep your system updated. Updates? One of the benefits of the open-source world is the unmatched ability to issue updates rapidly to correct bugs and security vulnerabilities. Software bug fixes keep streaming in: from recently introduced regressions, to long-standing bugs undetected for years, they are corrected by a […]
Postgres-BDR: It is also about fast safe upgrades
/2 Comments/in 2ndQuadrant, Tom's PlanetPostgreSQL /by Tom KincaidIn the past year, I have had many conversations with many clients and prospects about Postgres-BDR. For those of you who don’t know this Postgres-BDR has been in production for many mission critical deployments for quite some time. We have more clients coming on board each month. Most recently, I have been meeting with […]
PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat AndrabiAfter the final release of patch 9.3.25 on November 8th 2018, PostgreSQL 9.3 is no longer supported. Therefore it’s time for all users of PG 9.3 to upgrade their databases to a newer supported version. The benefits of having a supported version are many and that’s what Craig Ringer talks about in the Q&A session […]