macOS
Homebrew已验证 · 100%
brew install pgtoolkitlocal Homebrew formula metadata
安装
其他安装命令
概览
软件包摘要
Tools for PostgreSQL maintenance
历史
项目历史与用法
PgToolkit is a Perl-based PostgreSQL maintenance toolkit whose principal utility, pgcompact, reduces table and index bloat with limited locking and incremental operation.
项目历史
PgToolkit was created as a collection of PostgreSQL maintenance utilities, although its documented package currently centers on pgcompact.
The authors describe pgcompact as an automation of established community techniques for reducing PostgreSQL bloat without prolonged exclusive locking. The repository copyright record covers 2011–2014 and names Sergey Konoplev and Maxim Boguk.
采用历史
PgToolkit was designed for lightweight deployment: its autonomous fatpack scripts require only Perl and can be copied directly to a server, while non-autonomous scripts can use DBD::Pg, DBD::PgPP, or psql.
The project credits testing and operational input from PostgreSQL-Consulting.com and several PostgreSQL community contributors.
使用方式
Administrators use `pgcompact` to analyze and compact selected tables, databases, or an entire cluster, optionally reindexing bloated indexes and excluding specified schemas or objects.
The tool supports incremental and parallel runs, load-aware throttling, and portable fatpack scripts. Installing pgstattuple is recommended for more accurate bloat estimates.
为什么软件包爱好者会关心
PgToolkit reflects the sysadmin tradition of portable database-maintenance scripts: pgcompact can be deployed without a large runtime stack and adapts to whichever PostgreSQL client interface is available.
pgcompact is notable for addressing table and index bloat incrementally, avoiding heavy locks and full-table rebuilding while adjusting its behavior to database load.
时间线
- 2011–2014: Copyright period recorded in the official project README.
- Documented package state: PgToolkit contains pgcompact as its sole current tool, with additional tools planned.
Related projects
- PostgreSQL's pgstattuple extension is recommended for more precise table and index bloat estimates.
- PgCookbook is listed by the project as a related PostgreSQL documentation project.
- DBD::Pg, DBD::PgPP, and psql are alternative database access backends used by pgcompact.
来源
安全态势
风险级别：blue
broad file, network, media, or database tool signal.
风险分类器
blue 风险 · 中 置信度 · tool
原因
- broad file, network, media, or database tool signal
信号
- text:sql
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 1 个平台目标。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
pgcompact | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-09-19
管理器版本1.0.2
管理器更新时间
本地数据OK
上游当前
检测到的最新版本v1.0.2
https://github.com/grayhemp/pgtoolkit
- 信息No package-manager update timestamp was available.低 置信度
安装元数据
软件包元数据
| 软件包键 | brew:pgtoolkit |
|---|---|
| 版本 | 1.0.2 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/pgtoolkit |
| 主页 | https://github.com/grayhemp/pgtoolkit |
| 仓库 | https://github.com/grayhemp/pgtoolkit |
| 许可证 | PostgreSQL |
| 源码归档 | https://github.com/grayhemp/pgtoolkit/archive/refs/tags/v1.0.2.tar.gz |
| Bottle | 可用 (于 all) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
注册表事实
源数据库详情
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | pgtoolkit |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- Geiger risk classifier
- cross-ecosystem install command graph
- curated package history
- package relationship graph
- package version freshness
- package-page enrichment
- pkg.so package database
- pkgdb category and tag curation