pgcopydb ☆
« Back to VersTracker
Description:
Copy a Postgres database to a target Postgres server
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  @dimitri_p  |  formulae.brew.sh
Category: Databases
Tags: postgresql database migration cli backup
Install: brew install pgcopydb
About:
pgcopydb is a utility that copies a complete PostgreSQL database to a target server. It handles the entire process, including schema creation, data migration, and object dependencies. The tool is designed to be robust and efficient for large databases.
Key Features:
  • Automated schema and data migration
  • Handles sequences, indexes, and constraints
  • Supports parallel data copying for speed
  • Can copy from a physical replica
Use Cases:
  • Migrating a production database to a new server
  • Creating a staging environment identical to production
  • Cloning a database for development or testing
Alternatives:
  • pg_dump / pg_restore – Standard PostgreSQL tools; pgcopydb is often faster and handles parallelism automatically.
  • pgloader – Excellent for migrating from other databases (like MySQL) to Postgres, while pgcopydb is specialized for Postgres-to-Postgres.
Version History
Detected Version Rev Change Commit
Sep 11, 2024 9:02am 0 VERSION_BUMP 5adb1585
« Back to VersTracker  |  Browse Packages  |  About