pgsync
A command-line tool to efficiently and securely sync data between PostgreSQL databases with parallel transfers and data masking.
What is pgsync?
pgsync is a command-line tool that synchronizes data from one PostgreSQL database to another. It solves the problem of safely and efficiently migrating or replicating data between databases, especially when dealing with sensitive information, schema differences, or large datasets. Unlike basic dump/restore utilities, it offers parallel transfers, data masking, and fine-grained control over what gets synced.
Developers, database administrators, and DevOps engineers who need to move data between PostgreSQL instances for staging, testing, reporting, or migration purposes.
Developers choose pgsync for its balance of speed, security, and flexibility—it handles real-world complexities like partial syncs and data anonymization out-of-the-box, while being simpler to configure than custom ETL scripts.
Overview
Sync data from one Postgres database to another
Use Cases
Best For
- Creating a secure staging database from production with masked sensitive data
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
