Logical Replication of DDLs

on YouTube ↗56m

" summary

Adds DDL replication to PostgreSQL via a new publication parameter ddl and a new WAL record type xlog logical ddl message. Implementation captures DDL with event triggers, encodes a structured JSON payload (based on a departing utility) so the subscriber reconstructs and executes commands, supports table/index granularity initially, handles CREATE TABLE AS, name and ownership mapping, and transforms unsafe cases. Development appears as 8 patches on the pgsql-hackers thread with testing, while global-object replication and automated initial schema sync remain future work.

AI-written summary · about

" chapters (3)

1. 0:00Introduction and motivation
2. 21:23Technical implementation
3. 46:45Q&A and future outlook

" related talks

• 29mLogical replication theory and conceptsAshutosh Bapat · POSETTE: An Event for Postgres 2025
• 59mLogical Replication...LIVE!Robert Treat · PostgresOpen Silicon Valley 2017
• 54mUnderstanding Logical Decoding and ReplicationMichael Paquier · PostgresOpen 2014
• 31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQLHari P Kiran · POSETTE: An Event for Postgres 2026
• 44mThe journey towards active-active replication in PostgreSQLJonathan S. Katz · PostgreSQL Conference Europe 2023
• 38mA journey into postgresql logical replicationJosé Neves · PostgreSQL Conference Europe 2023
• 50mPGLogical the logical replication for PostgresqlPetr Jelinek · PGConf Silicon Valley 2016
• 24mAutomatic DDL Replication with pgEdge Distributed PostgresHari P Kiran · FOSSASIA PGDay 2025