dimitri/pgcopydb

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1549 stars · 118 forks observed · 2026-08-28

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

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

cli-tool · maturity active

database etl cli streaming databases developer-tools cli cross-platform postgresql database-migration logical-replication change-data-capture pg-dump pg-restore data-engineering linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="dimitri/pgcopydb")