# Pigsty v4.6：625 扩展、VAULT 密钥管理、MySQL 8.4 重构与 PG 18.7

LLMS 索引： [llms.txt](/llms.txt)

---

Pigsty **v4.6.0** 正式发布！这是一个横跨密钥安全基础设施、关系型数据库编排、PostgreSQL 内核与扩展生态以及供应链工具链的功能版本：新增基于 OpenBao 2.7.2 的 **VAULT** 密钥管理模块，全面重构 **MYSQL 8.4** 模块，将默认 PostgreSQL 升级至 **18.7** 并刷新全部主要分支内核，把已打包 PostgreSQL 扩展推进到 **625** 个，同时完成 `pig v1.11.0`、`pg_exporter v1.6.1`、`sow v0.7.1` 与基础设施软件包的系统性升级。

本次版本覆盖 `v4.5.0`（`dab5dba3`，2026-08-14）至 `v4.6.0`（`d71d9de8`，2026-11-12）共 **139 个提交、441 个文件变更、21,701 行新增与 5,026 行删除**。标签间源码差异见 [`v4.5.0...v4.6.0`](https://github.com/pgsty/pigsty/compare/v4.5.0...v4.6.0)。

## 版本亮点

- **625 个已打包 PostgreSQL 扩展**：较 v4.5.0（575 项）新增 52 项、移除 2 项，净增 50 项；现有 **625** 个已打包扩展、**457** 个非 contrib 独立包族，在线目录收录 **2740** 项，大批 Rust 扩展升级至 `pgrx 0.19.3`。
- **VAULT 密钥管理模块**：新增基于 OpenBao 2.7.2（MPL-2.0）的 [VAULT 模块](/docs/vault/)，采用“拓扑即模式”内置 Raft 共识，开箱提供 static seal 自动解封、TLS 1.3、VIP/HAProxy 高可用入口、每日 Raft 快照与完整监控告警。
- **MySQL 8.4 模块重构**：将 [MYSQL 模块](/docs/mysql/) 收敛为精炼的 16 项公开参数与 `/data/mysql` 目录模型，补齐全集群停机恢复（`rebootClusterFromCompleteOutage`）、InnoDB Clone 副本重建以及 70 条记录规则与 8 条告警规则。
- **PostgreSQL 18.7 与分支内核升级**：默认版本更新到 **PostgreSQL 18.7**，同步升级 IvorySQL 5.6、Babelfish 6.2.0 / 5.7.0、Percona `pg_tde` 18.6.1、OrioleDB 1.10.3、AgensGraph 2.18.6.1、pgEdge `3PGSTY`（Spock 5.0.13）、PolarDB 17.11.1.0、Cloudberry 2.2.0 与 DocumentDB 1.0。
- **KAFKA、JUICE 与 VIBE 加固**：Kafka 支持可选关闭内嵌 JMX Agent 并在停服前优雅退役动态 Controller 投票节点；JuiceFS 增加严格挂载校验；VIBE 改为原生系统包安装 `claude-code` / `codex` 并使用 `uv venv` 隔离 JupyterLab。
- **核心组件与监控矩阵刷新**：`pig` 升级至 **v1.11.0**，`pg_exporter` 升级至 **v1.6.1**，`sow` 升级至 **v0.7.1**，Silo 升级至 `20261112`（含 `silo-console 2.7.2`）；Grafana 仪表盘增至 **68** 套，VictoriaMetrics 记录规则增至 **775** 条（含动态模板共 790 条），告警规则 **79** 条。
- **模板归位与工程改进**：10 套内核分支模板统一移入 `conf/fork/*`（`conf/mysql.yml` 改为 `conf/fork/halo.yml`），独立模板增至 **53** 套；`terraform/` 默认切换至 OpenTofu（`tofu`），离线包路径统一至 `/var/tmp/pkg.tgz`，`docker` 与 `nginx` 拆分为独立上游仓库模块。

## VAULT 密钥管理模块（Beta）

新的 [VAULT 模块](/docs/vault/) 在固定分组 `vault` 上部署 Linux 基金会托管的开源密钥与机密管理系统 [OpenBao](https://openbao.org/)（`2.7.2`，MPL-2.0），作为整套部署统一的 KMS 与机密存储底座：

- **极简拓扑与参数**：仅公开 [8 项参数](/docs/vault/param/)（5 项部署参数 + 3 项移除参数）；1 个成员即为实验模式，3 个成员即为生产 Raft 高可用模式，无需依赖 ETCD 或 PostgreSQL。
- **信任根收纳与自动解封**：采用 static seal，32 字节解封密钥、root token 与恢复材料统一保存在管理节点 `files/pki/vault/` 下，与 CA 私钥遵循同一信任根备份边界；节点重启后自动解封。
- **全链路 TLS 1.3 与高可用入口**：由 Pigsty CA 签发服务端证书（最低 TLS 1.3），OpenBao 仅绑定节点 IP 与回环地址，将 `<VIP>:8200` 留给 HAProxy 做 TLS 透传并路由至当前 active 成员；客户端统一访问 `https://vault.pigsty:8200`。
- **开箱即用与每日快照**：默认挂载 `secret/`（KV v2）、`transit/`（加密即服务）并启用 `approle` 认证；`/usr/local/bin/vault-backup` 使用 `flock` 互斥锁每日从主节点拉取快照并在本地保留 7 份，集群首次初始化后及整集群移除前还会自动将快照回收至管理节点。
- **监控与安全护栏**：`vault_safeguard` 默认开启（`true`）；配套 14 条记录规则、6 条告警规则以及全新的 `Vault Overview` Grafana 仪表盘。

## MySQL 8.4 模块重构

在 v4.5 初代试点的基础上，v4.6 对 [MYSQL 模块](/docs/mysql/) 进行了系统性重构与瘦身，明确平台契约与故障恢复闭环：

- **收敛为 16 项公开参数**：精简为 13 项部署参数与 3 项受保护移除参数，移除并由预检显式拦截 `mysql_backup_repo` 等旧变量；`./configure -g` 会自动生成随机的 `mysql_root_password`、`mysql_monitor_password` 与 `mysql_cluster_password`。
- **固定平台约定与自动推导**：数据目录统一为 `/data/mysql`（含 `binlog/` 与 `tmp/`），本地物理备份默认位于 `/data/backups/mysql`（保留 3 份）；内存基线根据节点规格及是否与 PostgreSQL 混部自动计算，`server_id` 由成员 IPv4 地址自动推导。
- **高可用自愈与 Clone 重建**：支持全集群停机后的仲裁恢复（`dba.rebootClusterFromCompleteOutage()`），以及通过 InnoDB Clone 与 `cluster.rescan()` 重建落后或损坏的成员；`mysql_safeguard` 默认开启（`true`）。
- **可观测性扩充**：对齐 `mysqld-exporter 0.21.0` 指标类型变更，监控规则扩充至 **70 条记录规则** 与 **8 条告警规则**（包含基于 `mysql_backup_last_run_timestamp_seconds` 的 `MySQLBackupStale` 告警）。

## KAFKA、JUICE 与 VIBE 演进

- **KAFKA**：新增 [`kafka_jmx_exporter_enabled`](/docs/kafka/param/#kafka_jmx_exporter_enabled)（默认 `true`），允许关闭内嵌 Java Agent 及对应抓取，同时保留独立的协议级 `kafka-exporter`；`kafka-rm.yml` 调整退役顺序，在停服前先将动态 KRaft Controller 投票节点移出仲裁组，并清理残留 Exporter 单元与监控目标；Apache Kafka 升级至 `4.4.0`。
- **JUICE**：JuiceFS 服务单元在启动与重启阶段结合 systemd `Result=success` 与 `findmnt` 挂载核验，杜绝“进程存活但挂载未就绪”的假阳性状态；`juicefs` 升级至 `1.4.2`。
- **VIBE**：移除对 `npm install -g` 在线全局安装的依赖，直接从 Pigsty Infra 仓库安装官方签名原生包 `claude-code`（`2.1.322`）与 `codex`（`0.167.2`），并收录 `pi-coding-agent`（`1.5.2`）、`opencode`（`1.19.5`）、`crush`（`0.100.0`）与 `mcp-toolbox`（`1.16.0`）；JupyterLab 运行环境切换为 `uv venv` 管理的 `/data/jupyter/.venv`；Node.js 升级至 `26.13.1` LTS。

## PostgreSQL 18.7、分支内核与 625 个扩展

### 内核与 PGSQL 角色更新

- 默认生产版本升级至 **PostgreSQL 18.7**（PG 17.11 / 16.15 / 15.19 / 14.22 同步常规维护基线）。
- 各大内核分支全面刷新：**IvorySQL 5.6**（PG 18.6，并在 Infra 仓库提供 `ivorysql` 原包配方）、**Babelfish 6.2.0 / 5.7.0**（PG 18.6 / 17.11）、**Percona `pg_tde` 18.6**（Percona Server 18.6.1，`pg_tde 2.2.2`）、**OrioleDB 1.10.3**（PG 16–18）、**AgensGraph 2.18.6.1**（PG 18.6）、**pgEdge 15–18 `3PGSTY`**（含 Spock `5.0.13`、LOLOR `1.2.3`）、**PolarDB 17.11.1.0 `2PGSTY`**、**Cloudberry 2.2.0**（含备份与 PXF 套件）以及 **DocumentDB 1.0**。
- PGSQL 角色新增第 125 项参数 [`pg_pitr`](/docs/pgsql/param/#pg_pitr)，用于声明式渲染 `pg-pitr` 配置；服务端 TLS 证书自动把 `pg_vip_address` 写入 SAN；`crit.yml` 在首次单节点引导期使用 `synchronous_commit: local` 防止单主阻塞；HAProxy 健康检查修正 `pg_rto` 时长格式转换；补齐多款分支内核与 `pgbackrest` 的兼容配置。

### 625 个已打包扩展

以 `pig v1.11.0`（625 项）对比 v4.5.0 基线 `pig v1.7.0`（575 项），本周期共新增 **52** 项、移除 **2** 项，净增 **50** 项，独立非 contrib 扩展包族达到 **457** 个：

- **新增 49 个主扩展与工具包**：`acdat`、`addressing_dictionary`、`codesystem`、`colnames`、`edtf_postgres`、`encsearch`、`hdr_histogram`、`is_jsonb_valid`、`istore`、`jev`、`kafgres`、`libx509pq`、`macavity`、`oai_fdw`、`opencc`、`pg_agent_gate`、`pg_circuit`、`pg_grammar_guard`、`pg_icu_parser`、`pg_improv`、`pg_integrity_checksums`、`pg_json_diff`、`pg_kv`、`pg_lease`、`pg_lexo`、`pg_lion`、`pg_living_assertions`、`pg_money`、`pg_nanotime`、`pg_relation_sql`、`pg_rusage`、`pg_stat_tcpinfo`、`pg_statecharts`、`pg_statkit`、`pg_statvfs`、`pg_synonym`、`pg_table_range`、`pg_tre`、`pg_try_cast`、`pg_vectorsearch`、`pg_warren`、`pgexporter_ext`、`pgs3`、`pgtelemetry`、`plphp`、`stannum`、`textsearch_intl`、`tin`、`vgram`。
- **新增 3 个子扩展**：`pg_lion_citext`、`pg_lion_vector`、`pg_statecharts_dev`。
- **移除 2 个子扩展**：`documentdb_distributed`（随 DocumentDB 1.0 上游移除）与 `pgcontext_pgvector`。

### PostgreSQL 内核与扩展软件包更新表

| 包名 / Package | 旧版本 / Previous | 新版本 / Current | 说明 / Notes |
|:---|:---|:---|:---|
| `postgresql-18` | `18.6` | `18.7` | 默认生产大版本小版本更新；PG 14–17 同步常规维护基线<br>Default production baseline: PostgreSQL 18.7; other supported majors follow their own maintenance branches. |
| `acdat` | `0.1.1` | `0.1.1` | PG14-18；已有扩展首次正式全量入库；80 主包<br>PG14-18; First full production packaging of an existing extension; 80 main packages |
| `address_standardizer` | - | RPM: 3.7.0-1PGSTY / DEB: 3.7.0 | EL8 补包；独立包；SQL 3.7；含 data_us；不依赖 PostGIS<br>EL8 gap fill; standalone; SQL 3.7; includes data_us; no PostGIS dependency |
| `addressing_dictionary` | - | `1.1` | PG14-18；纯 SQL<br>PG14-18; SQL-only |
| `age` | `1.7.0` | RPM: `1.8.0` / DEB: `1.8.0~rc0` | PG18 离线快照；旧 PG 大版本按对应发布线选择<br>PG18 snapshot: RPM 1.8.0 and PGDG DEB 1.8.0~rc0; older PG majors retain their release branches. |
| `agensgraph-18` | - | `2.18.6.1` | PG18.6 内核与配套扩展<br>PG18.6 kernel and contrib |
| `arrow` | `22.0.0` | RPM: 25.0.1 / DEB: 24.0.0 / 25.0.1 | 含 compute/devel；ABI 2500<br>Runtime, compute and development libraries; versions vary by distribution and ABI. |
| `babelfish-17` | `5.4.0` | `5.7.0` | PG17.11；含四个配套扩展<br>PG17.11; includes all four companion extensions |
| `babelfish-18` | `6.0.0` | `6.2.0` | PG18.6；含四个配套扩展<br>PG18.6; includes all four companion extensions |
| `biscuit` | `3.0.0` | `3.1.0` | PG16-18<br>PG16-18 |
| `cat_tools` | `0.3.0` | `0.4.0` | 纯 SQL<br>SQL-only |
| `citus` | `14.2.0` | `14.3.0` | PG16-18；含 citus_columnar<br>PG16-18; includes citus_columnar |
| `cloudberry` | `2.1.0` | `2.2.0` | 内核与配套扩展<br>Kernel and contrib |
| `cloudberry-backup` | `2.1.0` | `2.2.0` | 六个备份恢复工具<br>Six backup/restore tools |
| `cloudberry-pxf` | `2.1.0` | `2.2.0` | 配套 Cloudberry 2.2.0；含 pxf/pxf_fdw<br>For Cloudberry 2.2.0; includes pxf/pxf_fdw |
| `codesystem` | - | RPM only: 0.2.1 | PG14-18；SQL 版本 0.2.0<br>PG14-18; SQL version 0.2.0 |
| `colnames` | - | `1.7.1` | PG14-18；SQL 1.7.0<br>PG14-18; SQL 1.7.0 |
| `credcheck` | RPM only: 4.7 | `6.0` | PG18 离线包采用 PGDG；EL8 提供 Pigsty 补包<br>PGDG packages in the PG18 snapshot; Pigsty fills EL8 gaps. |
| `ddlx` | `0.30` | `0.31` | PG14-18；纯 SQL<br>PG14-18; SQL-only |
| `documentdb` | `0.114` | RPM: 1.0-2PGSTY / DEB: 1.0 | PG15-18；PostGIS 3.7<br>PG15-18; PostGIS 3.7 |
| `duckdb_fdw` | `1.4.3` | `2.0.2` | PG15-18；DuckDB 2.0.0；与 pg_duckdb 互斥<br>PG15-18; DuckDB 2.0.0; conflicts with pg_duckdb |
| `edtf_postgres` | - | `1.3.2` | PG18 离线发布快照；日期时间类型<br>PG18 release snapshot; extended date/time types. |
| `emaj` | `5.0.0` | `5.0.1` | PG14-18；修复 emaj_adm 权限提升与并行回滚问题<br>PG14-18; fixes emaj_adm privilege escalation and parallel rollback |
| `encsearch` | - | RPM only: 0.1.1 | PG17；加密搜索<br>PG17; encrypted search |
| `graphblas` | `10.5.0` | `10.5.2` | 运行库与开发包；ABI 10；不纳入默认分组及本次离线包<br>Runtime and development libraries, ABI 10; excluded from default groups and these offline archives. |
| `groonga` | RPM: 15.1.8 / DEB: 15.1.7 / 15.1.9 / 16.0.0 | RPM: 16.1.5 / DEB: 16.0.5 / 16.1.3 | EL8/9/10；x86_64/aarch64；含 libs/devel<br>RPM 16.1.5; DEB runtime versions differ by distribution. |
| `groonga-tokenizer-mecab` | RPM: 15.1.8 / DEB: 15.1.7 / 15.1.9 / 16.0.0 | RPM: 16.1.5 / DEB: 16.0.5 / 16.1.3 | EL8/9/10；x86_64/aarch64；MeCab 分词器<br>MeCab tokenizer; versions follow the matching Groonga packages. |
| `haproxy` | `3.4.4` | `3.4.7` | 含文档子包<br>RPM includes the haproxy-doc subpackage |
| `hdr_histogram` | - | `1.0.0` | PG14-18；SQL 版本 1.0<br>PG14-18; SQL version 1.0 |
| `hypopg` | 1.4.4 | 1.4.5 | PGDG 软件包<br>PGDG packages |
| `is_jsonb_valid` | - | `0.1.4` | PG14-18<br>PG14-18 |
| `istore` | - | `0.1.12` | PG14-18<br>PG14-18 |
| `ivorysql-18` | `5.4` | `5.6` | PG18.6 内核<br>PG18.6 kernel |
| `ivorysql-contrib` | `5.4` | `5.6` | PG18（IvorySQL）；含 38 个扩展<br>PG18 (IvorySQL); includes 38 extensions |
| `jev` | - | `0.2.1` | PG14-17<br>PG14-17 |
| `jsonschema` | `0.1.9` | `0.1.11` | PG14-18；pgrx 0.19.3<br>PG14-18; pgrx 0.19.3 |
| `kafgres` | - | `0.3.2` | PG16<br>PG16 |
| `lagraph` | `1.2.2` | `1.2.2` | 使用 GraphBLAS 10.5.2 重建；不纳入本次离线包<br>Rebuilt against GraphBLAS 10.5.2; excluded from these offline archives. |
| `lead` | - | `1.0.6` | PG17-18；扩展名 tin；开发快照<br>PG17-18; extension tin; development snapshot |
| `libx509pq` | - | `1.3` | PG14-18<br>PG14-18 |
| `log_fdw` | `1.4` | `1.5` | PG14-18<br>PG14-18 |
| `login_hook` | `1.8` | `1.9` | PG14-17 PGDG；PG18 Pigsty<br>PG14-17 PGDG; PG18 Pigsty |
| `lolor` | `1.2.2` | `1.2.3` | 随 pgEdge 15-18 更新<br>Updated with pgEdge 15-18 |
| `macavity` | - | `0.2.0` | PG16-18；故障注入；仅限测试<br>PG16-18; Fault injection; testing only |
| `mobilitydb` | `1.3.0` | RPM: 1.3.1-2PGSTY / DEB: 1.3.1 | PG14-18；PostGIS 3.7<br>PG14-18; PostGIS 3.7 |
| `nominatim_fdw` | `2.1.0` | `2.3` | PG14-18；RPM 主供 PGDG；同版本 Pigsty 补位包并存<br>PG14-18; PGDG is the principal RPM provider; same-version Pigsty supplements remain |
| `oai_fdw` | - | `1.16.0` | PG14-18；OAI-PMH FDW；SQL 1.16<br>PG14-18; OAI-PMH FDW; SQL 1.16 |
| `onesparse` | `1.0.0-1PGSTY` | `1.0.0-2PGSTY` | PG18；随 GraphBLAS/LAGraph 重建；需预加载；已从默认分组隐藏<br>PG18; rebuilt with GraphBLAS/LAGraph; preload required; hidden from default groups. |
| `opencc` | - | `0.1.0` | PG14-18；繁简中文转换<br>PG14–18; conversion between simplified and traditional Chinese. |
| `orioledb-16` | `1.8-beta16` | `1.10.3` | PG16.15 内核；SQL 1.10<br>PG16.15 kernel; SQL 1.10 |
| `orioledb-17` | `1.8-beta16` | `1.10.3` | PG17.11 内核；SQL 1.10<br>PG17.11 kernel; SQL 1.10 |
| `orioledb-18` | `1.8-beta16` | `1.10.3` | PG18.6 内核；SQL 1.10<br>PG18.6 kernel; SQL 1.10 |
| `passwordcheck_cracklib` | `3.2.0` | `3.2.1` | PG14-18<br>PG14-18 |
| `passwordpolicy` | 2.0.5 | 2.0.6 | PGDG 软件包<br>PGDG packages |
| `pg_adhoc` | RPM only: 17.4 | RPM only: 19.0 | 含 pg_filedump<br>Includes pg_filedump |
| `pg_agent_gate` | - | `0.4.1` | PG18；修复代理角色逃逸；需预加载<br>PG18; fixes agent-role escape; preload required |
| `pg_anon` | `3.2.2` | `3.3.2` | PG14-18；pgrx 0.19.3；安全更新；需要删除并重建<br>PG14-18; pgrx 0.19.3; security update; drop/recreate required |
| `pg_background` | `2.0.3` | `2.0.4-2PGSTY` | PG14-18；移除下游升级补丁<br>PG14-18; remove downstream upgrade patch; built, import pending |
| `pg_circuit` | - | `0.1.0` | PG16-18；需预加载<br>PG16-18; preload |
| `pg_clickhouse` | `0.10.0` | `0.11.1` | PG14-18；SQL 0.11<br>PG14-18; SQL 0.11 |
| `pg_curl` | `2.4.5` | `2.5.0` | PG14-18；SQL 2.5<br>PG14-18; SQL 2.5 |
| `pg_currency` | 0.0.4 | 0.0.6 | PG14-18；扩展名 currency<br>PG14-18; extension currency |
| `pg_duckdb` | `1.1.1` | `1.2.0` | DuckDB 2.0.0；与 duckdb_fdw 冲突<br>DuckDB 2.0.0; conflicts with duckdb_fdw |
| `pg_durable` | `0.2.3` | `0.2.9` | PG14-18；需预加载<br>PG14-18; preload required; imported locally |
| `pg_eviltransform` | `0.0.5` | `0.0.7` | PG14-18<br>PG14-18 |
| `pg_fts` | `0.2.0` | `1.16.0` | PG17-18；修复 top-k 与删除后性能退化<br>PG17-18; fixes top-k and delete performance |
| `pg_grammar_guard` | - | `0.4.9` | PG14-18；Apache-2.0<br>PG14-18; Apache-2.0; built, import pending |
| `pg_graphql` | `1.6.2` | `1.6.3` | 修复 nodeId 的带引号主键<br>Fixes quoted primary keys in nodeId |
| `pg_h3` | `4.2.3` | `4.5.0` | PG14-18；含 h3_postgis；新增 50 个 DEB；按上游迁移指南升级<br>PG14-18; Includes h3_postgis; adds 50 DEBs; follow upstream migration guidance |
| `pg_hint_plan` | 1.8.0/1.7.1/1.6.2/1.5.3/1.4.4 | 1.8.1/1.7.2/1.6.3/1.5.4/1.4.5 | PGDG 的 PG18/17/16/15/14 发布线<br>PGDG PG18/17/16/15/14 release lines |
| `pg_icu_parser` | - | `1.0.0` | PG14-18；EL8/9/10 x86_64/aarch64；修复 PG18 兼容性<br>PG14-18; EL8/9/10 x86_64/aarch64; PG18 compatibility fix; imported locally |
| `pg_improv` | - | `0.14.0` | PG15-18；pgrx 0.19.3<br>PG15-18; pgrx 0.19.3 |
| `pg_incremental` | `1.5.0` | RPM: `1.5.0` / DEB: `1.6.1` | DEB 升级至 1.6.1；PG18 RPM 保持 1.5.0<br>DEB upgraded to 1.6.1; PG18 RPM remains at 1.5.0. |
| `pg_integrity_checksums` | - | `2.2.0` | PG14-18；SQL 2.2<br>PG14-18; SQL 2.2 |
| `pg_ivm` | `1.15` | `1.17` | PG14-18<br>PG14-18 |
| `pg_json_diff` | - | `1.0` | PG14-18<br>PG14-18 |
| `pg_kv` | - | `0.1.0` | PG15-18；非持久化共享内存 KV<br>PG15-18; non-persistent shared-memory KV |
| `pg_lake` | `3.4.0` | `3.6.0` | PG16-18；八个扩展，SQL 3.6；覆盖 EL9/10 与 Debian/Ubuntu<br>PG16–18; eight extensions, SQL 3.6; EL9/10 and Debian/Ubuntu packages. |
| `pg_lease` | - | RPM only: 0.1.0 | PG14-18；纯 SQL<br>PG14-18; SQL-only |
| `pg_lexo` | - | `0.6.1` | PG16-18；SQL 0.6.0；修复序号生成与排序<br>PG16-18; SQL 0.6.0; fix rank generation and ordering |
| `pg_lion` | - | `0.3.0` | PG14-18；含 pg_lion_citext、pg_lion_vector 子扩展<br>PG16-18; includes citext/vector companions |
| `pg_living_assertions` | - | `0.5.10` | 纯 SQL；全平台重建<br>SQL-only rebuild |
| `pg_local_cache` | `1.3.0` | `3.1.0` | PG14-18；OpenSSL 依赖<br>PG14-18; OpenSSL dependency; built, import pending |
| `pg_mentat` | `1.6.0` | `1.20.0` | PG14-18<br>PG14-18 |
| `pg_money` | - | `0.3.0` | PG14-18<br>PG14-18 |
| `pg_mooncake` | `0.2.0` | `0.3.0-1PGSTY` | PGSTY 分支；适配 pg_duckdb 1.2.0 / DuckDB 2.0.0；缺少 0.2.0 升级脚本<br>PGSTY fork; pg_duckdb 1.2.0 / DuckDB 2.0.0; no 0.2.0 upgrade script |
| `pg_nanotime` | - | `0.3.0` | PG18 离线发布快照；纳秒时间戳<br>PG18 release snapshot; nanosecond timestamps. |
| `pg_parquet` | `0.5.1-3PIGSTY` | `0.5.1-4PGSTY` | 修复流式 COPY 临时文件泄漏<br>Fixes streaming COPY temporary-file leaks |
| `pg_pinyin` | `0.0.6` | `0.0.8` | PG14-18<br>PG14-18 |
| `pg_profile` | `4.11` | `4.16` | PG14-18；恢复缺失 RPM；纯 SQL<br>PG14–18; missing RPM coverage restored; SQL-only. |
| `pg_regresql` | `2.0.0` | `2.1.0` | PG14-18；SQL 版本 2.0<br>PG14-18; SQL version 2.0 |
| `pg_relusage` | `0.0.1` | `1.0.2` | PG14-18；需加载<br>PG14-18; loading required |
| `pg_rusage` | - | `1.0` | PG14-18<br>PG14-18 |
| `pg_search` | `0.25.2` | `0.26.6` | PG15-18；需预加载；MPP JoinScan 已知崩溃风险<br>PG15-18; preload; known MPP JoinScan crash risk |
| `pg_semver` | `0.41.0` | `0.42.0` | PG14-18<br>PG14-18; imported locally |
| `pg_stat_ch` | `0.3.6` | `0.4.0` | PG16-18；PG18 离线包的 RPM/DEB 均为 0.4.0<br>PG16–18; both RPM and DEB use 0.4.0 in the PG18 snapshot. |
| `pg_stat_kcache` | 2.3.1 | 2.3.2 | PGDG 软件包<br>PGDG packages |
| `pg_stat_monitor` | `2.3.2` | `2.4.0` | PG14-18；需预加载<br>PG14-18; preload |
| `pg_stat_tcpinfo` | - | `1.1` | PG14-18；PGDG 主供，Pigsty 补充<br>PG14-18; PGDG primary, Pigsty supplement |
| `pg_statecharts` | - | `0.1.0` | PG14-18；含 pg_statecharts_dev 子扩展<br>PG16-18; includes pg_statecharts_dev |
| `pg_statkit` | - | `1.1.0` | PG14-17<br>PG14-17 |
| `pg_statvfs` | - | `1.0` | PG14-18<br>PG14-18 |
| `pg_statviz` | RPM: 0.9 / 1.2 / DEB: 1.2.1 | `1.2.1` | PG14-18；正式 RPM 从 PGDG 旧版切换至 Pigsty 1.2.1；SQL 版本 1.2；补齐 30 个 RPM<br>PG14-18; Production RPMs switch from older PGDG builds to Pigsty 1.2.1; SQL version 1.2; fills 30 RPM coordinates |
| `pg_synonym` | - | `1.0.0` | PG15-18；SQL 版本 1.0<br>PG15-18; SQL version 1.0 |
| `pg_table_range` | - | RPM only: 0.1.2 | PG16-18；范围剪枝<br>PG16-18; range pruning |
| `pg_task` | `2.1.29` | `3.0.0` | PG14-18；需预加载<br>PG14-18; preload |
| `pg_textsearch` | `1.4.0` | `1.5.1` | PG17-18；RPM 采用 PGDG；DEB 由 Pigsty 提供<br>PG17-18; RPMs from PGDG; DEBs from Pigsty |
| `pg_tle` | `1.5.2` | RPM: `1.5.2` / DEB: `1.5.3` | PG18 离线快照保留平台版本差异<br>The PG18 snapshot retains different RPM and DEB versions. |
| `pg_tokenizer` | `0.1.1` | `1.1.0` | PG14-18；原生 tsvector<br>PG14-18; native tsvector |
| `pg_tre` | - | `4.6.2` | PG17-18<br>PG17-18 |
| `pg_trickle` | `0.81.0` | `0.108.3` | PG18；pgrx 0.19.3<br>PG18; pgrx 0.19.3; built, import pending |
| `pg_try_cast` | - | `1.0.0` | PG16-18；SQL 版本 1.0<br>PG16-18; SQL version 1.0 |
| `pg_turbovec` | `2.2.2` | `2.15.0` | PG14-18<br>PG14-18 |
| `pg_utl_smtp` | DEB only: 1.0.0 | DEB only: 2.0.0 | PG14-18；IO::Socket::SSL 依赖<br>PGDG covers EL8/9/10 |
| `pg_vault_tde` | `1.7.0` | `1.7.2` | PG17-18；EL9/10<br>PG17-18; EL9/10 |
| `pg_vectorsearch` | - | `0.1.0` | PG18；Alpha<br>PG18; alpha; imported locally |
| `pg_warren` | - | `0.8.0` | PG14-18；新增扩展<br>PG15-18 |
| `pgaudit` | RPM only: 1.6.3 / 1.7.1 | RPM only: 1.6.3-1PGSTY / 1.7.1-1PGSTY | PG14/15；统一 pgaudit_$v 包名并兼容 PGDG 旧名；PG16-18 复用 PGDG<br>Pigsty unifies PG14/15 package names; PG16–18 use PGDG packages, with 18.0 for PG18. |
| `pgbson` | `2.1.0` | `2.2.0` | PG14-18；RPM 包名 postgresbson<br>PG14-18; RPM package postgresbson |
| `pgdog` | `0.1.57` | `0.1.63` | PostgreSQL 连接池<br>PostgreSQL connection pooler |
| `pgedge-15` | `15.19-1PGSTY` | `15.19-3PGSTY` | 含 Spock 5.0.13、LOLOR 1.2.3<br>Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
| `pgedge-16` | `16.15-1PGSTY` | `16.15-3PGSTY` | 含 Spock 5.0.13、LOLOR 1.2.3<br>Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
| `pgedge-17` | `17.11-1PGSTY` | `17.11-3PGSTY` | 含 Spock 5.0.13、LOLOR 1.2.3<br>Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
| `pgedge-18` | `18.6-1PGSTY` | `18.6-3PGSTY` | 含 Spock 5.0.13、LOLOR 1.2.3<br>Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
| `pgexporter_ext` | - | `0.2.5` | 新增 DEB 补包；RPM 沿用 PGDG<br>New DEB coverage; RPM continues to use PGDG. |
| `pgextwlist` | `1.19` | `1.20` | PG14-18；RPM 配方更新；正式包采用 PGDG<br>PG14-18; RPM recipe updated; production packages from PGDG |
| `pggraph` | `1.2.0` | `1.2.1` | PG14-18；扩展名 graph；修正 DEB SQL 文件验收<br>PG14-18; Extension graph; fix DEB SQL payload checks |
| `pghydro` | RPM only: 6.6-1PIGSTY | RPM only: 6.6-2PGSTY | PG14-18；PostGIS 3.7；noarch<br>PG14-18; PostGIS 3.7; noarch |
| `pgmb` | RPM only: 1.0.0-1PIGSTY | RPM only: 1.0.0-2PGSTY | PG14-18；修复 schema 创建与 pgsql_http 依赖<br>PG14-18; fix schema creation and pgsql_http dependency |
| `pgmnemo` | `0.20.0` | `0.21.0` | PG17-18；pg_dump 会保留语料表和序列<br>PG17-18; preserves corpus tables and sequences in pg_dump |
| `pgmq` | `1.12.0` | `1.13.1` | PG14-18；纯 SQL<br>PG14-18; SQL-only |
| `pgmqtt` | `0.5.0` | `0.5.1` | PG14-18；需预加载；CDC 需 logical WAL<br>PG14-18; Preload required; CDC requires logical WAL |
| `pgrdf` | `0.6.20` | `0.6.40` | PG14-18；pgrx 0.19.3<br>PG14-18; pgrx 0.19.3; built, import pending |
| `pgroonga` | `4.0.8` | RPM: 4.1.0-4PGSTY.el9 / DEB: 4.1.0 | PG14-18；EL9 修订；EL8/10 以 2PGSTY 重建；Groonga 16.1.5<br>PG14-18; EL9 release; EL8/10 rebuilt at 2PGSTY; Groonga 16.1.5 |
| `pgrouting` | 4.0.1 | 4.0.2 | PGDG 软件包<br>PGDG packages |
| `pgs3` | `0.1.1` | `0.1.1` | PG17-18；已有扩展首次正式全量入库；32 主包；alpha<br>PG17-18; First full production packaging of an existing extension; 32 main packages; alpha |
| `pgsentinel` | `1.5.0` | `1.5.2` | PGDG 软件包；PG14-18<br>PGDG packages |
| `pgsodium` | 3.1.9 | RPM: 3.1.9 / DEB: 3.1.11 | DEB 升级并重建 libsodium 依赖；PG18 RPM 保持 3.1.9<br>DEB upgraded with matching libsodium; PG18 RPM remains at 3.1.9. |
| `pgsql_tweaks` | `1.0.5` | `1.1.0` | PG14-18；纯 SQL<br>PG14-18; SQL-only |
| `pgtde-18` | `18.4` | `18.6` | Percona 18.6.1；pg_tde 2.2.2<br>Percona 18.6.1; pg_tde 2.2.2 |
| `pgtde-18-contrib` | `18.4` | `18.6` | pg_stat_monitor 2.4.0；vector 0.8.6<br>pg_stat_monitor 2.4.0; vector 0.8.6 |
| `pgtelemetry` | - | `1.7` | PG14-18；纯 SQL；依赖 pg_stat_statements<br>PG14-18; SQL-only; requires pg_stat_statements |
| `pgvector` | `0.8.6` | `0.8.7` | PG18 离线包的 RPM/DEB 均采用 PGDG 0.8.7<br>Both RPM and DEB use PGDG 0.8.7 in the PG18 offline snapshot. |
| `pgvectorscale` | `0.9.1` | `0.9.1` | PG14-18；扩展名 vectorscale；同版本重构建、订正目录旧标签<br>PG14-18; Extension vectorscale; same-version rebuild and correction of stale catalog label |
| `plpgsql_check` | `2.10.4` | `2.10.16` | PG18 离线发布快照；SQL 版本 2.10<br>PG18 release snapshot; SQL version 2.10. |
| `plphp` | - | `2.6` | PG14-18；修正嵌入运行库依赖<br>PG14-18; fix embedded runtime dependencies |
| `plprql` | `18.0.1` | `18.0.2` | PG14-18<br>PG14-18 |
| `plv8` | `3.2.4` | `3.2.5` | PG14-18；修复 EL10 LTO 构建<br>PG14-18; Fix EL10 LTO builds |
| `polardb-17` | `17.10.1.0` | `17.11.1.0-2PGSTY` | PG17.11 内核与扩展；使用新版 PolarStore SDK 重建<br>PG17.11 kernel/contrib; rebuilt with updated PolarStore SDK |
| `polarstore` | `1.2.42-2PGSTY` | `1.2.42-3PGSTY` | 使用 zlog 1.2.20 重建<br>Rebuilt with zlog 1.2.20 |
| `postgis` | RPM: 3.6.4 / DEB: 3.7.0 | RPM: 3.7.0-1PGSTY / DEB: 3.7.0 | EL8 补包；EL9/10 由 PGDG 主供<br>PostGIS 3.7; Pigsty fills EL8 gaps; EL9/10 use PGDG. The PG18 archives contain one PostGIS branch. |
| `postgis_tiger_geocoder` | - | RPM: 2025.2-1PGSTY / DEB: 2025.2 | EL8 PG16-18 补包；独立 noarch 包<br>EL8 PG16-18 gap fill; standalone noarch package |
| `provsql` | `1.12.0` | `1.13.1` | 修复电路大小与取消操作；需预加载<br>Fixes circuit sizes/cancellation; preload required |
| `psql_bm25s` | `0.4.13` | `0.4.14` | PG17-18<br>PG17-18 |
| `q3c` | RPM only: 2.0.5 | RPM only: 2.0.6 | PGDG 软件包<br>PGDG packages |
| `rdf_fdw` | `2.7.0` | `3.1.0` | PG18 离线发布快照；RDF 外部数据访问<br>PG18 release snapshot; RDF foreign data access. |
| `rdkit` | RPM: 202303.3 / 202503.6 / DEB: 202503.6 | `202609.2` | PG14-18；EL9/10；移除下游升级补丁<br>EL9/10; D13/U24/U26; older OS packages retained |
| `redis` | `7.2.16` | `7.2.17-1PGSTY` | 含开发包<br>Includes devel package |
| `repmgr` | RPM only: 5.5.0 | RPM only: 5.5.1 | PGDG 软件包<br>PGDG packages |
| `session_variable` | `3.5` | `3.6` | PG14-18<br>PG14-18 |
| `set_user` | 4.2.0 | 4.3.0 | PGDG 软件包<br>PGDG packages |
| `snowflake` | `2.6.0` | `2.6.0` | PG15-18；随 pgEdge 重构建；订正旧目录 2.5.0 标签<br>PG15-18; Rebuilt with pgEdge; correct stale 2.5.0 catalog label |
| `spock` | `5.0.11` | `5.0.13` | 随 pgEdge 15-18 更新；需预加载<br>Updated with pgEdge 15-18; preload required |
| `stannum` | - | `0.1.0` | PG17-18；开发快照<br>PG17-18; development snapshot |
| `supautils` | `3.4.3` | `4.0.0` | PG18 离线发布快照<br>PG18 release snapshot. |
| `textsearch_intl` | - | `1.0.1` | PG18 离线包的 RPM/DEB 均为 1.0.1；SQL 版本 1.0<br>Both RPM and DEB use 1.0.1 in the PG18 snapshot; SQL version 1.0. |
| `timescaledb` | `2.29.1` | `2.31.0` | PG16-18；TSL<br>PG16-18; TSL |
| `timescaledb_toolkit` | 1.26.0 | 1.27.0 | PG15-18；保留 PG14 旧包<br>PG15-18; older PG14 packages retained |
| `ulak` | `0.0.2` | `0.2.0` | PG14-18；需预加载<br>PG14-18; preload |
| `valkey` | `9.1.1` | `9.1.3-1PGSTY` | 安全更新；含开发包<br>Security update; includes devel package |
| `vchord` | `1.1.1` | `1.3.0-1PGSTY` | PG14-18<br>PG14-18 |
| `vchord_bm25` | `0.3.0` | `1.1.0` | PG14-18；原生 tsvector<br>PG14-18; native tsvector |
| `vectorize` | `0.26.2` | `0.27.1` | PG14-18；SQL 0.23.0；多行处理修复<br>PG14-18; SQL 0.23.0; multi-row fix |
| `vgram` | - | `1.0` | PG14-18<br>PG14-18 |
| `wal2json` | 2.6 | 2.7 | PGDG 软件包<br>PGDG packages |
| `wrappers` | `0.6.2` | `0.6.4` | PG18 离线发布快照<br>PG18 release snapshot. |
| `zlog` | `1.2.18` | `1.2.20` | 联动重建 PolarStore 与 PolarDB<br>Rebuilds PolarStore and PolarDB |
{.wide .expand}

## 基础设施、应用模板与工具链

- **内核模板归位与 53 套配置模板**：`agens`、`halo`（原 `conf/mysql.yml`）、`ivory`、`mongo`、`mssql`、`oriole`、`pgedge`、`pgsql`、`pgtde`、`polar` 统一迁至 `conf/fork/`，通过 `./configure -c fork/<name>` 调用；`./configure -v` 会跳过固定大版本的 `fork/mssql` 与 `fork/polar`。新增 `app/silo` 与 `app/discourse`，独立配置模板总数增至 **53** 套（另保留 `conf/app/supa.yml` 软链接）。
- **仓库模块拆分与证书钩子**：Docker 官方源拆分为独立 `docker` 模块，EL 与 Debian/Ubuntu 的 Nginx 源统一拆分为独立 `nginx` 模块；INFRA 支持自定义 Nginx 生产门户模板与缓存目录；`/etc/nginx/certbot-deploy-hook` 在续签后自动执行 `/etc/nginx/link-cert` 刷新软链接并重载 Nginx；远程监控 `pg_exporters` 配置文件收紧为 `prometheus` 属主与 `0600` 权限。
- **Docker 应用模板增强**：`app.yml` 在渲染 `.env` 时自动把字面量 `$` 转义为 `$$`，防止复杂密码或配置被 Compose 误展开；以 [`app/silo`](/docs/app/silo/) 替代独立 MinIO Compose 模板，新增固定镜像 SHA 的 [`app/discourse`](/docs/app/discourse/)，并更新 Supabase `0.8.2`、Dify `1.17.1`、InsForge `2.3.3`、JumpServer `5.0.0`、Registry `3.1.2`。
- **OpenTofu、离线包与容器构建**：`terraform/` 默认切换为 `IAC_CLI=tofu`（兼容 `IAC_CLI=terraform`，详见 [OpenTofu 文档](/docs/deploy/terraform/)）；离线包默认路径统一为 `/var/tmp/pkg.tgz`（兼容旧 `/tmp/pkg.tgz` 回退并在失败时清理残缺目录）；[Docker 构建](/docs/setup/docker/) 改为消费 `make source` 产出的本地源码归档，升级至 Debian 13.7 并固定 `pig=1.11.0-*`。

### Infra 与 PIG 软件包更新表

| 仓库 / Repo | 项目 / Package | 版本变化 / Versions | 说明 / Notes |
|:---|:---|:---|:---|
| INFRA | `agentsview` | `0.40.1` → `0.47.0` | AI 会话查看器更新<br>Repacked for both architectures |
| INFRA | `alertmanager` | `0.33.1` → `0.35.0` | 告警管理器升级<br>Repacked for both architectures |
| INFRA | `barn` | `—` → `1.2.0` | 新增官方原生包并升级至 1.2 稳定版<br>Official native packages |
| INFRA | `blackbox-exporter` | `0.28.0` → `0.29.1` |  |
| INFRA | `caddy` | `2.11.4` → `2.11.9` | 含 FastCGI 安全修复<br>FastCGI security fixes |
| INFRA | `cargo-pgrx-0192` / `cargo-pgrx-0193` | Added `0.19.2` / `0.19.3` | 独立版本槽；EL8 双架构源码构建<br>Separate version slots; built from source for both EL8 architectures. |
| INFRA | `claude` / `claude-code` | `2.1.227` → `2.1.322` | 切换 Anthropic 官方签名原生包 `claude-code`；旧 `claude` 保留在 `2.1.319`<br>Switch to the official signed claude-code package; the old claude package remains at 2.1.319. |
| INFRA | `cloudflared` | `2026.7.3` → `2026.10.7` | 裸二进制重打包<br>Repacked upstream executable. |
| INFRA | `code` | `1.133.0` → `1.146.0` | 官方原生 DEB/RPM；仓库 RPM 副本签名<br>Official DEB/RPM packages; repository RPM copies are signed. |
| INFRA | `code-server` | `4.132.0` → `4.145.2` | 官方原生 DEB/RPM<br>Upstream native packages |
| INFRA | `codex` | `0.147.0` → `0.167.2` | 保留完整上游运行时及原始 bwrap<br>Complete canonical runtime preserved, including bundled bwrap |
| INFRA | `crush` | `0.88.1` → `0.100.0` | 官方 tarball 合规重打包并保留许可证<br>Repacked official tarball with licenses preserved. |
| INFRA | `dblab` | `0.47.4` → `0.55.2` | Repacked for both architectures |
| INFRA | `duckdb` | `1.5.5` → `2.0.0` | 大版本更新<br>Major version update. |
| INFRA | `etcd` | `3.7.1` → `3.7.3` |  |
| INFRA | `garage` | `2.3.0` → `2.5.0` |  |
| INFRA | `golang` | `1.26.5` → `1.27.4` | 官方工具链更新<br>Repacked for both architectures |
| INFRA | `grafana` | `13.1.3` → `13.3.1` | 官方原生 DEB/RPM<br>Official native packages |
| INFRA | `grafana-infinity-ds` | `3.11.3` → `4.1.6` | 大版本更新；含安全与 gRPC 修复<br>Security / gRPC fixes |
| INFRA | `grafana-plugins` | `13.0.0` → `13.3.0` | noarch 插件合集；JSON datasource 1.4.4、ECharts 7.3.0 等<br>Plugin bundle; includes JSON datasource 1.4.4 and ECharts 7.3.0. |
| INFRA | `grafana-victorialogs-ds` | `0.31.0` → `0.34.0` | Repacked for both architectures |
| INFRA | `grafana-victoriametrics-ds` | `0.25.2` → `1.0.1` | 1.0 正式版；POST/WITH 与安全修复<br>POST/WITH / security fixes |
| INFRA | `headscale` | `0.29.3` → `0.29.7` |  |
| INFRA | `hugo` | `0.164.0` → `0.169.0` | Extended 版本<br>Extended build. |
| INFRA | `ivorysql` | `5.4` → `5.6` | 新增原包配方；DEB `ivorysql-5` / RPM `ivorysql5`；PG 18.6 内核<br>New native recipe; DEB ivorysql-5 / RPM ivorysql5; PostgreSQL 18.6 |
| INFRA | `jmx-exporter` | `1.6.0` → `1.7.0` | noarch<br>Noarch; imported locally |
| INFRA | `juicefs` | `1.4.1` → `1.4.2` |  |
| INFRA | `k3s` / `k3s-images` | `1.36.3` → `1.37.2` | 二进制与 air-gap 离线镜像同步（`2PGSTY`）<br>Matching binary and air-gap image packages, revision 2PGSTY. |
| INFRA | `kafka` | `4.3.1` → `4.4.0` | noarch RPM / all DEB；上游 SHA512 已核验<br>Noarch RPM and all DEB; upstream SHA512 verified; imported locally |
| INFRA | `kafka-exporter` | `1.9.0` → `1.11.0` |  |
| INFRA | `kes` | `—` → `20261026000000.0.0` | 新增 PGSTY KES 密钥管理服务；保留上游签名<br>Key management service |
| INFRA | `logcli` / `loki` / `loki-canary` | `3.7.6` → `3.7.9` | Loki 组件同步更新<br>Loki components updated together. |
| INFRA | `maddy` | `0.9.5` → `0.9.7` | DMARC/IMAP 修复<br>DMARC/IMAP fixes |
| INFRA | `mcli` | `20260806000000.0.0` → `20261112000000.0.0` | pgsty 原生包；路径 `/usr/local/bin/mcli`<br>Native pgsty packages; executable at /usr/local/bin/mcli. |
| INFRA | `mcp-toolbox` | `1.8.0` → `1.16.0` | CGO 源码构建；glibc 2.28<br>CGO; glibc 2.28 |
| INFRA | `mongodb-exporter` | `0.52.0` → `0.54.0` |  |
| INFRA | `mtail` | `3.4.7` → `3.4.20` | Repacked for both architectures |
| INFRA | `mysqld-exporter` | `0.19.0` → `0.21.0` | 指标类型变更，与新版 MYSQL 规则对齐<br>Metric type changes |
| INFRA | `nginx-exporter` | `1.5.1` → `1.5.3` | Dual-architecture RPM/DEB built |
| INFRA | `nodejs` | `24.19.0` → `26.13.1` | 升级至 Node.js 26 LTS；RPM epoch 2<br>Node.js 26 LTS; RPM epoch 2. |
| INFRA | `openbao` | `—` → `2.7.2` | 新增官方原生双架构包；支撑 VAULT 模块<br>New official packages for both architectures; used by the VAULT module. |
| INFRA | `opencode` | `1.18.16` → `1.19.5` | 含 Bun 安全修复（`2PGSTY`）<br>Updated to 1.19.5; package revision 2PGSTY includes Bun security fixes. |
| INFRA | `opentofu` | `—` → `1.13.9` | 新增 IaC 默认工具；包名 `tofu`；含状态持久化修复<br>New default IaC tool, package name tofu; includes state persistence fixes. |
| INFRA | `pev2` | `1.23.0` → `1.25.0` | noarch RPM / all DEB<br>noarch RPM / all DEB |
| INFRA | `pg-exporter` | `1.4.1` → `1.6.1` | 升级至 v1.6.1；连接治理、失败冷却与 PG19 指标补齐<br>Connection governance, failure cooldown and additional PostgreSQL 19 metrics. |
| INFRA | `pg-hardstorage` | `1.2.1` → `1.7.0` | 静态二进制重打包<br>Repacked for both architectures |
| INFRA | `pg-timetable` | `7.0.0` → `7.1.0` | Dual-architecture RPM/DEB built |
| INFRA | `pgbackrest-exporter` | `0.24.0` → `0.25.0` | 源码构建<br>Source build |
| INFRA | `pgbot` | `—` → `0.9.0` | 新增；beta<br>New; beta |
| INFRA | `pgext` | `—` → `1.7.1` | 新增官方原生包配方<br>Official native packages |
| INFRA | `pggo` | `—` → `0.1.1` | 新增<br>New |
| INFRA | `pgschema` | `1.12.2` → `1.14.1` | 裸二进制重打包<br>Repacked for both architectures |
| INFRA | `pgstream` | `1.3.1` → `1.6.0` | 固定提交源码构建<br>Source build from pinned commit |
| INFRA | `pgsync` | `—` → `0.1.1` | 新增；beta<br>New; beta |
| INFRA | `pgterm` | `—` → `0.4.0` | 新增；beta<br>New; beta |
| INFRA | `pi-coding-agent` | `—` → `1.5.2` | 新增；保留完整上游运行时<br>New package; complete upstream runtime |
| INFRA | `pig` | `1.8.0` → `1.11.0` | 支持 Pigsty 4.6.0；内置 625 项扩展目录<br>Pigsty 4.6.0 support; embedded catalog contains 625 available extensions. |
| INFRA | `postgrest` | `16.1` → `16.5` | 最低支持 PostgreSQL 14<br>Requires PostgreSQL 14 or newer. |
| INFRA | `prometheus` | `3.13.2` → `3.16.0` | TLS / Remote Write 更新<br>TLS / Remote Write changes |
| INFRA | `promtail` | `3.6.7` → `3.6.11` | 补齐 EOL 制品<br>EOL artifact backfill |
| INFRA | `pushgateway` | `1.11.3` → `1.11.4` | Both architectures; imported locally |
| INFRA | `rainfrog` | `0.4.3` → `0.4.7` | Repacked for both architectures |
| INFRA | `rclone` | `1.75.0` → `1.76.0` | Repacked for both architectures |
| INFRA | `redis-exporter` | `1.89.0` → `1.97.0` | 支持 Redis 8 KEYSIZES<br>Redis 8 KEYSIZES |
| INFRA | `rust-toolchain` | `1.97.1` → `1.99.1` | 官方签名与双架构 ELF ABI 检查<br>Upstream signatures and dual-architecture ELF ABI checks passed; imported locally |
| INFRA | `rustfs` | `1.0.0-rc.1` → `1.0.5` | 保留仓库软件包，非 MINIO 模块后端<br>Available as an optional repository package; not a MINIO module backend. |
| INFRA | `sabiql` | `1.15.1` → `3.0.3` | 新增 MySQL 支持；需 Oracle MySQL CLI 8.4<br>Repacked for both architectures |
| INFRA | `sealos` | `5.0.1` → `5.1.1` | 官方原包；源码采用 Sealos Sustainable Use License<br>Official packages; upstream source uses the Sealos Sustainable Use License. |
| INFRA | `seaweedfs` | `4.41` → `4.53` | 包版本 `4.53.0`<br>Package version: 4.53.0 |
| INFRA | `silo` | `20260806000000.0.0` → `20261112000000.0.0` | 正式版原生包（`1PGSTY`），内嵌 Console 2.7.2<br>Native release packages, revision 1PGSTY, with Console 2.7.2 embedded. |
| INFRA | `silo-console` | `—` → `2.7.2` | 新增独立控制台原生包，与 Silo 20261112 配套<br>New standalone console package, paired with Silo 20261112. |
| INFRA | `sow` | `0.3.0` → `0.7.1` | 旧 0.3/0.4 workspace 升级需显式迁移<br>Existing 0.3/0.4 workspaces require an explicit migration. |
| INFRA | `sql-studio` | `0.1.51` → `0.1.53` | Dual-architecture RPM/DEB built |
| INFRA | `stalwart` | `0.16.17` → `1.1.0` | 1.x 大版本更新；0.16.x 需迁移<br>Major update to 1.x; migration required from 0.16.x. |
| INFRA | `tailcat` | `—` → `0.7.0` | 官方发布 tarball 构建<br>Verified and built dual-architecture RPM/DEB |
| INFRA | `timescaledb-tools` | `0.19.0` → `0.19.1` | tune `0.19.1` + parallel-copy `0.13.2`；Go 1.27.4 源码构建<br>tune 0.19.1 + parallel-copy 0.13.2; Go 1.27.4 source builds |
| INFRA | `uv` | `0.12.3` → `0.13.7` |  |
| INFRA | `v2ray` | `5.52.0` → `5.53.0` | Dual-architecture RPM/DEB built |
| INFRA | `vector` | `0.57.0` → `0.61.0` | 官方原生 DEB/RPM<br>Official native DEB/RPM packages. |
| INFRA | `victoria-logs` / `vlogscli` / `vlagent` | `1.52.0` → `1.53.0` | 日志组件同步更新<br>Logs components updated together. |
| INFRA | `victoria-metrics` / `victoria-metrics-cluster` / `vmutils` | `1.149.0` → `1.156.0` | 单机、集群与 vmutils 同步更新<br>Single-node, cluster and utility packages updated together. |
| INFRA | `victoria-traces` | `0.10.0` → `0.13.0` | gRPC TLS 改为可选<br>gRPC TLS now opt-in |
| INFRA | `xray` | `26.3.27` → `26.11.9` | 安全与协议更新<br>Repacked for both architectures |
| PIG | `v1.8.1` | `v1.8.0` → `v1.8.1` | Go 1.27.1；CLI、仓库与构建安全加固<br>Go 1.27.1; CLI, repository and build safety improvements. |
| PIG | `v1.9.0` | `v1.8.1` → `v1.9.0` | Xray 客户端/服务端；仓库签名公钥；pgrx 0.19.3；目录 600<br>Xray client/server, repository signing keys, pgrx 0.19.3 and a 600-entry catalog. |
| PIG | `v1.10.0` – `v1.10.4` | `v1.9.0` → `v1.10.4` | PG 目标与恢复安全、Inventory 保真、分类别名修复；Go 1.27.3<br>Safer PG targets and recovery, inventory preservation, category aliases and Go 1.27.3. |
| PIG | `v1.11.0` | `v1.10.4` → `v1.11.0` | 适配 Pigsty v4.6.0；隔离内核分支配置、收紧备份恢复与清理边界；内置 625 项扩展目录<br>Pigsty 4.6.0 support, kernel-specific configuration isolation, stricter backup/recovery/cleanup boundaries and a 625-entry catalog. |
| UPSTREAM | `containerd.io` | - → `2.4.2-3` | 官方 RPM/DEB（拆分为独立 docker 仓库模块）<br>Official packages; separate docker repository module. |
| UPSTREAM | `docker-buildx-plugin` | - → `0.38.1` | 官方 RPM/DEB（独立 docker 仓库模块）<br>Official packages; separate docker repository module. |
| UPSTREAM | `docker-ce` | - → `29.9.2` | 官方 RPM/DEB（独立 docker 仓库模块）<br>Official packages; separate docker repository module. |
| UPSTREAM | `docker-ce-cli` | - → `29.9.2` | 官方 RPM/DEB（独立 docker 仓库模块）<br>Official packages; separate docker repository module. |
| UPSTREAM | `docker-ce-rootless-extras` | - → `29.9.2` | 官方 RPM/DEB（独立 docker 仓库模块）<br>Official packages; separate docker repository module. |
| UPSTREAM | `docker-compose-plugin` | - → `5.7.0` | 官方 RPM/DEB（独立 docker 仓库模块）<br>Official packages; separate docker repository module. |
| UPSTREAM | `nginx` | - → `1.31.8` | 官方 RPM/DEB（拆分为独立 nginx 仓库模块）<br>Official packages; separate nginx repository module. |
| UPSTREAM | `nginx-module-acme` | - → `1.31.8+0.4.1` | 官方 RPM/DEB（独立 nginx 仓库模块）<br>Official packages; separate nginx repository module. |
{.wide .expand}

## 兼容性变化与升级说明

从 v4.5 升级或迁移配置前，请重点核对以下事项：

1. **内核分支模板路径调整**：原 `conf/<fork>.yml` 已迁移至 `conf/fork/<fork>.yml`，其中 OpenHaloDB 模板由 `conf/mysql.yml` 改名为 `conf/fork/halo.yml`；脚本调用 `./configure -c` 时请改为 `fork/<name>`（原生 MySQL 8.4 仍为 `demo/mysql`）。
2. **MYSQL 模块参数与目录收敛**：自定义清单若使用了已移除的 `mysql_backup_repo`、`mysql_rm_confirm`、`mysql_role`、`mysql_port` 等旧变量，需按新版 [16 项公开参数](/docs/mysql/param/) 清理迁移；`mysql_safeguard` 现默认设为 `true`。
3. **Docker 与 Nginx 仓库模块独立**：自定义 `repo_modules` 若需要安装 Docker 或新版 Nginx，请显式包含 `docker` 或 `nginx` 模块（默认模板已按需更新）。
4. **Terraform 默认切换为 OpenTofu**：`terraform/` 下 Makefile 默认执行 `tofu`；继续使用 HashiCorp Terraform 时请显式传入 `IAC_CLI=terraform`，或参考 [OpenTofu 指南](/docs/deploy/terraform/) 迁移本地状态。
5. **离线包默认路径变更为 `/var/tmp/pkg.tgz`**：自动化传输脚本建议统一改为 `/var/tmp/pkg.tgz`（当该路径不存在时 `bootstrap` 仍兼容读取 `/tmp/pkg.tgz`）。
6. **Claude Code 包名更新**：Infra 仓库新增 Anthropic 官方签名原生包 `claude-code`（`2.1.322`），旧自维护包 `claude` 停留在 `2.1.319` 且无自动 Obsoletes 替换，已安装旧包的环境建议按新包名迁移。
7. **SOW 工作区版本迁移**：`sow` 升级至 `0.7.1`，旧 `0.3` / `0.4` 工作区升级时需按提示显式执行迁移。

## 获取 v4.6.0

在受支持的全新 Linux 节点上安装：

```bash
curl -fsSL https://repo.pigsty.cc/get | bash -s v4.6.0
cd ~/pigsty
./bootstrap
./configure
./deploy.yml
```

生产环境升级请勿直接全量重跑初始化剧本。请先核对当前集群状态、有效备份（`pig pg list`、`pig pb info`）及上述兼容性说明，再以明确的 `-l` 范围先做 `--check` 预检并分步执行维护。

## 离线发布与双语说明

14 个离线包已在 EL9/10、Debian 12/13、Ubuntu 22/24/26 的 x86_64 / ARM64 全新 VM 上通过独立 `rich` 离线部署，正式部署无失败或忽略错误。默认分组排除 `hdfs_fdw` 与 OneSparse，APT/DNF 使用完整目标集合统一求解；源码请使用 Release 附件 `pigsty-v4.6.0.tgz`，其包含尚未进入标签的离线修复。

完整中英文版本说明、包版本口径、源码差异与离线验证结果，见 [**v4.6.0 发布注记**](/docs/about/release/#v460)。

All 14 archives passed a fresh, isolated installation with the stock `rich` template on x86_64 and ARM64. Use the attached `pigsty-v4.6.0.tgz`, which includes the offline fixes absent from the automatic tag archives. See the [**English release notes**](/docs/about/release/#v460-en), shared package tables and validation details.
