Euler Taveira - Speeding up logical replication setup (PGConf.EU 2024)

Conference: PGConf.EU

Year: 2024

Logical replica is a popular choice if you want to migrate an existing cluster with minimal downtime. For large databases, it can take a considerable amount of time and resources (WAL retention while copying table data) to finish the setup. pg_createsubscriber is a new tool for Postgres 17 that aims to create a logical replica faster than the regular method (initial data synchronization). It creates a logical replica using a physical replica. All tables in the specified databases are included in the replication setup. This talk will explain the pg_createsubscriber in detail. Present the options, limitations and future development.

Discussion (0)

Join the discussion!

Subscribe to post comments and join our community of developers.

No comments yet. Be the first to comment!