pkg.soopen package index

brew / 排名 6388

使用 Homebrew, apt, Nix 安装 pgcopydb

查看 pgcopydb 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。

安装命令安全说明

安装

其他安装命令

macOS

Homebrew已验证 · 100%
brew install pgcopydb

local Homebrew formula metadata

Linux

Debian apt已验证 · 92%
sudo apt install pgcopydb

Debian stable package indexes · pgcopydb · 来源: deb.debian.org

Nix已验证 · 92%
nix profile install nixpkgs#pgcopydb

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

概览

软件包摘要

Copy a Postgres database to a target Postgres server

命令和别名

  • pgcopydb

历史

项目历史与用法

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.

项目历史

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.

采用历史

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

使用方式

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.

为什么软件包爱好者会关心

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.

时间线

  • 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.

来源

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

安全态势

风险级别：blue

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

风险分类器

blue 风险 · 中 置信度 · tool

原因

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

信号

  • text:database,server

安装行为

  • formula 元数据中未记录 Homebrew post-install 钩子。
  • Homebrew bottle 元数据适用于 6 个平台目标。
  • 安装时包含 2 个运行时依赖。
  • 构建元数据列出 1 个构建依赖。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

可执行文件

已安装的可执行文件

命令类型暴露范围备注
pgcopydbcli全局可执行文件

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-09-19
管理器版本0.18
管理器更新时间2026-09-13
本地数据OK
上游当前
检测到的最新版本v0.18

https://github.com/dimitri/pgcopydb

  • OK没有生成新鲜度警告。

安装元数据

软件包元数据

软件包键brew:pgcopydb
版本0.18
软件包管理器Homebrew
软件包管理器页面https://formulae.brew.sh/formula/pgcopydb
主页https://github.com/dimitri/pgcopydb
仓库https://github.com/dimitri/pgcopydb
许可证PostgreSQL
源码归档https://github.com/dimitri/pgcopydb/archive/refs/tags/v0.18.tar.gz
最后更新2026-09-13T11:25:59Z
Pulseupdated
依赖bdw-gc, libpq
构建依赖sphinx-doc
Bottle可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install未定义
服务未声明
注意事项Pgcopydb 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.

注册表事实

源数据库详情

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

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

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 依赖
  • normalized package name match
  • 匹配方式：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
  • 匹配方式：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 依赖
  • normalized package name match
  • 匹配方式：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

软件包图谱

链接来自本地软件包关系图、补充数据、依赖边、生态匹配和软件包 hub 归属。

相关工具

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

相同工作流

  • 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.

来源线索

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

使用的来源

  • 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