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 has been working with databases since 1992, and PostgreSQL since 1998. He's CEO of PostgreSQL, Experts, Inc., a boutique database consultancy.
Stay Connected on:
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.
For general information about the event/expo/conference, including registration, please contact us at: