Presented by:

C88cf192fe7a9b8efd42c83be283612a

Robert Treat

xzilla

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 https://xzilla.net

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.

Date:
2019 March 22 13:00
Duration:
50 min
Room:
New York Ballroom East
Conference:
Postgres Conference
Language:
Track:
Ops and Administration
Difficulty:
Medium