Conference Schedule - PGCon 2023

Logical Replication of DDLs

Date: 2023-05-31
Time: 14:00–14:45
Room: DMS 1120
Level: Intermediate

Are you ready to dive into the exciting world of DDL replication in Postgres? In this talk, we’ll explore the existing methods available for replicating DDL statements with a focus on how do we implement DDL replication as a Postgres built-in feature.

We’ll start by taking a look at the use cases and different replication options, such as pg_dump or pglogical2. Then, we’ll dive into the nitty-gritty of how we implement DDL replication in Postgres core, with a special focus on the logical replication infrastructure, event triggers, DDL deparse utility, UI changes, special case handling and testing. We’ll also briefly go over related issues such as the ownership of replicated objects, global objects replication and the initial schema synchronization.

link to video


The following slides have been made available for this session:


Peter Smith
Zheng(Zane) Li