pgstream
pgstream: A focused self-hosted CDC tool for PostgreSQL replication and custom targets. Ranked #19 of 22 in Change Data Capture Software by our editors (7.1/10); pricing: Open source; best for postgreSQL replication with custom targets.
At a glance
- Editor score7.1 / 10
- PricingOpen source
- Best forPostgreSQL replication with custom targets
- Paid fromFree
- Deployment modelSelf-hosted
- Facts checked20 Sep 2026

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
Our verdict on pgstream
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.
Your product? Our editors can test pgstream in depth and publish a review, labelled as paid · from $149/mo →
pgstream pricing
pgstream fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Deployment model | Self-hosted |
| Capture method | Log-based |
| Source connectors | Not verified |
| Destination connectors | Not verified |
| Schema evolution | Yes |
| Initial snapshot | Yes |
| Deployment | Self-hosted |
| Support | Community, Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 8 integrations: PostgreSQL, Elasticsearch, OpenSearch, Kafka, webhooks, Greenmask … |
| Pricing | Open source |
| Website | xata.io |
| Facts checked | 20 Sep 2026 |
pgstream integrations
pgstream lists 8 integrations on its own site.
- PostgreSQL
- Elasticsearch
- OpenSearch
- Kafka
- webhooks
- Greenmask
- Neosync
- go-masker
Alternatives to pgstream
- DebeziumA flexible, self-hosted CDC platform for streaming database changes across broad ecosystems.9.4
- Apache Flink CDCA flexible CDC foundation for teams building Flink-based streaming pipelines.9.2
- Oracle GoldenGateA deep enterprise CDC platform for bidirectional replication, migrations, and multicloud data movement.9.0
See all pgstream alternatives →
Used pgstream? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used pgstream for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
pgstream is listed in our Change Data Capture Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/pgstream/"><img src="https://www.itechguides.com/best/badge/pgstream.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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

