Postgres CDC connector is now Generally Available

Replicate your Postgres data to ClickHouse Cloud in just a few clicks for blazing fast analytics. Eliminates the need for external ETL tools that are expensive, slow and not purpose built for Postgres. Learn more.

Start a free cloud trial

Our postgres CDC connector is already Trusted by

Blazing-fast

Achieve 10x faster initial loads with parallel snapshotting, transferring TBs in hours, and experience continuous replication latency of just a few seconds.

Simple

Easily replicate your Postgres databases to ClickHouse Cloud in just a few clicks and few minutes!

Flexible

Connect any Postgres database, hosted or on-prem, including RDS, Azure Flexible Server, CloudSQL, Supabase, Neon, Crunchy Bridge, Tembo, and more.

Feature rich

This connector is purpose-built for Postgres and ClickHouse, supporting features like schema changes, partitioned tables, TOAST columns, customizable ordering keys, and more.

Powered by PeerDB

The connector is powered by PeerDB, a leading open-source Postgres CDC provider, which ClickHouse acquired a few months ago. Since PeerDB is open source, there’s no vendor lock-in!

supports a wide range of Postgres data sources

What our customers are saying

ClickHouse powers Ashby's customer-facing analytics, delivering lightning-fast, fully dynamic insights, while Postgres handles core transactions. With Postgres CDC via ClickPipes, we seamlessly replicate terabytes of data and speed up our real-time analytics without disrupting operations. Reports that once took minutes now finish within a second. Complementing Postgres with ClickHouse enables us to provide a lightning-fast and fully reliable experience and handle even larger data as we scale.

We are having an amazing experience using the Postgres CDC connector in ClickPipes. We seamlessly moved our 30TB Aurora database to ClickHouse Cloud and are continuously keeping it in sync. We did not expect any ETL tool to handle our load, especially after a bitter experience in the past. However, we were pleasantly surprised by how reliable and performant ClickPipes has been for us.

We already reduced our Postgres to ClickHouse snapshot times from 10+ hours down to 15 minutes with PeerDB. Combining ClickHouse’s powerful analytics natively with PeerDB’s real-time data capture capabilities will greatly simplify our data processing workflows. This integration will enable us to build analytical applications faster, giving us a competitive edge in the market.