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

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)

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 […]

Prague PostgreSQL Meetup

Last month, I was at 2ndQuadrant booth at P2D2, an annual conference organized in Prague by local user group called CSPUG (Czech and Slovak PostgreSQL User Group). The conference was certainly a huge success and more than 200 people showed up! Meeting a lot of PostgreSQL enthusiasts in town, I wondered why there are no regular meetups […]

CHAR (16) – Another conference on the horizon but with a focus on business

The PostgreSQL user community is becoming spoilt with a choice of excellent events organized by both local user groups and commercial organizations supporting the PostgreSQL project.  And amongst the events taking place in December, the one you definitely shouldn’t miss attending is CHAR(16). ‘CHAR(16): Scalability for Business’ is intended to fulfill a different requirement – different […]

More ‘POWER’ for PostgreSQL

Now Available! Debian and Ubuntu packages for Power Architecture. The official announcement was published last Friday, September 30, 2016: the PostgreSQL repository for Debian and Ubuntu packages, apt.postgresql.org, has been extended by adding binary packages of IBM’s Little Endian POWER8 architecture.

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source database, PostgreSQL strives to release a major version roughly once every year. With an active and collaborative community, this PostgreSQL release boasts impressive features and updates thanks […]

Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

In the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual switchover involves just two nodes that have to be aligned. But what happens with HA clusters when there are several (also cascading) standbys? Now, consider […]

The Best Barman Ever

This is my (very) biased opinion, but I am ready to bet that once you try Barman 2.0 you’ll agree with me.

Back to the Future Pt. 1: Introduction to pg_rewind

Since PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider, for instance, the case of a switchover that didn’t work properly. Have you ever experienced a “split brain” during a switchover operation? You know, when the goal […]

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. This is the fourth post of the series and we’ll talk about synchronous commit and its effects on fault tolerance and dependability of PostgreSQL. […]