pgstream

API—OSS—FREEyesDOCS5/5
PG5.9#11 of 19
—Web—WindowsoutMacoutLinux—Android—iOS

Ranked in Change Data Capture Software ·Free plan

About

pgstream is ranked #11 of 19 in change data capture software on Inferse. It runs on Linux, macOS, Self-hosted. There is a free plan.

Compared on change data capture software

Deployment model
self-hostedxata.io
Capture method
log-basedxata.io
Schema evolution
Yesxata.io
Initial snapshot
Yesxata.io

Facts

Purpose
pgstream is an open-source CDC command-line tool and Go library for replicating PostgreSQL data and DDL changes to targets.xata.io · 4 Oct 2026
Schema changes
It tracks and replicates schema changes alongside data changes.xata.io · 4 Oct 2026
Targets
Built-in targets include PostgreSQL, Elasticsearch/OpenSearch, Kafka, and webhooks.xata.io · 4 Oct 2026
Snapshots
It supports initial and on-demand PostgreSQL snapshots for bulk loads or point-in-time copies.xata.io · 4 Oct 2026
Anonymization
Column values can be transformed during replication using greenmask, neosync, go-masker, or custom transformers.github.com · 4 Oct 2026
Deployment
pgstream can run as a standalone CLI or be embedded as a Go library, and requires PostgreSQL as a dependency.xata.io · 4 Oct 2026
Installation
The docs describe installing from a Go binary, building from source, or using Homebrew on macOS or Linux.xata.io · 4 Oct 2026
License
The project is licensed under Apache License 2.0.github.com · 4 Oct 2026
Support
The project README directs users with questions or issues to open a GitHub issue for community assistance.github.com · 4 Oct 2026
Limitations
The README lists single Kafka topic support, wal2json-only Postgres plugin support, no row-level filtering, and a primary-key or unique non-null column requirement as limitations of the initial release.github.com · 4 Oct 2026
Security
The product page describes built-in anonymization for masking production data as it is replicated to development or staging.xata.io · 4 Oct 2026
Intended use
The product page describes using pgstream to keep staging databases in sync with production and to bootstrap targets with snapshots.xata.io · 4 Oct 2026
DDL tracking
It tracks and replicates schema changes alongside data changes so downstream targets can follow table changes.xata.io · 4 Oct 2026
Interfaces
pgstream can run as a standalone CLI tool or be embedded as a Go library.xata.io · 4 Oct 2026
Deployment dependency
The product page says pgstream requires PostgreSQL as its only dependency and does not require ZooKeeper or Kafka.xata.io · 4 Oct 2026
Kafka support
Kafka support includes schema-based partitioning.xata.io · 4 Oct 2026
Maker security
Xata states that it is SOC 2, HIPAA, and GDPR compliant; this statement describes Xata and does not specify pgstream as a separately certified product.xata.io · 4 Oct 2026

Company

Maker founded
Xata says it formed in 2021.xata.io · 4 Oct 2026

Best pgstream alternatives

See all 12

Where it ranks on Inferse

Sources