macOS
Homebrew已验证 · 100%
brew install pgslicelocal Homebrew formula metadata
安装
其他安装命令
概览
软件包摘要
Postgres partitioning as easy as pie
历史
项目历史与用法
pgslice is a PostgreSQL partition-management CLI designed to convert new or populated tables to range partitioning with minimal application changes and downtime.
项目历史
Andrew Kane's pgslice first shipped in April 2016 as a Ruby command-line tool for partitioning PostgreSQL tables with minimal downtime.
The project added PostgreSQL declarative partitioning and foreign-key support in 2017, then continued tracking PostgreSQL and Ruby compatibility, including generated columns and newer PostgreSQL releases.
采用历史
The official project describes pgslice as battle-tested at Instacart.
Distribution expanded beyond RubyGems to include Homebrew and Docker, making the command available through several packaging cultures.
使用方式
Operators set the `PGSLICE_URL` environment variable, prepare an intermediate partitioned table, create partitions, fill it in batches, analyze it, swap it with the original table, and then capture any remaining rows.
The CLI prints executed SQL and supports `--dry-run`; rolling partition creation and archival can keep database size under control.
为什么软件包爱好者会关心
pgslice packages a careful, multi-stage PostgreSQL partition migration into a repeatable CLI while still printing the SQL it executes and offering dry-run and lock-safety controls.
It is useful to database operators who want declarative partitioning or rolling archival without installing a PostgreSQL server extension.
时间线
- 2016-04-24: Version 0.1.0, the first release.
- 2017-10-07: Version 0.4.0 added declarative partitioning and foreign-key support.
- 2023-04-22: Version 0.6.0 added generated-column support and updated runtime requirements.
- 2026-01-05: Version 0.7.2 added Ruby 4.0 support.
Related projects
- pgsync is recommended by the project for transferring data between databases.
- pg_dump and psql are used in the documented retirement and backup workflow.
来源
安全态势
风险级别：绿色
narrow executable package without higher-risk signals.
风险分类器
绿色 风险 · 低 置信度 · appliance
原因
- narrow executable package without higher-risk signals
信号
- metadata:no-higher-risk-signals
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 6 个平台目标。
- 安装时包含 2 个运行时依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
pgslice | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-09-19
管理器版本0.7.2
管理器更新时间2026-09-13
本地数据OK
上游当前
检测到的最新版本v0.7.2
https://github.com/ankane/pgslice
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:pgslice |
|---|---|
| 版本 | 0.7.2 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/pgslice |
| 主页 | https://github.com/ankane/pgslice |
| 仓库 | https://github.com/ankane/pgslice |
| 许可证 | MIT |
| 源码归档 | https://github.com/ankane/pgslice/archive/refs/tags/v0.7.2.tar.gz |
| 最后更新 | 2026-09-13T11:36:57Z |
| Pulse | updated |
| 依赖 | libpq, ruby |
| 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 | pgslice |
| 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