Presented by:


Robert Treat


Working on database-backed, internet-based systems for over a decade, Robert is a long time user, developer, and advocate for open source technologies. Best known for his work in the Postgres community, he has contributed to numerous industry groups and is currently a co-organizer for both Baltimore and DC DevOpsDays conferences. An international speaker on databases, open source, and web operations, he occasionally blogs at

No video of the event yet, sorry!

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

• a (very) 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.

2019 March 22 13:00 EDT
50 min
New York Ballroom East
Postgres Conference
Ops and Administration