ankane/pgsync

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

3468 stars · 219 forks observed · 2026-08-28

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

pgsync is a Ruby command-line tool that syncs data from one Postgres database to another, similar to pg_dump/pg_restore. It transfers tables in parallel, supports partial and grouped table syncs, and includes safeguards to keep sensitive data from leaving the server.

Use cases

• sync data from one postgres database to another
• copy production data to a local development database
• sync specific tables or rows between postgres databases
• refresh staging database with production data safely
• sync a record and its related records across databases
• handle schema differences when syncing postgres data

When to choose

• you need fast, parallel data transfer between two Postgres databases
• you want to sync partial tables, filtered rows, or related record groups
• you need to avoid copying sensitive data off a server
• your databases may have slightly different schemas

When to avoid

• you need to sync between different database engines, not just Postgres
• you need continuous or real-time replication rather than one-off syncs
• you need to sync schema changes as the primary goal - use a migration tool

Facets

cli-tool · maturity active

database etl cli databases developer-tools cli postgresql data-sync pg-dump ruby database-utilities data-engineering macos linux docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="ankane/pgsync")