pkg.soopen package index

brew / rank 6388

Install pgcopydb with Homebrew, apt, Nix

Copy a Postgres database to a target Postgres server. Version 0.18 via Homebrew; verified 2026-09-13. Also installable with debian: sudo apt install pgcopydb.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install pgcopydb

local Homebrew formula metadata

Linux

Debian aptverified · 92%
sudo apt install pgcopydb

Debian stable package indexes · pgcopydb · source: deb.debian.org

Nixverified · 92%
nix profile install nixpkgs#pgcopydb

nixpkgs package indexes · pkgs/by-name/pg/pgcopydb/package.nix · source: api.github.com

overview

Package summary

Copy a Postgres database to a target Postgres server

Commands and aliases

  • pgcopydb

history

Project history and usage

pgcopydb is a PostgreSQL migration utility that copies a database between servers using parallel and streaming techniques, with optional change data capture to reduce cutover downtime.

Project history

Dimitri Fontaine created pgcopydb to automate fast PostgreSQL-to-PostgreSQL database copies while bypassing intermediate table-data files. The project later expanded beyond its base-copy workflow into change data capture, comparison, filtering, and extension-aware migration.

Version 0.8 introduced the --follow change-data-capture workflow in 2022. Subsequent releases refined logical decoding, same-table concurrency, internal job coordination, resumability, and migration reliability.

Adoption history

pgcopydb is distributed through Homebrew, Debian, Ubuntu, and Nix packaging channels. Its documentation also describes tagged container images, supporting use in repeatable migration environments.

How it is used

Operators set source and target PostgreSQL connection URIs and run pgcopydb clone, optionally tuning table and index worker counts. Advanced workflows use exported snapshots and --follow to replay changes made during the base copy.

Why package nerds care

pgcopydb occupies the practical space between a simple pg_dump/pg_restore pipeline and a full migration platform. It is notable for combining parallel COPY, concurrent index creation, resumable internal catalogs, and optional logical-decoding-based change capture in one command-line package.

Timeline

  • 2022: Version 0.8 introduced Change Data Capture and the pgcopydb clone --follow workflow.
  • 2023: Releases expanded comparison, filtering, logical-decoding, and same-table concurrency features.
  • 2024: Versions 0.15–0.17 focused on reliability, SQLite-backed internal catalogs, and migration controls.

Related projects

  • pgcopydb orchestrates PostgreSQL facilities including pg_dump, pg_restore, COPY, exported snapshots, logical decoding, test_decoding, and wal2json. It includes special migration handling for extensions such as TimescaleDB and Citus.

Sources

  • Official documentation: https://pgcopydb.readthedocs.io/en/latest/
  • Official releases: https://github.com/dimitri/pgcopydb/releases
  • Official repository: https://github.com/dimitri/pgcopydb

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

  • broad file, network, media, or database tool signal

Signals

  • text:database,server

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 6 platform targets.
  • Installs with 2 runtime dependencies.
  • Build metadata lists 1 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

CommandKindExposureNote
pgcopydbcliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-09-19
manager version0.18
manager updated2026-09-13
local dataok
upstreamcurrent
latest detectedv0.18

https://github.com/dimitri/pgcopydb

  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:pgcopydb
Version0.18
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/pgcopydb
Homepagehttps://github.com/dimitri/pgcopydb
Repositoryhttps://github.com/dimitri/pgcopydb
LicensePostgreSQL
Source archivehttps://github.com/dimitri/pgcopydb/archive/refs/tags/v0.18.tar.gz
Last updated2026-09-13T11:25:59Z
Pulseupdated
Dependenciesbdw-gc, libpq
Build dependenciessphinx-doc
Bottleavailable (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared
CaveatsPgcopydb searches for PostgreSQL command-line tools in your system's PATH environment variable. To use a specific PostgreSQL version's command-line tools, ensure they are accessible in your PATH. When no PostgreSQL tools are found in PATH, pgcopydb defaults to using the command-line tools provided by the libpq formula.

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepgcopydb
Version Scheme0
Revision0
Head VersionHEAD
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • head
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

pgcopydb 0.17-1

Copy an entire PostgreSQL database from source to target

https://github.com/dimitri/pgcopydb

sudo apt install pgcopydb
  • Section: database
  • Architecture: amd64
  • 4 dependencies
  • normalized package name match
  • Matched by: Pgcopydb
Debian stable package indexes · deb.debian.org · Debian stable package indexes: pgcopydb from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Nix95%

pgcopydb

nix profile install nixpkgs#pgcopydb
  • normalized package name match
  • Matched by: Pgcopydb
nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/pg/pgcopydb/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
Ubuntu apt95%

pgcopydb 0.15-1

Copy an entire PostgreSQL database from source to target

https://github.com/dimitri/pgcopydb

sudo apt install pgcopydb
  • Section: universe/database
  • Architecture: amd64
  • 4 dependencies
  • normalized package name match
  • Matched by: Pgcopydb
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: pgcopydb from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

Related tools

  • libpqRuntime dependency declared by Homebrew.
  • sphinx-docBuild dependency declared by Homebrew.

Same workflow

  • dbmateShares pkgdb curated category or tags: cli, database, developer-tools, migration, postgresql.
  • pgcliShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgbouncerShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pg_partmanShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgbadgerShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pg-schema-diffShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment
  • pkg.so package database
  • pkgdb category and tag curation