Boriss Mejías is a PostgreSQL Solutions Architect at EDB, enjoying his work with his colleagues and his customers who bring challenging problems. He has given talks at many Postgres conferences and he is a co-author of the PostgreSQL 16 Administration Cookbook.
In his free time, Boriss enjoys contributing his expertise to open source communities, and he is an active member of the PostgreSQL User Group in Belgium, and co-organizer of PGDay Lowlands.
Boriss is a big fan of music - especially heavy metal and folk - and has spent decades practicing air guitar.
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 analyzing 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”.