Your Herd of Elephants: PostgreSQL Replication

Wednesday 11:00AM-11:50AM

@ Room H

Open Source Databases

50 minutes conference



PostgreSQL version 10 has added logical replication, and now the field of replication options in PostgreSQL has gotten wide: Streaming replication, warm standby, logical replication?

We'll discuss what the options are, their limitations and pitfalls, and what the best use-case for each one is. We'll show what it takes to set each one up, monitor it, and get it working again on failures. We'll cover:

* The history of replication in PostgreSQL.
* WAL shipping
* Streaming replication
* Trigger-based replication
* Logical decoding
* And some exotic animals


Christophe Pettus

Christophe Pettus (PostgreSQL Experts Inc.)



Christophe Pettus has been working with databases since 1992, and PostgreSQL since 1998. He's CEO of PostgreSQL, Experts, Inc., a boutique database consultancy.


  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863