Hari Kiran
Distributed Postgres Evangelist @ pgEdge
Hari Kiran is a seasoned Database Engineer with nearly 18 years of experience in multiple domains of the IT Industry in Healthcare, Banking, Project & Portfolio Management, and CRM domains. Passionate about PostgreSQL helping Customers across geographies with Database Administration, Enterprise Implementations, Security and Hardening, Backup and Recovery, and Performance Tuning.
POSETTE 2026 Talk
Past, Present, and Future: Logical Decoding and Replication in PostgreSQL
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 Multi-master replication is shaping the future of distributed PostgreSQL. With features like out-of-box asynchronous logical replication, automated DDL propagation, and eliminating 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
Subscribe to notifications
to keep up with POSETTE news
Join the conversation
Use the hashtag #PosetteConf