RELIABLY REPLICATING DATA BETWEEN POSTGRESQL AND CLICKHOUSE PART 1 - PEERDB OPEN SOURCE

Summary from the TLDR Web Dev newsletter

Clickhouse is increasingly used for analytics by PostgreSQL users, and this often requires data replication between the two. PeerDB is an open-source CDC (Change Data Capture) solution that can be used to make data replication easy. This article goes over how to deploy PeerDB, create test data, and set up initial replication and schema evolution.