PIGSTY

RPM 发布

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

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

pig
curl https://repo.pigsty.io/pig | bash      # 下载并安装 pig CLI 工具
pig repo add all pigsty -u                  # 添加 pigsty-pgsql 仓库并更新缓存
yum
# 将 Pigsty 的 GPG 公钥添加到您的系统密钥链以验证包签名
curl -fsSL https://repo.pigsty.io/key | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null

# 将 Pigsty 仓库定义文件添加到 /etc/yum.repos.d/ 目录,包括两个仓库
sudo tee /etc/yum.repos.d/pigsty-pgsql.repo > /dev/null <<-'EOF'
[pigsty-pgsql]
name=Pigsty PGSQL For el$releasever.$basearch
baseurl=https://repo.pigsty.io/yum/pgsql/el$releasever.$basearch
skip_if_unavailable = 1
enabled = 1
priority = 1
gpgcheck = 1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty
module_hotfixes=1
EOF

# 刷新 YUM/DNF 仓库缓存
sudo yum makecache;

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
pg_dbms_errlog-2.2new
pg_rrule-0.2.0new
plxslt-0.20140221new
anon2.3.02.4.1+pg18
collection1.0.01.1.0+pg18
credcheck3.04.2+pg18
emaj4.7.04.7.1+pg18
explain_ui0.0.10.0.2+pg18
firebird_fdw1.4.01.4.1+pg18
logerrors2.1.32.1.5+pg18
multicorn3.03.2+pg18
omni0.2.90.2.14+pg18
omni_email00.1.0+pg18
omni_httpc0.1.50.1.10+pg18
omni_httpd0.4.60.4.11+pg18
omni_id0.4.20.4.3+pg18
omni_kube0.1.10.4.2+pg18
omni_ledger0.1.20.1.3+pg18
omni_sql0.5.10.5.3+pg18
omni_sqlite0.1.20.2.2+pg18
omni_types0.3.40.3.6+pg18
omni_vfs0.2.10.2.2+pg18
omni_worker0.1.00.2.1+pg18
periods1.2.21.2.3+pg18
pg_bestmatch0.0.10.0.2+pg18
pg_cardano1.0.51.1.1+pg18
pg_checksums1.11.3+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_later0.3.00.3.1+pg18
pg_mooncake0.1.20.2.0+pg18
pg_net0.9.20.20.0+pg18
pg_parquet0.4.30.5.1+pg18
pg_render0.1.20.1.3+pg18
pg_session_jwt0.3.10.3.3+pg18
pg_smtp_client0.2.00.2.1+pg18
pg_sphere1.5.11.5.2+pg18
pg_statement_rollback1.41.5+pg18
pg_store_plans1.81.9+pg18
pg_tle1.5.11.5.2+pg18
pg_tokenizer0.1.00.1.1+pg18
pg_uuidv71.6.01.7.0+pg18
pgactive2.1.62.1.7+pg18
pglogical2.4.52.4.6+pg18
pglogical_origin2.4.52.4.6+pg18
pgmq1.5.11.7.0+pg18
pgsmcrypto0.1.00.1.1+pg18
pgx_ulid0.2.00.2.1+pg18
pldbgapi1.81.9+pg18
pljava1.6.81.6.10+pg18
plprql1.0.018.0.0+pg18
roaringbitmap0.5.40.5.5+pg18
semver0.32.10.40.0+pg18
supautils2.10.03.0.2+pg18
tds_fdw2.0.42.0.5+pg18
timescaledb2.22.02.23.0+pg18
timescaledb_toolkit1.21.01.22.0+pg18
timeseries0.1.60.1.7+pg18
tzf0.2.20.2.3+pg18
vchord0.5.10.5.3+pg18
vchord_bm250.2.10.2.2+pg18
vectorize0.22.20.25.0+pg18
wrappers0.5.40.5.6+pg18
gzip1.0.11.0.0+pg18
hypopg1.4.11.4.2+pg18
mobilitydb1.2.01.3.0+pg18
mongo_fdw5.5.15.5.3+pg18
orafce4.14.44.14.6+pg18
pg_hint_plan1.7.11.8.0+pg18
pg_ivm1.111.13+pg18
pg_partman5.2.45.3.1+pg18
pg_search0.18.10.19.2+pg18
pg_show_plans2.1.62.1.7+pg18
pgpcre10.20190509+pg18
pgroonga4.0.04.0.4+pg18
pgroonga_database4.0.04.0.4+pg18
plpgsql_check2.8.22.8.3+pg18
uint1.202312061.20250815+pg18
uint1281.1.01.1.1+pg18
omni_*2025052520251108+pg18
acl1.0.4+pg18
aggs_for_arrays1.3.3+pg18
aggs_for_vecs1.4.0+pg18
arraymath1.1+pg18
asn1oid1.6+pg18
aws_s30.0.1+pg18
base361.0.0+pg18
base620.0.1+pg18
bzip1.0.0+pg18
chkpass1.0+pg18
convert0.0.4+pg18
count_distinct3.0.2+pg18
country0.0.3+pg18
cryptint1.0.0+pg18
currency0.0.3+pg18
data_historization1.1.0+pg18
db_migrator1.0.0+pg18
dbt20.61.7+pg18
ddl_historization0.0.7+pg18
ddsketch1.0.1+pg18
decoder_raw1.0+pg18
decoderbufs3.2.0+pg18
emailaddr0+pg18
envvar1.0.1+pg18
faker0.5.3+pg18
financial1.0.1+pg18
fio1.0+pg18
first_last_agg0.1.4+pg18
floatfile1.3.1+pg18
floatvec1.1.1+pg18
geoip0.3.0+pg18
hashlib1.1+pg18
hashtypes0.1.5+pg18
hll2.18+pg18
hunspell_*1.0+pg18
imgsmlr1.0+pg18
index_advisor0.2.0+pg18
kafka_fdw0.0.3+pg18
login_hook1.7+pg18
oracle_fdw2.8.0+pg18
pg_auth_mon3.0+pg18
pg_background1.3+pg18
pg_bigm1.2+pg18
pg_cron1.6.7+pg18
pg_profile4.10+pg18
pg_stat_kcache2.3.0+pg18
pgdd0.6.0+pg18
pgjwt0.2.0+pg18
pgnodemx1.7+pg18
pgsodium3.1.9+pg18
pgtap1.3.3+pg18
plprofiler4.2.5+pg18
plproxy2.11.0+pg18
plr8.4.8+pg18
plv83.2.4+pg18
pointcloud1.2.5+pg18
powa5.0.1+pg18
prefix1.2.10+pg18
q3c2.0.1+pg18
redis_fdw1.0+pg18
session_variable3.4+pg18
set_user4.1.0+pg18
system_stats3.2+pg18
temporal_tables1.2.2+pg18
topn2.7.0+pg18
unit7.10+pg18
zhparser2.3+pg18
zstd1.1.2+pg18

2025-09-04

名称旧版本新版本备注
timesacledb2.21.12.22.0
citus13.1.013.2.0
documentdb0.105.00.106.0work with ferretdb 2.5
ddlx0.290.30+ pg18
icu_ext1.9.01.10.0+ pg18
asn1oid1.51.6+ pg18
uint1281.0.01.1.0+ pg18
toastinfo1.51.6+ 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 (PGDG)
pg_tracing-0.1.3-2+ pg 14/18
pg_curl2.42.4.5new version epoch
pg_rewrite-2.0.0Import from PGDG
pg_tracing-1.3.0+ pg14 / pg18
pgactive2.1.52.1.6+ pg18
sentinel1.11.21.2
pg_tle1.5.1-11.5.1-2+ pg18
redis_fdw+ pg18
pgextwlist1.171.19+ pg18
wal2json1.6+ pg18
pgvector0.8.1+ pg18

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 依赖问题

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
orioledb1.4.0b101.4.0b11

2025-05-22

名称旧版本新版本备注
openhalodb-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
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_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)