PIGSTY

DEB 发布

PostgreSQL 和扩展 DEB 包变更日志和发布说明

查看 pgsty/deb 仓库的构建规范和 pigsty-pgsql 的使用方法

pig
curl https://repo.pigsty.io/pig | bash      # 下载并安装 pig CLI 工具
pig repo add all pigsty -u                  # 添加 pigsty-pgsql 仓库并更新缓存
apt
# 将 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 update

2025-11-10

为几乎所有扩展添加 PostgreSQL 18 支持

名称旧版本新版本备注
omni_csv-0.1.1new
omni_datasets-0.1.0new
omni_shmem-0.1.0new
pg_csv-1.0.1new
pljs-1.0.3new
plxslt-0.20140221new
credcheck3.04.2+pg18
dbt20.45.00.61.7+pg18
h34.1.34.2.3+pg18
h3_postgis4.1.34.2.3+pg18
mongo_fdw1.15.5.3+pg18
multicorn3.03.2+pg18
orafce4.14.44.14.6+pg18
pg_hint_plan1.7.01.8.0+pg18
pg_search0.18.10.19.2+pg18
pg_show_plans2.1.62.1.7+pg18
pgactive2.1.62.1.7+pg18
pgpcre10.20190509+pg18
plpgsql_check2.8.22.8.3+pg18
roaringbitmap0.5.40.5.5+pg18
uint1.202312061.20250815+pg18
uint1281.1.01.1.1+pg18
anon2.3.02.4.1+pg18
collection1.0.01.1.0+pg18
emaj4.7.04.7.1+pg18
explain_ui0.0.10.0.2+pg18
firebird_fdw1.4.01.4.1+pg18
login_hook1.61.7+pg18
logerrors2.1.32.1.5+pg18
mobilitydb1.2.01.3.0+pg18
omni0.2.90.2.14+pg18
omni_httpc0.1.50.1.10+pg18
omni_httpd0.4.60.4.11+pg18
omni_kube0.1.10.4.2+pg18
omni_sql0.5.10.5.3+pg18
omni_sqlite0.1.20.2.2+pg18
omni_worker0.1.00.2.1+pg18
pg_cardano1.0.51.1.1+pg18
pg_checksums1.21.3+pg18
pg_cron1.6.51.6.7+pg18
pg_duckdb0.3.11.1.0+pg18
pg_failover_slots1.1.01.2.0+pg18
pg_graphql1.5.111.5.12+pg18
pg_idkit0.3.10.4.0+pg18
pg_mooncake0.1.20.2.0+pg18
pg_net0.9.20.20.0+pg18
pg_parquet0.4.30.5.1+pg18
pg_partman5.2.45.3.0+pg18
pg_session_jwt0.3.10.3.3+pg18
pg_sphere1.5.11.5.2+pg18
pg_stat_monitor2.2.02.3.0+pg18
pg_statement_rollback1.41.5+pg18
pg_store_plans1.81.9+pg18
pg_task1.0.02.1.12+pg18
pg_tle1.5.11.5.2+pg18
pg_uuidv71.6.01.7.0+pg18
pglogical2.4.52.4.6+pg18
pgmq1.5.11.7.0+pg18
pgroonga4.0.04.0.4+pg18
pgsql_tweaks0.11.31.0.2+pg18
pldbgapi1.81.9+pg18
plprql1.0.018.0.0+pg18
supautils2.10.03.0.2+pg18
timescaledb2.22.02.23.0+pg18
timescaledb_toolkit1.21.01.22.0+pg18
vchord0.5.10.5.3+pg18
vectorize0.22.20.25.0+pg18
wrappers0.5.40.5.6+pg18
acl1.0.4-+pg18
aggs_for_arrays1.3.3-+pg18
aggs_for_vecs1.4.0-+pg18
base361.0.0-+pg18
hashlib1.1-+pg18
hll2.18-+pg18
imgsmlr1.0-+pg18
index_advisor0.2.0-+pg18
kafka_fdw0.0.3-+pg18
pg_auth_mon3.0-+pg18
pg_background1.3-+pg18
pg_bigm1.2-+pg18
pg_profile4.10-+pg18
pg_stat_kcache2.3.0-+pg18
pgdd0.6.0-+pg18
pgjwt0.2.0-+pg18
pgmp1.0.5-+pg18
plprofiler4.2.5-+pg18
plv83.2.4-+pg18
redis_fdw1.0-+pg18
repmgr5.5.0-+pg18
system_stats3.2-+pg18
topn2.7.0-+pg18
zhparser2.3-+pg18

2025-09-06

名称旧版本新版本备注
timesacledb2.21.12.22.0
citus13.1.013.2.0
documentdb0.105.00.106.0work with ferretdb 2.5
ddlx0.290.30+ pg18
uint1281.0.01.1.0+ pg18
vchord0.4.30.5.1pgrx 0.16.0
pg_idkit0.3.00.3.1pgrx 0.15.0
pg_search0.17.30.18.0pgrx 0.15.0
pg_parquet0.4.00.4.3pgrx 0.16.0
wrappers0.5.30.5.4pgrx 0.14.3
pg_rewrite-2.0.0+ Debian/Ubuntu
pg_tracing-0.1.3-2+ pg 14/18
pg_curl2.42.4.5
pg_ivm1.111.12+ pg18
pg_rewrite-2.0.0new extension
pg_tracing-1.3.0+ pg14 / pg18
pgactive2.1.52.1.6+ pg18
pgsentinel1.11.21.2
pg_tle1.5.1-11.5.1-2+ pg18
redis_fdw+ pg18
emaj4.64.7
table_version1.11.01.11.1

2025-07-24

名称旧版本新版本备注
OrioleDBbeta11 1.4beta12 1.5与 oriolepg 17.11 配合
OriolePG17.917.11与 orioledb 1.5 beta12 配合
documentdb0.104.00.105.0与 ferretdb 2.4 配合
timescaledb2.20.02.21.1
supautils2.9.22.10.0.so 位置变更
plv83.2.33.2.4
postgresql_anonymizer3.1.12.3.0 (pgrx 0.14.3)
wrappers0.5.00.5.3 (pgrx 0.14.3)pgrx 版本变更
pgvectorscale0.7.10.8.0 (pgrx 0.12.9)
pg_search0.15.80.17.0 (download)修复 el icu 依赖问题
pg_profile4.8.04.10.0

2025-07-04

名称旧版本新版本备注
orioledb1.4 beta11重新构建
pgvectorscale0.7.10.7.1重新构建修复错误
pg_stat_monitor2.1.12.2.0
pgsql-tweaks0.11.10.11.3
pg_tle1.5.01.5.1
pg_curl2.42.4.5

2025-06-24

名称旧版本新版本备注
citus13.0.313.1.0
timescaledb2.20.02.21.0
vchord0.3.00.4.3
pgactive-2.1.5需要 pgfeutils
documentdb0.103.00.104.0添加 arm 支持

2025-05-26

名称旧版本新版本备注
pgdd0.5.00.6.0
convert-0.0.4
pg_idkit0.2.00.3.0
pg_tokenizer.rs-0.1.0
pg_render-0.1.2
pgx_ulid-0.2.0
pg_ivm1.10.01.11.0
orioledb1.4.0b101.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_tle1.2.01.5.0
supautils2.5.02.6.0
sslutils1.31.4
pg_profile4.74.8
pg_jsonschema0.3.20.3.3
pg_incremental1.1.11.2.0
ddl_historization0.70.0.7
pg_sqlog3.1.71.6
pg_random--
pg_stat_monitor2.1.02.1.1
pg_profile4.74.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)