macOS
Homebrew已验证 · 100%
brew install pg_partmanlocal Homebrew formula metadata
安装
其他安装命令
Linux
Debian apt已验证 · 92%
sudo apt install postgresql-17-partmanDebian stable package indexes · postgresql-17-partman · 来源: deb.debian.org
Fedora dnf已验证 · 92%
sudo dnf install pg_partmanFedora Rawhide package metadata · pg_partman · 来源: dl.fedoraproject.org
Ubuntu apt已验证 · 92%
sudo apt install postgresql-16-partmanUbuntu 24.04 LTS package indexes · postgresql-16-partman · 来源: archive.ubuntu.com
概览
软件包摘要
Partition management extension for PostgreSQL
历史
项目历史与用法
pg_partman is a PostgreSQL extension that creates and maintains time- or number-based partition sets, including future partition creation, retention, migration, and background maintenance.
项目历史
pg_partman began as a PostgreSQL extension for managing time- and number-based partition sets, including the trigger-based techniques required by older PostgreSQL releases. As PostgreSQL's declarative partitioning matured, pg_partman added support for the core implementation and migration tooling.
The 5.x series completed a major architectural transition: version 5.0.1 dropped trigger-based partitioning, required PostgreSQL 14 or newer, and standardized on built-in declarative partitioning. Later 5.x releases expanded supported partitioning forms and maintenance capabilities.
采用历史
pg_partman is distributed not only from source but through community-maintained PostgreSQL operating-system packages. Its usefulness grew as PostgreSQL installations needed repeatable automation for creating future partitions, applying retention, and maintaining large time-series or sequence-based tables.
使用方式
Administrators create the extension in a chosen database schema, register existing declaratively partitioned parent tables, and configure policies in pg_partman's database configuration tables. Maintenance can be invoked by a scheduler or automated with the bundled background worker; retention, premaking, migration, and monitoring features support production partition lifecycles.
为什么软件包爱好者会关心
The extension packages a substantial amount of PostgreSQL partitioning operational knowledge into database objects and an optional background worker. Package maintainers must track both PostgreSQL-version compatibility and major pg_partman migrations, particularly the transition away from trigger-based partitioning.
时间线
- Pre-5.0: pg_partman supported older trigger-based partitioning alongside PostgreSQL declarative partitioning.
- 2023: The 4.7 series added compatibility with PostgreSQL 16.
- 2024: Version 5.0.1 removed trigger-based partitioning and required PostgreSQL 14 or newer.
- 2025: The 5.x documentation described list partitioning and experimental numeric partitioning support.
Related projects
- PostgreSQL
- pg_jobmon
- pgTAP
来源
安全态势
风险级别：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 元数据适用于 6 个平台目标。
- 构建元数据列出 2 个构建依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
check_unique_constraint.py | cli | 全局可执行文件 | |
dump_partition.py | cli | 全局可执行文件 | |
vacuum_maintenance.py | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-09-19
管理器版本5.5.0
管理器更新时间2026-09-15
本地数据OK
上游当前
检测到的最新版本v5.5.0
https://github.com/pgpartman/pg_partman
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:pg_partman |
|---|---|
| 版本 | 5.5.0 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/pg_partman |
| 主页 | https://github.com/pgpartman/pg_partman |
| 仓库 | https://github.com/pgpartman/pg_partman |
| 许可证 | PostgreSQL |
| 源码归档 | https://github.com/pgpartman/pg_partman/archive/refs/tags/v5.5.0.tar.gz |
| 最后更新 | 2026-09-15T01:40:46Z |
| Pulse | updated |
| 构建依赖 | postgresql@17, postgresql@18 |
| Bottle | 可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
注册表事实
源数据库详情
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | pg_partman |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Debian apt95%
postgresql-17-partman 5.2.4-1
PostgreSQL Partition Manager
https://github.com/pgpartman/pg_partman
sudo apt install postgresql-17-partman- Section: database
- Architecture: amd64
- Source Package: pg-partman
- 5 依赖
- normalized package name match
- 匹配方式：Pg Partman
Ubuntu apt95%
postgresql-16-partman 5.0.1-1
PostgreSQL Partition Manager
https://github.com/pgpartman/pg_partman
sudo apt install postgresql-16-partman- Section: universe/database
- Architecture: amd64
- Source Package: pg-partman
- 5 依赖
- normalized package name match
- 匹配方式：Pg Partman
dnf95%
pg_partman 5.4.3-3.fc45
PostgresSQL Partition Manager
https://github.com/pgpartman/pg_partman
sudo dnf install pg_partman- License: PostgreSQL
- Category: Unspecified
- Architecture: x86_64
- Source Package: postgresql18-pg_partman
- 4 依赖
- 4 提供
- normalized package name match
- 匹配方式：Pg Partman
来源线索
由仓库数据生成
此页面由 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
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment
- pkg.so package database
- pkgdb category and tag curation