v.21.11New Features

Support Dynamic Table Management in MaterializedPostgreSQL Replication

Official CH changelog text
Support adding / deleting tables to replication from PostgreSQL dynamically in database engine MaterializedPostgreSQL. Support alter for database settings. Closes #27573. #28301 (Kseniia Sumarokova).
Support for dynamically adding and deleting tables in replication from PostgreSQL within the MaterializedPostgreSQL database engine, along with support for altering database settings.

Why it matters

This feature addresses the need for more flexible and dynamic replication management in the MaterializedPostgreSQL engine. It enables users to modify replication tables on the fly without restarting or redeploying, improving operational convenience and control. Additionally, allowing alterations to database settings provides enhanced configurability.

How to use it

Users can dynamically add or remove tables from the replication stream in the MaterializedPostgreSQL engine by executing appropriate commands or altering the database configuration. Database settings can be modified using ALTER DATABASE statements targeting the MaterializedPostgreSQL database to adjust replication behavior or other parameters.

Related resources

PreviousNext