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.
The following slides have been made available for this session: