pgsync: Efficient Data Synchronization for Postgres Databases icon

pgsync: Efficient Data Synchronization for Postgres Databases

pgsync is a robust command-line tool designed to synchronize data seamlessly between Postgres databases. It prioritizes speed, security, and flexibility, allowing users to efficiently transfer data while adhering to schema differences and protecting sensitive information.

Features

Parallel table transfers for enhanced speed

Built-in security measures to prevent sensitive data leaks

Flexible schema handling, accommodating missing or extra columns

Partial table synchronization, supporting individual tables or groups of related records

Comprehensive support for sensitive data masking and transformation

Options for managing foreign key constraints and triggers during synchronization

Support for multiple databases with customizable configurations

Repository Details

3,188
201
Updated: 11/30/2024

Languages

Ruby
PLpgSQL
Dockerfile

Topics

postgresql

License

MIT License