DEB 发布
PostgreSQL 和扩展 DEB 包变更日志和发布说明
查看 pgsty/deb 仓库的构建规范和 pigsty-pgsql 的使用方法
curl https://repo.pigsty.io/pig | bash # 下载并安装 pig CLI 工具
pig repo add all pigsty -u # 添加 pigsty-pgsql 仓库并更新缓存# 将 Pigsty 的 GPG 公钥添加到您的系统密钥链以验证包签名
curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg
# 获取 Debian 发行版代号(distro_codename=jammy、focal、bullseye、bookworm),并将相应的上游仓库地址写入 APT List 文件
distro_codename=$(lsb_release -cs)
sudo tee /etc/apt/sources.list.d/pigsty-io.list > /dev/null <<EOF
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/pgsql/${distro_codename} ${distro_codename} main
EOF
# 刷新 APT 仓库缓存
sudo apt update2025-11-10
为几乎所有扩展添加 PostgreSQL 18 支持
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| omni_csv | - | 0.1.1 | new |
| omni_datasets | - | 0.1.0 | new |
| omni_shmem | - | 0.1.0 | new |
| pg_csv | - | 1.0.1 | new |
| pljs | - | 1.0.3 | new |
| plxslt | - | 0.20140221 | new |
| credcheck | 3.0 | 4.2 | +pg18 |
| dbt2 | 0.45.0 | 0.61.7 | +pg18 |
| h3 | 4.1.3 | 4.2.3 | +pg18 |
| h3_postgis | 4.1.3 | 4.2.3 | +pg18 |
| mongo_fdw | 1.1 | 5.5.3 | +pg18 |
| multicorn | 3.0 | 3.2 | +pg18 |
| orafce | 4.14.4 | 4.14.6 | +pg18 |
| pg_hint_plan | 1.7.0 | 1.8.0 | +pg18 |
| pg_search | 0.18.1 | 0.19.2 | +pg18 |
| pg_show_plans | 2.1.6 | 2.1.7 | +pg18 |
| pgactive | 2.1.6 | 2.1.7 | +pg18 |
| pgpcre | 1 | 0.20190509 | +pg18 |
| plpgsql_check | 2.8.2 | 2.8.3 | +pg18 |
| roaringbitmap | 0.5.4 | 0.5.5 | +pg18 |
| uint | 1.20231206 | 1.20250815 | +pg18 |
| uint128 | 1.1.0 | 1.1.1 | +pg18 |
| anon | 2.3.0 | 2.4.1 | +pg18 |
| collection | 1.0.0 | 1.1.0 | +pg18 |
| emaj | 4.7.0 | 4.7.1 | +pg18 |
| explain_ui | 0.0.1 | 0.0.2 | +pg18 |
| firebird_fdw | 1.4.0 | 1.4.1 | +pg18 |
| login_hook | 1.6 | 1.7 | +pg18 |
| logerrors | 2.1.3 | 2.1.5 | +pg18 |
| mobilitydb | 1.2.0 | 1.3.0 | +pg18 |
| omni | 0.2.9 | 0.2.14 | +pg18 |
| omni_httpc | 0.1.5 | 0.1.10 | +pg18 |
| omni_httpd | 0.4.6 | 0.4.11 | +pg18 |
| omni_kube | 0.1.1 | 0.4.2 | +pg18 |
| omni_sql | 0.5.1 | 0.5.3 | +pg18 |
| omni_sqlite | 0.1.2 | 0.2.2 | +pg18 |
| omni_worker | 0.1.0 | 0.2.1 | +pg18 |
| pg_cardano | 1.0.5 | 1.1.1 | +pg18 |
| pg_checksums | 1.2 | 1.3 | +pg18 |
| pg_cron | 1.6.5 | 1.6.7 | +pg18 |
| pg_duckdb | 0.3.1 | 1.1.0 | +pg18 |
| pg_failover_slots | 1.1.0 | 1.2.0 | +pg18 |
| pg_graphql | 1.5.11 | 1.5.12 | +pg18 |
| pg_idkit | 0.3.1 | 0.4.0 | +pg18 |
| pg_mooncake | 0.1.2 | 0.2.0 | +pg18 |
| pg_net | 0.9.2 | 0.20.0 | +pg18 |
| pg_parquet | 0.4.3 | 0.5.1 | +pg18 |
| pg_partman | 5.2.4 | 5.3.0 | +pg18 |
| pg_session_jwt | 0.3.1 | 0.3.3 | +pg18 |
| pg_sphere | 1.5.1 | 1.5.2 | +pg18 |
| pg_stat_monitor | 2.2.0 | 2.3.0 | +pg18 |
| pg_statement_rollback | 1.4 | 1.5 | +pg18 |
| pg_store_plans | 1.8 | 1.9 | +pg18 |
| pg_task | 1.0.0 | 2.1.12 | +pg18 |
| pg_tle | 1.5.1 | 1.5.2 | +pg18 |
| pg_uuidv7 | 1.6.0 | 1.7.0 | +pg18 |
| pglogical | 2.4.5 | 2.4.6 | +pg18 |
| pgmq | 1.5.1 | 1.7.0 | +pg18 |
| pgroonga | 4.0.0 | 4.0.4 | +pg18 |
| pgsql_tweaks | 0.11.3 | 1.0.2 | +pg18 |
| pldbgapi | 1.8 | 1.9 | +pg18 |
| plprql | 1.0.0 | 18.0.0 | +pg18 |
| supautils | 2.10.0 | 3.0.2 | +pg18 |
| timescaledb | 2.22.0 | 2.23.0 | +pg18 |
| timescaledb_toolkit | 1.21.0 | 1.22.0 | +pg18 |
| vchord | 0.5.1 | 0.5.3 | +pg18 |
| vectorize | 0.22.2 | 0.25.0 | +pg18 |
| wrappers | 0.5.4 | 0.5.6 | +pg18 |
| acl | 1.0.4 | - | +pg18 |
| aggs_for_arrays | 1.3.3 | - | +pg18 |
| aggs_for_vecs | 1.4.0 | - | +pg18 |
| base36 | 1.0.0 | - | +pg18 |
| hashlib | 1.1 | - | +pg18 |
| hll | 2.18 | - | +pg18 |
| imgsmlr | 1.0 | - | +pg18 |
| index_advisor | 0.2.0 | - | +pg18 |
| kafka_fdw | 0.0.3 | - | +pg18 |
| pg_auth_mon | 3.0 | - | +pg18 |
| pg_background | 1.3 | - | +pg18 |
| pg_bigm | 1.2 | - | +pg18 |
| pg_profile | 4.10 | - | +pg18 |
| pg_stat_kcache | 2.3.0 | - | +pg18 |
| pgdd | 0.6.0 | - | +pg18 |
| pgjwt | 0.2.0 | - | +pg18 |
| pgmp | 1.0.5 | - | +pg18 |
| plprofiler | 4.2.5 | - | +pg18 |
| plv8 | 3.2.4 | - | +pg18 |
| redis_fdw | 1.0 | - | +pg18 |
| repmgr | 5.5.0 | - | +pg18 |
| system_stats | 3.2 | - | +pg18 |
| topn | 2.7.0 | - | +pg18 |
| zhparser | 2.3 | - | +pg18 |
2025-09-06
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| timesacledb | 2.21.1 | 2.22.0 | |
| citus | 13.1.0 | 13.2.0 | |
| documentdb | 0.105.0 | 0.106.0 | work with ferretdb 2.5 |
| ddlx | 0.29 | 0.30 | + pg18 |
| uint128 | 1.0.0 | 1.1.0 | + pg18 |
| vchord | 0.4.3 | 0.5.1 | pgrx 0.16.0 |
| pg_idkit | 0.3.0 | 0.3.1 | pgrx 0.15.0 |
| pg_search | 0.17.3 | 0.18.0 | pgrx 0.15.0 |
| pg_parquet | 0.4.0 | 0.4.3 | pgrx 0.16.0 |
| wrappers | 0.5.3 | 0.5.4 | pgrx 0.14.3 |
| pg_rewrite | - | 2.0.0 | + Debian/Ubuntu |
| pg_tracing | - | 0.1.3-2 | + pg 14/18 |
| pg_curl | 2.4 | 2.4.5 | |
| pg_ivm | 1.11 | 1.12 | + pg18 |
| pg_rewrite | - | 2.0.0 | new extension |
| pg_tracing | - | 1.3.0 | + pg14 / pg18 |
| pgactive | 2.1.5 | 2.1.6 | + pg18 |
| pgsentinel | 1.1 | 1.2 | 1.2 |
| pg_tle | 1.5.1-1 | 1.5.1-2 | + pg18 |
| redis_fdw | + pg18 | ||
| emaj | 4.6 | 4.7 | |
| table_version | 1.11.0 | 1.11.1 |
2025-07-24
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| OrioleDB | beta11 1.4 | beta12 1.5 | 与 oriolepg 17.11 配合 |
| OriolePG | 17.9 | 17.11 | 与 orioledb 1.5 beta12 配合 |
| documentdb | 0.104.0 | 0.105.0 | 与 ferretdb 2.4 配合 |
| timescaledb | 2.20.0 | 2.21.1 | |
| supautils | 2.9.2 | 2.10.0 | .so 位置变更 |
| plv8 | 3.2.3 | 3.2.4 | |
| postgresql_anonymizer | 3.1.1 | 2.3.0 (pgrx 0.14.3) | |
| wrappers | 0.5.0 | 0.5.3 (pgrx 0.14.3) | pgrx 版本变更 |
| pgvectorscale | 0.7.1 | 0.8.0 (pgrx 0.12.9) | |
| pg_search | 0.15.8 | 0.17.0 (download) | 修复 el icu 依赖问题 |
| pg_profile | 4.8.0 | 4.10.0 |
2025-07-04
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| orioledb | 1.4 beta11 | 重新构建 | |
| pgvectorscale | 0.7.1 | 0.7.1 | 重新构建修复错误 |
| pg_stat_monitor | 2.1.1 | 2.2.0 | |
| pgsql-tweaks | 0.11.1 | 0.11.3 | |
| pg_tle | 1.5.0 | 1.5.1 | |
| pg_curl | 2.4 | 2.4.5 |
2025-06-24
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| citus | 13.0.3 | 13.1.0 | |
| timescaledb | 2.20.0 | 2.21.0 | |
| vchord | 0.3.0 | 0.4.3 | |
| pgactive | - | 2.1.5 | 需要 pgfeutils |
| documentdb | 0.103.0 | 0.104.0 | 添加 arm 支持 |
2025-05-26
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| pgdd | 0.5.0 | 0.6.0 | |
| convert | - | 0.0.4 | |
| pg_idkit | 0.2.0 | 0.3.0 | |
| pg_tokenizer.rs | - | 0.1.0 | |
| pg_render | - | 0.1.2 | |
| pgx_ulid | - | 0.2.0 | |
| pg_ivm | 1.10.0 | 1.11.0 | |
| orioledb | 1.4.0b10 | 1.4.0b11 |
2025-05-22
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| openhanded | - | 14.10 | |
| spat | - | 0.1.0a4 | |
| pgsentinel | - | 1.1.0 | |
| timescaledb | - | 2.20.0 | |
| sqlite_fdw | - | 2.5.0 | |
| documentdb | - | 0.103.0 | |
| tzf | - | 0.2.2 | |
| pg_vectorize | - | 0.22.2 | |
| wrappers | - | 0.5.0 |
2025-05-07
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| omnigres | - | 20250507 | |
| citus | - | 12.0.3 | |
| timescaledb | - | 2.19.3 | |
| supautils | - | 2.9.1 | |
| pg_envvar | - | 1.0.1 | |
| pgcollection | - | 1.0.0 | |
| aggs_for_vecs | - | 1.4.0 | |
| pg_tracing | - | 0.1.3 | |
| pgmq | - | 1.5.1 | |
| tzf-pg | - | 0.2.0 | |
| pg_search | - | 0.15.18 | |
| anon | - | 2.1.1 | |
| pg_parquet | - | 0.4.0 | |
| pg_cardano | - | 1.0.5 | |
| pglite_fusion | - | 0.0.5 | |
| vchord_bm25 | - | 0.2.1 | |
| vchord | - | 0.3.0 | |
| timescaledb-toolkit | - | 1.21.0 | |
| pgvectorscale | - | 0.7.1 | |
| pg_session_jwt | - | 0.3.1 |
2025-03-20
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| timescaledb | - | 2.19.0 | |
| citus | - | 13.0.2 | |
| documentdb | - | 1.102 | |
| pg_analytics | - | 0.3.7 | |
| pg_search | - | 0.15.8 | |
| pg_ivm | - | 1.10 | |
| emaj | - | 4.6.0 | |
| pgsql_tweaks | - | 0.11.0 | |
| pgvectorscale | - | 0.6.0 | |
| pg_session_jwt | - | 0.2.0 | |
| wrappers | - | 0.4.5 | |
| pg_parquet | - | 0.3.1 | |
| vchord | - | 0.2.2 | |
| pg_tle | 1.2.0 | 1.5.0 | |
| supautils | 2.5.0 | 2.6.0 | |
| sslutils | 1.3 | 1.4 | |
| pg_profile | 4.7 | 4.8 | |
| pg_jsonschema | 0.3.2 | 0.3.3 | |
| pg_incremental | 1.1.1 | 1.2.0 | |
| ddl_historization | 0.7 | 0.0.7 | |
| pg_sqlog | 3.1.7 | 1.6 | |
| pg_random | - | - | |
| pg_stat_monitor | 2.1.0 | 2.1.1 | |
| pg_profile | 4.7 | 4.8 |
2024-10-16
| 名称 | 旧版本 | 新版本 | 备注 |
|---|---|---|---|
| pg_ivm | - | 1.9 | |
| pg_timeseries | - | 0.1.6 | |
| pgmq | - | 1.4.4 | |
| pg_protobuf | - | 16 17 | |
| pg_uuidv7 | - | 1.6 | |
| pg_readonly | - | latest | |
| pgddl | - | 0.28 | |
| pg_safeupdate | - | latest | |
| pg_stat_monitor | - | 2.1 | |
| pg_profile | - | 4.7 | |
| system_stats | - | 3.2 | |
| pg_auth_mon | - | 3.0 | |
| login_hook | - | 1.6 | |
| logerrors | - | 2.1.3 | |
| pg-orphaned | - | latest | |
| pgnodemx | - | 1.7 | |
| sslutils | - | 1.4 (+16,17) |