Upgrade PostgreSQL

Why Upgrade?

To run a system optimally, it is important to be sure you are running the most up-to-date version of PostgreSQL.

Each major version of PostgreSQL released by the community is supported for 5 years, after which it reaches EOL and becomes unsupported. In order to continue seeking community support, it is critical for your system to be running on a supported version.

Upgrading a PostgreSQL database to the latest release will allow you access to new features and community support, increase robustness and improve performance. Upgrades can be a tricky business, so careful planning and testing is required to ensure a smooth, low-downtime upgrade between PostgreSQL major versions

Why Choose 2ndQuadrant?

It’s simple: AlmostZero Down Time.

2ndQuadrant engineers developed the code for logical replication, which forms the basis of the popular PostgreSQL extension, pglogical. Using this service, large or high volume databases can be upgraded without using:

pg_upgrade – which needs the entire system to be taken down, potentially for hours

Trigger-based replication – which puts an unacceptable load on the production system

Our experts can use first hand knowledge of the code-base to help upgrade your current PostgreSQL database with almost zero down time using logical replication.

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services

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.