Posts Tagged "bdr"

Re-import repository keys for BDR and pglogical apt repositories

The BDR and pglogical apt repository GnuPG signing keys have been renewed. Users should re-import the existing keys. You can verify that it’s still the same key as referenced in the documentation, just with a later expiry date. Simply run: wget –quiet -O – http://packages.2ndquadrant.com/bdr/apt/AA7A6805.asc | sudo apt-key add – sudo apt-key finger AA7A6805 |…

BDR History and future

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

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…

When are we going to contribute BDR to PostgreSQL?

My colleagues and I are often asked “when will you (2ndQuadrant) contribute BDR to PostgreSQL?” This makes an interesting assumption: that we have not already done so. We have. Much of BDR has already been contributed to core PostgreSQL, with more to come. All of BDR is under the PostgreSQL license and could be merged…

BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released

Version 0.9.2 of the BDR (Bi-Directional Replication) extension for PosgreSQL has been released. This is a maintenance release in the current stable 0.9.x series, focused on bug fixes, stability and usability improvements. In particular bdr_init_copy, the pg_basebackup-based node bring-up tool, is significantly improved in this update. This release also updates the BDR-patched version of PostgreSQL…

Dynamic SQL-level configuration for BDR 0.9.0

The BDR team has recently introduced support for dynamically adding new nodes to a BDR group from SQL into the current development builds. Now no configuration file changes are required to add nodes and there’s no need to restart the existing or newly joining nodes. This change does not appear in the current 0.8.0 stable…

BDR for PostgreSQL: Present and future

For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working on adding bi-directional asynchronous multi-master replication support for PostgreSQL. This effort has become known as the BDR project. We’re really excited to see these efforts leading to new PostgreSQL features and have a great deal more still to…

… and now for something completely different!

Up until now, reading this blog has kept you up-to-date with the latest developments in PostgreSQL. This time I would like to invite you to meet the team of 2ndQuadrant at the PostgreSQL Conference Europe 2014 which took place in Madrid on October 21st-24th. As you know, 2ndQuadrant offers 7 days a week, 24 hours…

Streaming replication slots in PostgreSQL 9.4

Streaming replication slots are a pending feature in PostgreSQL 9.4, as part of the logical changeset extraction feature. What are they for, what do you need to know, what changes? What are replication slots? Streaming replication slots are a new facility introduced in PostgreSQL 9.4. They are a persistent record of the state of a…