Logical replication in PostgreSQL is great for multiple use cases such major upgrades with nearly-zero downtime, consolidation of multiple databases into a warehouse, and more recently, bi-directional replication for geo-redundancy, with the promise of an active-active architecture. All these possibilities are evidence that logical replication is far richer than physical replication. However, that richness comes with higher complexity and nuances that makes it challenging. Oh yeah, and that’s fun, isn’t it?

In this presentation we will not just discuss in theory the nuances and challenges, we will have a live session analysing different scenarios, reviewing best and worst practices, breaking the replication and fixing it, so that the publisher database keeps on streaming, keeping the beat.

Logical replication is complex, but as the Zen of Python says, “better complex than complicated”.