Your Herd of Elephants: PostgreSQL Replication
Schedule

Presented by:

6a961946320454083402aab4cde4bba9

Christophe Pettus

from PostgreSQL Experts, Inc.

Christophe is the CEO and lead consultant at PostgreSQL Experts, Inc., a database consultancy. He's been doing database things since 1997.

PostgreSQL has added in-core 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.

Date:
Duration:
45 min
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Medium