Logical replication has evolved into a foundational capability for modern PostgreSQL deployments, enabling real-time data synchronization, partial replication. What began as a low-level decoding API in PostgreSQL 9.4 has now matured into a powerful feature, allowing for fine-grained control over what gets replicated and where.
In this talk, we’ll trace the journey of logical decoding and replication in PostgreSQL, from its early adoption through extensions like pglogical, to the robust native features introduced in recent PostgreSQL releases. We’ll dive into how these capabilities have empowered change data capture (CDC), zero-downtime migrations, and real-time analytics pipelines.
We’ll also explore how innovations in the ecosystem, particularly the work of pgEdge Spock and AWS pgactive are shaping the future of distributed PostgreSQL.
Key takeaways:
– Understand the architecture and internals of logical decoding
– Compare native and extension-based logical replication
– Discover what’s next: DDL replication, performance tuning, and multi-master replication
– Learn how extensions from pgEdge and AWS are extending PostgreSQL for a globally distributed, logically replicated future
