17th September 2020: PostgreSQL 13 RC 1 Released!

Postgres-BDR 9.4 1.0 Released

Posted on 2016-08-11 by 2ndQuadrant Ltd

Oxford, United Kingdom - August 11, 2016

Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by a keen user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2-48 nodes in a distributed database.


Significant improvements related to stability and bug fixes have been made in this release. The most important factors of this release are:

  • Smoother handling of schema changes (DDL) statements allowing increased operational stability and reduced maintenance.
  • Various bug fixes for operational issues demonstrating high level of maturity
  • Performance tuning, especially of global sequence handling
  • Removal of the now deprecated UDR
  • Extensive documentation improvements based upon user feedback

For a more comprehensive list of release notes, please click here: http://bdr-project.org/docs/stable/release-1.0.0.html


Postgres-BDR 9.4 1.0 will be supported until December 2019, when PostgreSQL 9.4 goes EOL. BDR continues to be developed and BDR9.6 will be released within 6 months. The BDR project has already delivered the majority of its code into PostgreSQL core, though it will likely be about 2-3 more years before this functionality is available in PostgreSQL core.


BDR is well suited for databases where:

  • Data is distributed globally
  • Majority of data is written to from only one node at a time (For example, the US node mostly writes changes to US customers, each branch office writes mostly to branch-office-specific data, and so on.)
  • There is a need for SELECTs over complete data set (lookups and consolidation)
  • There are OLTP workloads with many smaller transactions
  • Transactions mostly touching non overlapping sets of data
  • There is partition and latency tolerance

However, this is not a comprehensive list and use cases for BDR can vary based on database type and functionality.

In addition, BDR aids business continuity by providing increased availability during network faults. Applications can be closer to the data and more responsive for users, allowing for a much more satisfying end-user experience.


BDR is developed and supported by 2ndQuadrant. 2ndQuadrant provides professional support for BDR, as well as consultation and training. With our deep knowledge of distributed databases, we will ensure that you are able to evaluate your use case and applications and determine the most suitable product or solution.

BDR is also available in 2ndQuadrant Cloud, initially on AWS.

For more information, please visit the homepage: https://2ndquadrant.com/en/resources/bdr/.