Postgresql to Clickhouse

[meysammeisam]

This project supports toolsets to Dump Mysql data and then restore it to Clickhouse.
We are using it for our Mysql replications, but I'm wondering what would be the solution for the Postgresql DBs.
Does anyone know any workaround or toolset to cover that?
So the idea is to:

• Start the Sink Connector Light in schema-only mode to incrementally replicate the data from the source DB to CH
• Dump the rest of the data and restore it to Clickhouse manually

As mentioned before, we do the same with Mysql DBs and now looking for a similar solution for our Postgres DBs.

[aadant]

@meysammeisam indeed, it is a cool feature. We would also need to implement the checksum for Postgres and the fast table counts.

This project is open source, feel free to contribute !