Postgres-BDR 3.0 with OmniDB

Introduction OmniDB 2.8 introduced support for Postgres-BDR 3.0, the ground-breaking multi-master replication tool for PostgreSQL databases, announced last month in PostgresConf US. Here we have 2 virtual machines with Postgres-BDR...
June 26, 2018

Keeping our perl code clean

Recently I have been refining and adding utilities to look after our Perl code. You might be surprised to learn that as well as 1.3 million or so lines of...
June 21, 2018

Road test your patch in one command

If you have Docker installed on your development machine, there is a simple way to road test your code using the buildfarm client, in a nicely contained environment. These preparatory...
June 14, 2018

Find the Right Version of BART and Pgpool II

We encounter some confusion around which versions of EDB Postgres Backup and Recovery Tool (BART) are supported with which version of our database server, EDB Postgres Advanced Server (EPAS). This...
May 29, 2018

Introduction to Postgres-BDR [Webinar Follow-up]

The announcement of Postgres-BDR 3.0 last month at PostgresConf US had been long-awaited in the PostgreSQL community. Complex use cases from customers have driven the development of BDR far beyond...
May 28, 2018

PostgreSQL Buildfarm Client Release 8

I have just release version 8 of the PostgreSQL Buildfarm client It can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-8.tgz or http://github.com/PGBuildFarm/client-code/archive/REL_8.tar.gz This release contains a number of small changes to make using...
May 21, 2018

PG Phriday: BDR Around the Globe

With the addition of logical replication in Postgres 10, it’s natural to ask “what’s next”? Though not directly supported yet, would it be possible to subscribe two Postgres 10 nodes...
May 04, 2018