pgstream
« Back to VersTracker
Description:
PostgreSQL replication with DDL changes
Type: Formula  |  Latest Version: 0.9.3@0  |  Tracked Since: Dec 16, 2025
Links: Homepage  |  @xataio  |  formulae.brew.sh
Category: Databases
Tags: postgresql replication ddl database sync
Install: brew install pgstream
About:
pgstream is a tool that replicates PostgreSQL database changes while capturing and applying DDL schema modifications. It extends standard logical replication to handle schema migrations automatically across environments. This ensures schema and data consistency during replication, reducing manual intervention and potential drift.
Key Features:
  • Captures and replicates DDL changes alongside data modifications
  • Extends PostgreSQL logical replication capabilities
  • Automates schema synchronization across environments
  • Open-source tool maintained by Xata
Use Cases:
  • Maintaining schema consistency between development and production databases
  • Replicating databases with frequent schema changes
  • Setting up change data capture that handles both DDL and DML
Alternatives:
  • Debezium – More complex setup but supports multiple databases beyond PostgreSQL
  • pglogical – PostgreSQL extension for logical replication but lacks built-in DDL handling
Version History
Detected Version Rev Change Commit
Dec 16, 2025 11:13am 0 VERSION_BUMP f8b30a02
Dec 4, 2025 2:17pm 0 VERSION_BUMP 20d54adf
Nov 26, 2025 2:24pm 0 VERSION_BUMP 94032222
Nov 11, 2025 5:17pm 0 VERSION_BUMP c3d674ff
Oct 14, 2025 2:25pm 0 VERSION_BUMP 13689169
Oct 9, 2025 11:03am 0 VERSION_BUMP 4fa92703
Sep 24, 2025 5:14pm 0 VERSION_BUMP b6ec678e