PostgreSQL 扩展云

PG 扩展云(PGEXT.CLOUD)提供了以下三样基础设施,帮助用户更好的利用 PostgreSQL 扩展生态系统的协同超能力:

只需几行命令,即可在 主流 Linux 系统 上原生安装多达 431 个 PostgreSQL 扩展,组合使用,发挥 PostgreSQL 的超能力:

curl -fsSL https://repo.pigsty.io/pig | bash  # 安装 pig 命令行工具
pig repo set                                  # 在您的 Linux 发行版上配置软件仓库
pig install pg18                              # 从 PGDG 官方仓库安装 PostgreSQL 18 内核包
pig install pg_duckdb -v 18                   # 例:针对 PG 18 安装 pg_duckdb

一切都可以用 PostgreSQL 解决!请参阅我们的博客文章:PostgreSQL 正在吞噬数据库世界!

ecosystem

核心特点

  • 数量:无与伦比的扩展数量:431 个可用扩展,为 PG 扩展生态之最。
  • 质量:原生 Linux RPM/DEB 包,同时安装,自由组合使用不同扩展。
  • 易用:提供包管理器 pig,依托 apt / dnf,但开箱即用,简单快捷。
  • 兼容:扩展完全兼容 PGDG 打包规范,可与官方 PG 内核完美配套使用。
  • 分发:由 Cloudflare CDN 进行全球仓库分发,可靠稳定,高速访问。
  • 镜像:提供国内CDN加速,中国境内唯一跟进 PGDG 仓库更新的镜像站。
  • 维护:久经考验的开源维护者,修复过大量扩展问题,由热爱,专业与承诺驱动。
  • 开源:完全开源,提供便利的构建工具,构建流程可轻松复现,确保供应链安全。
  • 免费:免费对公众提供服务的软件基础设施,用爱发电,不收取任何费用。

扩展导航

类别 扩展包
TIME
timescaledb
timescaledb_toolkit
pg_timeseries
periods
temporal_tables
emaj
table_version
pg_cron
pg_task
pg_later
pg_background
GIS
postgis
pgrouting
pointcloud
pg_h3
q3c
ogr_fdw
geoip
pg_polyline
pg_geohash
mobilitydb
pg_tzf
earthdistance
RAG
pgvector
vchord
pgvectorscale
pg_vectorize
pg_similarity
smlar
pg_summarize
pg_tiktoken
pg4ml
pgml
FTS
pg_search
pgroonga
pg_bigm
zhparser
pg_bestmatch
vchord_bm25
pg_tokenizer
hunspell_cs_cz
hunspell_de_de
hunspell_en_us
hunspell_fr
hunspell_ne_np
hunspell_nl_nl
hunspell_nn_no
hunspell_pt_pt
hunspell_ru_ru
hunspell_ru_ru_aot
fuzzystrmatch
pg_trgm
OLAP
citus
hydra
pg_analytics
pg_duckdb
pg_mooncake
duckdb_fdw
pg_parquet
pg_fkpart
pg_partman
plproxy
pg_strom
tablefunc
FEAT
age
hll
rum
pg_graphql
pg_jsonschema
jsquery
pg_hint_plan
hypopg
index_advisor
pg_plan_filter
imgsmlr
pg_ivm
pg_incremental
pgmq
pgq
orioledb
pg_cardano
rdkit
omnigres
bloom
LANG
pg_tle
plv8
pljs
pllua
plprql
pldebugger
plpgsql_check
plprofiler
plsh
pljava
plr
plxslt
pgtap
faker
dbt2
pltcl
plperl
plperlu
plpgsql
plpython3u
TYPE
pg_prefix
pg_semver
pgunit
pgpdf
pglite_fusion
md5hash
asn1oid
pg_roaringbitmap
pgfaceting
pgsphere
pg_country
pg_xenophile
pg_currency
pgcollection
pgmp
numeral
pg_rational
pguint
pg_uint128
hashtypes
ip4r
pg_duration
pg_uri
pg_emailaddr
pg_acl
debversion
pg_rrule
timestamp9
chkpass
isn
seg
cube
ltree
hstore
citext
xml2
UTIL
pg_gzip
pg_bzip
pg_zstd
pg_http
pg_net
pg_curl
pgjq
pgjwt
pg_smtp_client
pg_html5_email_address
url_encode
pgsql_tweaks
pg_extra_time
pgpcre
icu_ext
pgqr
pg_protobuf
pg_envvar
floatfile
pg_render
pg_readme
ddl_historization
data_historization
pg_schedoc
pg_hashlib
pg_xxhash
shacrypt
cryptint
pg_ecdsa
pgsparql
FUNC
omnisketch
pg_idkit
pgx_ulid
pg_uuidv7
permuteseq
pg_hashids
sequential_uuids
topn
quantile
lower_quantile
count_distinct
ddsketch
vasco
pgxicor
tdigest
first_last_agg
extra_window_functions
floatvec
aggs_for_vecs
aggs_for_arrays
pg_csv
pg_arraymath
pg_math
pg_random
pg_base36
pg_base62
pg_base58
pg_financial
pg_convert
refint
autoinc
insert_username
moddatetime
tsm_system_time
dict_xsyn
tsm_system_rows
tcn
uuid-ossp
btree_gist
btree_gin
intarray
intagg
dict_int
unaccent
ADMIN
pg_repack
pg_rewrite
pg_squeeze
pg_dirtyread
pgfincore
pg_cooldown
pg_ddlx
pg_prioritize
pg_checksums
pg_readonly
pgdd
pg_permissions
pgautofailover
pg_catcheck
preprepare
pg_upless
pgcozy
pg_orphaned
pg_crash
pg_cheat_funcs
pg_fio
pg_savior
safeupdate
pg_drop_events
table_log
pgagent
pg_prewarm
pgpool
lo
basic_archive
basebackup_to_shell
old_snapshot
adminpack
amcheck
pg_surgery
STAT
pg_profile
pg_tracing
pg_show_plans
pg_stat_kcache
pg_stat_monitor
pg_qualstats
pg_store_plans
pg_track_settings
pg_wait_sampling
pgsentinel
system_stats
pg_meta
pgnodemx
pg_sqlog
bgw_replstatus
pgmeminfo
toastinfo
pg_explain_ui
pg_relusage
pagevis
powa
pg_overexplain
pg_logicalinspect
pageinspect
pgrowlocks
sslinfo
pg_buffercache
pg_walinspect
pg_freespacemap
pg_visibility
pgstattuple
auto_explain
pg_stat_statements
SEC
passwordcheck_cracklib
supautils
pgsodium
pg_vault
pg_session_jwt
pg_anon
pg_tde
pgsmcrypto
pgaudit
pgauditlogtofile
pg_auth_mon
credcheck
pgcryptokey
pg_jobmon
logerrors
login_hook
set_user
pg_snakeoil
pgextwlist
pg_auditor
sslutils
pg_noset
sepgsql
auth_delay
pgcrypto
passwordcheck
FDW
wrappers
multicorn
odbc_fdw
jdbc_fdw
pgspider_ext
mysql_fdw
oracle_fdw
tds_fdw
db2_fdw
sqlite_fdw
pgbouncer_fdw
mongo_fdw
redis_fdw
pg_redis_pubsub
kafka_fdw
hdfs_fdw
firebird_fdw
aws_s3
log_fdw
dblink
file_fdw
postgres_fdw
SIM
documentdb
orafce
pgtt
session_variable
pg_statement_rollback
pg_dbms_metadata
pg_dbms_lock
pg_dbms_job
pg_dbms_errlog
babelfishpg_common
babelfishpg_tsql
babelfishpg_tds
babelfishpg_money
spat
pgmemcache
ETL
pglogical
pglogical_ticker
pgl_ddl_deploy
pg_failover_slots
db_migrator
pgactive
wal2json
wal2mongo
decoderbufs
decoder_raw
mimeo
repmgr
pg_fact_loader
pg_bulkload
test_decoding
pgoutput
MIT
ISC
PostgreSQL
BSD 0-Clause
BSD 2-Clause
BSD 3-Clause
Artistic
Apache-2.0
MPL-2.0
GPL-2.0
GPL-3.0
LGPL-2.1
LGPL-3.0
AGPL-3.0
Timescale
C
C++
Rust
Java
Python
SQL
Data

