PGCon2018 - 2.5
PGCon 2018
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Christophe Pettus |
| Schedule | |
|---|---|
| Day | Talks - Day 2: Friday - 2018-06-01 |
| Room | DMS 1120 |
| Start time | 15:00 |
| Duration | 00:45 |
| Info | |
| 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.