logical replication Archives - Page 2 of 3 - 2ndQuadrant

Posts

BDR History and future

October 18, 2016/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

BDR is both a patch to PostgreSQL core and an extension on top of PostgreSQL core. How did that come about, and what’s it’s future? Development of BDR was initiated around the time PostgreSQL 9.2 was in development. Arguably earlier if you count things like the extension mechanism. The goal of BDR is, and has […]

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

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

Thoughts on Uber’s List of Postgres Limitations

August 2, 2016/8 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

An Uber technical blog of July 2016 described the perception of “many Postgres limitations”. Regrettably, a number of important technical points are either not correct or not wholly correct because they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. In most cases, those limitations were actually true in the […]

Evolution of Fault Tolerance in PostgreSQL: Time Travel

July 21, 2016/0 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 third post of the series and we’ll talk about timeline issues and their effects on fault tolerance and dependability of PostgreSQL. […]

Evolution of Fault Tolerance in PostgreSQL: Replication Phase

July 11, 2016/0 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 second post of the series and we’ll talk about replication and its importance on fault tolerance and dependability of PostgreSQL. If […]

PGLogical 1.1 packages for PostgreSQL 9.6beta1

May 12, 2016/0 Comments/in 2ndQuadrant, Petr's PlanetPostgreSQL, pglogical, PostgreSQL /by Petr Jelinek

We have made pglogical 1.1 packages available for PostgreSQL 9.6beta1 for both rpm and deb based distributions. They are available for install from our standard pglogical package repository. You may ask why do we release packages for beta version of Postgres? Well, one of the reasons is that you can use pglogical to replicate your […]

PGLogical 1.1 released with sequence support and more

May 2, 2016/0 Comments/in Petr's PlanetPostgreSQL, pglogical /by Petr Jelinek

The new feature version of pglogical is now available. The new release brings support for sequence replication, manually configured parallel subscriptions, replica triggers, numerous usability improvements and bug fixes. Let’s look into the changes in more detail.

FLOSS UK Spring Conference

February 22, 2016/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL, United Kingdom News /by Gulcin Yildirim

Floss UK Spring conference will be held on 15th-17th of March in London.

On pglogical performance

January 8, 2016/1 Comment/in pglogical, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few days ago we released pglogical, a fully open-source logical replication solution for PostgreSQL, that’ll hopefully get included into the PostgreSQL tree in a not-too-distant future. I’m not going to discuss about all the things enabled by logical replication – the pglogical release announcement presents a quite good overview, and Simon also briefly explained […]