Postgres Logical Replication: Let's Do It Live!


Postgres 10 added a new form of replication; logical replication; into its wide array of replication and failover options. In this talk, we'll cover:

  • a brief history of replication in Postgres
  • what is logical replication?
  • differences between Postgres 10 and 11
  • how does it differ from other replication options?
  • good use cases for logical replication
  • not good use cases

Once we cover the basics, we'll then walk through a live demo of setting up logical replication between two servers and do live experimentation with our cluster based on audience participation. This will include setting up a schema, setting up replication, watching data changes go by, and then looking at things like DDL changes, or more esoteric commands like what happens when you truncate a table, or what happens if you change your schema between servers? To wrap it up, we'll answer some FAQ's around logical replication, so attendees will be ready to hit the ground running with their own logical replication experiments.

Room 106
Friday, March 8, 2019 - 16:00 to 17:00