database upgrade Archives - 2ndQuadrant

Posts

Keep your libraries updated and nobody gets hurt

May 14, 2020/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

October 15, 2019/2 Comments/in 2ndQuadrant, Tom's PlanetPostgreSQL /by Tom Kincaid

In 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?

January 3, 2019/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 […]

Upgrading to PostgreSQL 11 with Logical Replication

September 6, 2018/7 Comments/in 2ndQuadrant, Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

It’s time. About a year ago, we published PostgreSQL 10 with support for native logical replication. One of the uses of logical replication is to allow low- or no-downtime upgrading between PostgreSQL major versions. Until now, PostgreSQL 10 was the only PostgreSQL release with native logical replication, so there weren’t many opportunities for upgrading in […]

Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)

April 30, 2018/0 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin Yildirim

I’ve started to write about the tool (pglupgrade) that I developed to perform near-zero downtime automated upgrades of PostgreSQL clusters. In this post, I’ll be talking about the tool and discuss its design details. You can check the first part of the series here: Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I). The tool is […]

Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)

March 23, 2018/5 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin Yildirim

Last week, I was at Nordic PGDay 2018 and I had quite a few conversations about the tool that I wrote, namely pglupgrade, to automate PostgreSQL major version upgrades in a replication cluster setup. I was quite happy that it has been heard and some other people in different communities giving talks at meetups and other […]

Untangling the PostgreSQL upgrade

September 30, 2016/8 Comments/in pglogical, PostgreSQL /by Martín Marqués

PostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server. Upgrading to a new major version is a task which has a high ratio of preparation over […]

Posts

Keep your libraries updated and nobody gets hurt

Postgres-BDR: It is also about fast safe upgrades

PostgreSQL 9.3 EOL – Why is it Important to Upgrade?

Upgrading to PostgreSQL 11 with Logical Replication

Untangling the PostgreSQL upgrade

Support & Services

Products

Postgres Learning Center

About Us