pgstream
An open source change data capture (CDC) command-line tool and library for Postgres.
Replication of DDL changes
Seamlessly track and replicate schema changes, including DDL, for enhanced Postgres replication to any output destination.
Webhook ouput
Trigger a webhook endpoint of your choice instantly whenever there are changes to your Postgres schema or data.
Elasticsearch & OpenSearch output
Automatically replicate Postgres data and schema changes to Elasticsearch and Opensearch.
Modular deployment configuration
pgstream provides a turnkey solution for PostgreSQL CDC, easily extendable with transformation or message queuing modules before outputting to your desired destination.
Integrated schema tracking
Unlike other CDC solutions, pgstream uniquely tracks and replicates schema changes continuously, taking explicit actions on DDL changes and triggering events downstream.
Scalable architecture
pgstream is designed to handle high-throughput environments, making it ideal for applications with increased data needs. It also leverages efficient data processing techniques to ensure minimal latency.
Built for Postgres
The only requirement is PostgreSQL. pgstream works with every PostgreSQL variation–hosted, self-managed, serverless and hybrid. As long as you can access WAL, you can use pgstream.
Simple setup
pgstream provides a user-friendly setup and management process, making it accessible for teams without extensive experience in data replication or CDC.
Explore more resources
Postgres webhooks with pgstream
By Tudor Golubenco
• August 27, 2024
A simple tutorial for calling webhooks on Postgres data and schema changes using pgstream.
pgroll 0.6.0 update
By Andrew Farries
• July 19, 2024
Learn about the latest changes in pgroll in the 0.6.0 release as we continue to build and turn it into a first-class open-source schema migration tool for Postgres.
Start free,
pay as you grow
Xata provides the best free plan in the industry. It is production ready by default and doesn't pause or cool-down. Take your time to build your business and upgrade when you're ready to scale.
- Single team member
- 10 database branches
- High availability
- 15 GB data storage
- Single team member
- 10 database branches
- High availability
- 15 GB data storage
Copyright © 2024 Xatabase Inc.
All rights reserved.