Speeding up logical replication setup
Friday, October 25 at 10:30–11:20
Room: Ilissos
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.
