v.21.8New Feature

Add MaterializedPostgreSQL Table Engine for Database Replication

Official CH changelog text
Add MaterializedPostgreSQL table engine and database engine. This database engine allows replicating a whole database or any subset of database tables. #20470 (Kseniia Sumarokova).
Introduces the MaterializedPostgreSQL table engine and a corresponding database engine in ClickHouse for replicating entire PostgreSQL databases or subsets of tables.

Why it matters

This feature enables users to efficiently synchronize data from PostgreSQL by replicating a full database or selected tables into ClickHouse, facilitating real-time analytics and reducing ETL overhead.

How to use it

Create a database with the MaterializedPostgreSQL engine specifying the connection to the source PostgreSQL database. Then, use MaterializedPostgreSQL tables within that database to replicate data from PostgreSQL tables seamlessly.

Related resources

PreviousNext