用户

PGSTY.CLOUD 向用户提供无可比拟的扩展交付体验,一些 PostgreSQL 厂商使用本仓库进行交付:

兼容系统

OS Vendor Major Minor Fullname PG Major Version Comment
el8.x86_64
EL 8 8.10 RockyLinux 8 x86
18
17
16
15
14
13
Near EOL
el8.aarch64
EL 8 8.10 RockyLinux 8 ARM
18
17
16
15
14
13
Near EOL
el9.x86_64
EL 9 9.6 RockyLinux 9 x86
18
17
16
15
14
13
OK
el9.aarch64
EL 9 9.6 RockyLinux 9 ARM
18
17
16
15
14
13
OK
el10.x86_64
EL 10 10.0 RockyLinux 10 x86
18
17
16
15
14
13
OK
el10.aarch64
EL 10 10.0 RockyLinux 10 ARM
18
17
16
15
14
13
OK
d12.x86_64
Debian 12 12.12 Debian 12 x86
18
17
16
15
14
13
OK
d12.aarch64
Debian 12 12.12 Debian 12 ARM
18
17
16
15
14
13
OK
d13.x86_64
Debian 13 13.1 Debian 13 x86
18
17
16
15
14
13
OK
d13.aarch64
Debian 13 13.1 Debian 13 ARM
18
17
16
15
14
13
OK
u22.x86_64
Ubuntu 22 22.04.5 Ubuntu 22.04 x86
18
17
16
15
14
13
OK
u22.aarch64
Ubuntu 22 22.04.5 Ubuntu 22.04 ARM
18
17
16
15
14
13
OK
u24.x86_64
Ubuntu 24 24.04.3 Ubuntu 24.04 x86
18
17
16
15
14
13
OK
u24.aarch64
Ubuntu 24 24.04.3 Ubuntu 24.04 ARM
18
17
16
15
14
13
OK

关于

PGEXT.CLOUD 项目由 PGSTY / VONNG ([email protected]) 开发维护,并使用 Apache 2.0 许可证开源。

GitHub 仓库 说明
github.com/pgsty PGSTY 组织主页
github.com/pgsty/pgext 本网站,扩展元数据,以及管理工具
github.com/pgsty/pigsty PostgreSQL 数据库发行版
github.com/pgsty/pig PostgreSQL 包管理器
github.com/pgsty/ext 本文档,扩展目录
github.com/pgsty/rpm RPM 构建源代码
github.com/pgsty/deb DEB 构建源代码
github.com/pgsty/infra-pkg 基础设施包仓库
Last updated on