shayonj/pg_easy_replicate
Pg Easy Replicate
pg_easy_replicate is a command-line utility designed to orchestrate database migrations and logical replication between PostgreSQL instances. It functions as a migration orchestrator that manages the entire lifecycle of data synchronization, from initial schema propagation to the final transition of application traffic.
The tool distinguishes itself through state-aware switchover logic, which coordinates the movement of operations by verifying replication lag and enforcing write locks to prevent data loss. It provides granular control over data movement by allowing users to organize tables into specific replication groups, ensuring that only intended records are synchronized between the source and target environments.
Beyond core migration tasks, the project includes comprehensive monitoring capabilities to track synchronization health and replication lag in real time. It supports integration with external systems by pushing status updates and replication metrics to configured webhook endpoints, facilitating automated observability within existing infrastructure workflows.
Features
- Atomic Database Migrations - Orchestrates the synchronization of schema and data between PostgreSQL instances with automated switchover processes.
- Zero-Downtime Migrations - Transitions live application traffic from an old database to a new one while minimizing service interruptions.
- Database Replication Orchestrators - Manages the lifecycle of database-native replication slots and publication groups to ensure consistent data flow between nodes.
- Database Replication Tools - Automates data synchronization between source and target databases to ensure seamless migrations.
- Logical Replication Ingestion - Uses native database logical replication protocols to stream row-level changes between instances.
- Logical Replication Synchronization - Maintains continuous data streams between databases to keep information consistent during migrations.
- PostgreSQL-to-PostgreSQL Migrations - Moves data and schema between PostgreSQL instances while keeping systems synchronized for a seamless transition.
- Graceful Primary Switchovers - Transitions operations from source to target by verifying data lag and locking the source database.
- Database Migration Switchovers - Coordinates the transition of traffic by verifying replication lag and enforcing write locks to prevent data loss during migration.
- Database Synchronization - Tracks real-time replication lag and synchronization status to ensure target databases remain accurate copies.
- Replication Group Configurations - Organizes database tables into logical sets to control exactly which data moves between systems.
- Schema-First Migration Pipelines - Extracts and applies structural definitions before initializing data streams to ensure target tables match the source environment.
- Schema Synchronization Tools - Copies table structures and data from a source database to a target instance to prepare for migration.
- Automated Schema Propagation - Tracks and propagates structural updates from the source database to the target to maintain consistent table definitions.
- Replication Health Monitors - Tracks real-time replication lag and synchronization status between source and target database nodes.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
