Presented by:
Peter Smith
Peter is a PostgreSQL contributor and member of Fujitsu's Open Source Software team, specialising in logical replication development. He actively reviews enhancements to PostgreSQL's replication capabilities. Peter also writes technical blogs sharing insights on PostgreSQL development and internals.
Ajin Cherian
No video of the event yet, sorry!
This talk will be co-presented by Peter Smith and Ajin Cherian.
PostgreSQL 19 brings significant enhancements to logical replication, giving administrators far greater control over what gets replicated and how. In this talk, two Fujitsu contributors who worked directly on these features cover complementary aspects of the same story.
Peter Smith opens with the new publication syntax. PostgreSQL 19 introduces FOR ALL TABLES EXCEPT and FOR ALL SEQUENCES, with further variants arriving in subsequent releases including schema-scoped exclusions. Peter walks through the syntax, behaviour, and practical use cases for each new variant, showing how these additions make publication management significantly more flexible.
Ajin Cherian then picks up the sequence thread. Logical replication has made major version upgrades significantly easier by allowing physical standbys to be converted into logical subscribers with minimal downtime — but until PostgreSQL 19, sequence synchronization remained a key gap. Ajin explores how the new sequence replication support closes that gap, explaining why synchronized sequences matter, how ALTER SUBSCRIPTION ... REFRESH SEQUENCES works internally, and how to integrate it into a reliable upgrade workflow using pg_createsubscriber.
- Date:
- Duration:
- 40 min
- Room:
- Conference:
- PG Down Under 2026
- Language:
- Track:
- Essentials
- Difficulty:
- Medium