Session
BackYour Herd of Elephants: PostgreSQL Replication
Date: 2018-09-07
Time: 21:30 - 22:20
Room: Cyril Magnin
Level: Intermediate
Feedback: Leave feedback
PostgreSQL has added in-core logical replication, and now the field of replication options in PostgreSQL has gotten extensive and complex: 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.