Presented by:

Robert Treat
With more than two dozen years working in tech, I've done everything from first line support to CEO of a multi-million dollar company. I've served on corporate boards and volunteered at non-profits, worked as a founder, and survived more than 2 dozen "ownership changes" during my career. Along the way I've become a writer and international speaker on topics such as free software and managing web operations at scale. I've also contributed to numerous open source projects and communities, although I am probably best known for my work with Postgres, where I was recognized as a Major Contributor.
No video of the event yet, sorry!
Postgres has a lot of ways to do replication and other forms of multi-server environments, but logical replication is one of the most useful. Want to know why? In this talk we'll talk about:
• a (very) brief history of replication in Postgres • the whats and hows of logical replication • differences between Postgres 10, 11, and 12 • good use cases for logical replication • not good use cases and better alternatives
After we talk about logical replication, we'll walk through a live demo of setting up replication between two servers, including setting up a schema and replicating data across the wire. After we cover the basics, we'll do some live, unscripted, audience-led, experimentation with our cluster, looking at things like DDL changes and 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.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2020
- Language:
- Track:
- Distributed SQL
- Difficulty:
- Easy