PostgreSQL Replication - The Most Exciting Technology on Earth

Accepted Session
Short Form
Scheduled: Thursday, June 20, 2013 from 3:45 – 4:30pm in B204


This electric discussion will journey through several available methods of replication using PostgreSQL.


Replication is a staple of every database technology. It offers the potential for better availability, more scaling, and more reliability. It also offers the potential for late nights and inaccurate perceptions of reliability. Knowing your options is the best bet for your to choose the right technology, and to always be able to answer “it depends” when someone asks you if, and which, replication solution to implement. This talk strives to answer “it depends” with joy.

The purpose of this talk is to explore the different kinds of replication technologies available (streaming\binary, object-specific, WAL-shipping), and what the pros and cons are of each. Next, I’ll dive a little deeper into the built-in replication technologies available in Postgres 9.x, including what is new to 9.2. Finally, I will touch on Bucardo, PgPool and potentially other popular third-party replication options, to give the audience a clear picture of what is out there, what each one offers, and what the caveats are.

Speaking experience

I have spoken at local user groups (Oregon SQL Developers, Portland PG User group). I have presented this once at the PDX PG User group, and once internally for engineering. I have also done presentations at Code Camp and SQL Saturday on database administration topics.

Here is a talk I did for OSCON Ignite 2012: