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.
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