pgstream - Postgres replication with DDL changes
pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided target.
Features
Schema change tracking and replication of DDL changes
Support for multiple out of the box targets Elasticsearch/OpenSearch Webhooks PostgreSQL
Initial and on demand PostgreSQL snapshots (for when you don't need continuous replication)
Column value transformations (anonymise your data on the go!)
Modular deployment configuration, only requires Postgres
Kafka support with schema based partitioning
Extendable support for custom targets
... continue reading