pgsync ☆

« Back to VersTracker

Description:
Sync Postgres data between databases

Type: Formula | Latest Version: 0.8.1@0 | Tracked Since: Dec 26, 2025

Links: Homepage | GitHub | formulae.brew.sh

Stars: 3,413 | Forks: 214 | Language: Ruby | Category: Databases

Tags: postgresql database sync ruby cli

Install: brew install pgsync

About:
pgsync is a command-line tool that synchronizes data between PostgreSQL databases. It intelligently handles schema differences and incremental updates, making it ideal for replicating subsets of data for development, testing, or reporting. Its main value is providing a simple, safe, and efficient way to move Postgres data without complex ETL processes.

Key Features:

Synchronizes data between PostgreSQL databases
Handles schema differences and incremental updates
Command-line interface for easy automation
Supports table groups and data filtering
Safe for production use with minimal locking

Use Cases:

Creating a development database with a subset of production data
Migrating or replicating data between different PostgreSQL instances or schemas

Alternatives:

pg_dump/pg_restore – Official PostgreSQL tools for full backups/restores, less flexible for syncing specific, changing data subsets.
replica – Built-in PostgreSQL replication is for entire databases; pgsync is for selective, one-time, or filtered data syncs.

Version History

Detected	Version	Rev	Change	Commit
Dec 26, 2025 5:58pm	0.8.1	0	VERSION_BUMP	14d2f25f
Dec 26, 2024 5:42pm		1	VERSION_BUMP	49bd61de