To ensure your mission critical database runs optimally, it is important to ensure you are running the most up-to-date version of PostgreSQL. The Postgres experts at 2ndQuadrant can help you upgrade your mission critical database systems with almost zero downtime.
Some of the top reasons you should upgrade your PostgreSQL database are:
- Access to new features
- Community support
- Increase robustness
- Improve performance
- Keep up to date with patches
- Upgrade PostgreSQL Zero Downtime
In order to receive continuous community support, your system must be running on a supported version. Each major version of PostgreSQL is supported by the community for 5 years, until it reaches End of Life (EOL).
Upgrade PostgreSQL with Zero Downtime
Performing a PostgreSQL Upgrade for a large or high-volume database using logical replication can minimize downtime to almost zero. The PostgreSQL engineers at 2ndQuadrant developed the code for logical replication, which forms the basis of the popular PostgreSQL extension, pglogical.
pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.With first-hand knowledge of the code-base, 2ndQuadrant is able to help upgrade your current PostgreSQL database with almost zero downtime.
Database Upgrade Knowledge Base
Leading Polar & Marine Research Institution Upgrades to Highly Efficient Database Infrastructure
Internationally recognized institute known for expertise in polar and marine research, AWI, invested in various PostgreSQL versions and operating systems for their applications. 2ndQuadrant helped AWI set up a homogenous PostgreSQL and OS versions environment with a standardized backup plan to better operate in a variety of polar and marine research stations, which are constantly collecting an enormous amount of data.
Keep your libraries updated and nobody gets hurt/0 Comments/in Jimmy's Planet PostgreSQL /by Jimmy Angelakos
Don’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 Kincaid
In the past year, I have had conversations with many clients and prospects about Postgres-BDR. Postgres-BDR has been in production for many mission critical deployments for quite some time. We have more clients coming on board each month. Recently, I have been meeting with companies whose business is in either Telecommunications. In such industries, […]
PostgreSQL 9.3 EOL – Why is it Important to Upgrade?/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat Andrabi
After 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 […]