# shayonj/pg_easy_replicate

Easily setup logical replication and switchover to new database with minimal downtime

Repository: https://github.com/shayonj/pg_easy_replicate
Canonical: https://ross.abutalabs.com/products/pg_easy_replicate
Language: Ruby
License: MIT
License Family: permissive
Topics: logical-replication, postgres, postgresql, ruby, hacktoberfest, high-availability, streaming, replication
Last push: 2026-07-27T05:26:00+00:00

## Health v2 (maintenance only)
Score: 78/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 94, release rhythm 54, longevity 85
- inputs: {"age_days": 1192, "days_push": 37, "days_rel": 310, "gap_med": 8, "n_releases_24m": 6}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1036, forks 23 (observed 2026-08-28T04:03:19.160575+00:00)

## What it is
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
- artifact type: cli-tool
- maturity: active
- function: database, streaming, deployment, cli
- domain: databases, self-hosted
- platform: cli
- tags: postgresql, logical-replication, switchover, blue-green-deployment, zero-downtime, database-migration, high-availability, ruby, devops, docker, linux, macos

## Member repositories
- shayonj/pg_easy_replicate (main) score 78

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:19.160575+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:04:43.101435+00:00, confidence not recorded.
  - readme: https://github.com/shayonj/pg_easy_replicate (fetched 2026-08-28T04:03:19.160575+00:00, sha c5d983009111)
- Data as of 2026-08-30T08:39:29.467469+00:00.