shayonj/pg_easy_replicate

Health v2 · maintenance only

Adoption not part of the score

1036 stars · 23 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pg_easy_replicate is a Ruby CLI tool that orchestrates logical replication between two PostgreSQL databases and performs switchover with minimal downtime. It is designed for zero-data-loss major version upgrades in Blue/Green database setups, battle-tested in production at Tines.

Use cases

• migrate postgres database with minimal downtime
• upgrade postgresql major version with zero data loss
• set up logical replication between two postgres databases
• perform blue-green database switchover
• replicate specific tables or exclude tables in postgres
• put source database in read-only mode and flush data to new target

When to choose

• you need minimal-downtime PostgreSQL major version upgrades
• you want a CLI orchestrator for logical replication and switchover
• you run a Blue/Green PostgreSQL setup and need failover strategies
• you need DDL change tracking between source and target databases

When to avoid

• you use a database other than PostgreSQL
• you need continuous replication as a long-term solution rather than a switchover
• you want a GUI-based migration tool
• your source database does not support logical replication

Facets

cli-tool · maturity active

database streaming deployment cli databases self-hosted cli postgresql logical-replication switchover blue-green-deployment zero-downtime database-migration high-availability ruby devops docker linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="shayonj/pg_easy_replicate")