replication Archives - Page 2 of 4 - 2ndQuadrant

Posts

Logical Replication in PostgreSQL 10

April 28, 2017/35 Comments/in Petr's PlanetPostgreSQL /by Petr Jelinek

PostgreSQL 10 is getting close to its first beta release and it will include the initial support for logical replication, which is was written primarily by me and committed by my colleague Peter Eisentraut, and is internally based on the work 2ndQuadrant did on pglogical (even though the user interface is somewhat different). I’d like […]

When autovacuum does not vacuum

April 19, 2017/8 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few weeks ago I explained basics of autovacuum tuning. At the end of that post I promised to look into problems with vacuuming soon. Well, it took a bit longer than I planned, but here we go. To quickly recap, autovacuum is a background process cleaning up dead rows, e.g. old deleted row versions. […]

repmgr 3.3

January 26, 2017/0 Comments/in Ian's PlanetPostgreSQL /by Ian Barwick

repmgr 3.3 introduces a number of additional options for setting up and managing replication clusters, with particular emphasis on cascading replication support. These changes will also make it easier to set up complex clusters using provisioning scripts. Additionally there are changes to the repmgr command line utility’s logging behaviour which you should take into consideration […]

pglogical 1.2 with PostgreSQL 9.6 support

October 20, 2016/0 Comments/in Petr's PlanetPostgreSQL /by Petr Jelinek

PostgreSQL 9.6 is now out and so is an updated version of pglogical that works with it. For quick guide on how to upgrade the database with pglogical you can check my post which announced 9.6beta support. The main change besides the support for 9.6.x release of PostgreSQL is in the way we handle the […]

Back to the Future Part 3: pg_rewind with PostgreSQL 9.6

October 17, 2016/0 Comments/in 2ndQuadrant, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

This is the third and last part of blog articles dedicated to pg_rewind. In the two previous articles we have seen how pg_rewind is useful to fix split-brain events due to mistakes in the switchover procedures, avoiding the need of new base backups. We have also seen that this is true for simple replication clusters, where more standby nodes are involved.

repmgr 3.2 is here with Barman support and Brand New High Availability features

October 10, 2016/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian Barwick

repmgr 3.2 has recently been released with a number of enhancements, particularly support for 2ndQuadrant’s Barman archive management server, additional cluster monitoring functionality and improvements to the standby cloning process. One aim of this release is to remove the requirement to set up passwordless SSH between servers, which means when using repmgr’s standard functionality to […]

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

September 28, 2016/1 Comment/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

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

BDR is coming to PostgreSQL 9.6

September 21, 2016/39 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

I’m pleased to say that Postgres-BDR is on its way to PostgreSQL 9.6, and even better, it works without a patched PostgreSQL. BDR has always been an extension, but on 9.4 it required a heavily patched PostgreSQL, one that isn’t fully on-disk-format compatible with stock community PostgreSQL 9.4. The goal all along has been to […]

Back to the Future Pt. 1: Introduction to pg_rewind

September 12, 2016/14 Comments/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

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

August 17, 2016/2 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

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

Read 2ndQuadrant’s response to the COVID – 19 emergency here