PGCon2018 - 2.5

PGCon 2018
The PostgreSQL Conference

Christophe Pettus
Day Talks - Day 2: Friday - 2018-06-01
Room DMS 1120
Start time 15:00
Duration 00:45
ID 1150
Track Scaling Out
Language used for presentation English

Your Herd of Elephants: PostgreSQL Replication

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.