Tailoring CREATE PUBLICATION command for Targeted Data Replication
(a complete syntax guide)
Presented by:
Peter Smith
Fujitsu Australia
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.
PostgreSQL's CREATE PUBLICATION command now does more than just copy tables. This presentation explores how modern PostgreSQL enables fine-grained control over exactly what data gets replicated.
We'll examine the command's evolution across PostgreSQL versions, showcasing capabilities including:
- Selective table publishing - Choose exactly which tables to replicate
- Row filtering - Replicate only rows matching specific criteria using WHERE clauses
- Column lists - Publish subsets of columns to accommodate different subscriber schemas
- DML controls - Restrict replication to certain kinds of operations
- Partitioned table support - Handle complex partitioning scenarios seamlessly
- Generated column replication - Manage computed columns
The session concludes with a preview of CREATE PUBLICATION enhancements still under development for v19.
- Date:
- 2025 October 17 11:40 +11
- Duration:
- 40 min
- Room:
- Oxford 1 + 2
- Conference:
- PG Down Under 2025
- Language:
- Track:
- Essentials
- Difficulty:
- Easy