# dimitri/pgcopydb

Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)

Repository: https://github.com/dimitri/pgcopydb
Canonical: https://ross.abutalabs.com/products/pgcopydb
Language: C
License: NOASSERTION
License Family: other
Last push: 2026-07-03T19:56:48+00:00

## Health v2 (maintenance only)
Score: 81/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 90, release rhythm 58, longevity 100
- inputs: {"age_days": 1717, "days_push": 61, "days_rel": 67, "gap_med": null, "n_releases_24m": 1}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1549, forks 118 (observed 2026-08-28T04:05:01.976472+00:00)

## What it is
pgcopydb is a command-line tool that automates copying a PostgreSQL database between two running servers, combining pg_dump/pg_restore for schema with its own parallel multi-process data streaming. It also supports Change Data Capture via logical decoding for online migrations with change replay.

## Use cases
- clone a postgres database to another server quickly
- migrate a postgres database with minimal downtime
- stream table data in parallel between postgres instances
- replay WAL changes from source to target postgres
- copy all databases of a postgres instance at once
- rebuild indexes concurrently after a database copy

## When to choose
- you need faster database copies than pg_dump | pg_restore pipelines
- you want online migration with change data capture
- you need parallel data copy and concurrent index builds
- you want a single tool for offline and online postgres migrations

## When to avoid
- you only need logical backups stored as files (use pg_dump)
- your source is not PostgreSQL
- you need replication to non-Postgres targets
- you want a GUI-based migration tool

## Facets
- artifact type: cli-tool
- maturity: active
- function: database, etl, cli, streaming
- domain: databases, developer-tools
- platform: cli, cross-platform
- tags: postgresql, database-migration, logical-replication, change-data-capture, pg-dump, pg-restore, data-engineering, linux, macos

## Member repositories
- dimitri/pgcopydb (main) score 81

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:01.976472+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-30T04:30:22.356134+00:00, confidence not recorded.
  - readme: https://github.com/dimitri/pgcopydb (fetched 2026-08-28T04:05:01.976472+00:00, sha 0ff7885e50dd)
- Data as of 2026-08-30T08:39:29.467469+00:00.