Bucardo is a mature replication system written in Perl for PostgreSQL that supports asynchronous replication for both master-slave and multi-master systems. Originally designed for slow and unreliable networks, it has remarkable recovery ability, an easy to use command-line interface and development is active! Uses for Bucardo include: a slave read-only database, multi-master replication, data warehousing and just having fun moving your data around! Will include overview replication for PostgreSQL in general, a tour of features, and a basic configuration walk through.

http://bucardo.org/wiki/Bucardo

Note new location and we are meeting the 4th Thursday this month!

pdxpug.wordpress.com

BDR (bi-directional replication) enables asynchronous multi-master replication in Postgres as an extension and has been in full production status since 2014. We will discuss the use cases that BDR is most appropriate for, and where is might not be best suited.

Mark works at 2ndQuadrant as a consultant for English Speaking Territories, based out of Oregon. He is a Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.