Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience our own tag's counts — open to see them
–Visits
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · visits, page views and clicks counted by our own tag, which counts more than our checked analytics; every figure rounded down · how we count

pgstream review

Free#19 of 22 in Change Data Capture Software

A focused self-hosted CDC tool for PostgreSQL replication and custom targets.

7.1/10Editor score
Visit pgstream
pgstream7.1 Visit pgstream

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

pgstream is an open-source, self-hosted PostgreSQL change data capture command-line tool and Go library. It is designed for teams that need to replicate PostgreSQL data and schema changes into PostgreSQL, Elasticsearch, OpenSearch, Kafka, webhooks, or custom destinations. That makes it a focused fit for PostgreSQL replication, search indexing, event streaming, environment synchronization, and workflows that need control over their deployment.

Its standout capability is the combination of logical WAL replication with DDL and schema-change tracking. pgstream can take initial and on-demand PostgreSQL snapshots, then continue replicating data changes while carrying schema changes with them. Column-value transformations support data anonymization, which is useful when replicated data needs to be adjusted for another environment. Kafka schema-based partitioning adds a purpose-built option for event-streaming workflows, while OpenTelemetry metrics and distributed tracing provide observability signals for the replication process.

The target ecosystem covers PostgreSQL, Elasticsearch, OpenSearch, Kafka, and webhooks, with a Go library for building custom targets. Integrations with Greenmask, Neosync, and go-masker extend the surrounding data-management options. The trade-off is a narrow source focus: pgstream centers on PostgreSQL rather than serving as a multi-database CDC layer. Teams standardizing on PostgreSQL and needing custom destinations should consider it; teams requiring capture from multiple database systems should choose a broader alternative.

pgstream pros and cons

  • Where it wins
    • Replicates logical WAL data and DDL schema changes
    • Supports PostgreSQL, search, Kafka, webhooks, and custom Go targets
    • Includes snapshots, anonymization, and OpenTelemetry observability
  • Where it doesn't
    • PostgreSQL-only source scope limits multi-database CDC use cases
    • Self-hosted deployment requires teams to manage the operating environment
    • No AI features are included

pgstream fact sheet, pricing and score →

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated · How we research and update