Past, Present, and Future: Logical Decoding and Replication in PostgreSQL
Presented by:
Hari Kiran
Hari Kiran is a seasoned Database Engineer with nearly 18 years of experience in multiple domains of the IT industry, including healthcare, banking, project & portfolio management, and CRM. He is passionate about PostgreSQL and has helped customers across various geographies with database administration, enterprise implementations, security and hardening, backup and recovery, and performance tuning. Hari has worked at companies such as GE, EDB, Oracle, Optum, and 2ndQuadrant. He is also a regular speaker at PostgreSQL conferences like FOSSASIA Summit, PGConf India/ASIA and PGConf Down Under in Australia.
No video of the event yet, sorry!
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 PG94 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 Multi-master replication, are shaping the future of distributed PostgreSQL. With features like out-of-box asynchronous logical replication, automated DDL propagation, and the elimination of the traditional limitations of read-only replicas or single-writer systems.
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 PostgreSQL is extending for a globally distributed, logically replicated future.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference: 2026
- Language:
- Track:
- Ops
- Difficulty:
- Medium