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 向用户提供无可比拟的扩展交付体验,以下是一些使用本仓库向他们的用户与客户交付 PG 扩展的 PostgreSQL 厂商:

兼容系统

OSVendorMajorMinorFullnamePG Major VersionComment
el8.x86_64
EL88.10RockyLinux 8 x86
18
17
16
15
14
13
Near EOL
el8.aarch64
EL88.10RockyLinux 8 ARM
18
17
16
15
14
13
Near EOL
el9.x86_64
EL99.6RockyLinux 9 x86
18
17
16
15
14
13
OK
el9.aarch64
EL99.6RockyLinux 9 ARM
18
17
16
15
14
13
OK
el10.x86_64
EL1010.0RockyLinux 10 x86
18
17
16
15
14
13
OK
el10.aarch64
EL1010.0RockyLinux 10 ARM
18
17
16
15
14
13
OK
d12.x86_64
Debian1212.12Debian 12 x86
18
17
16
15
14
13
OK
d12.aarch64
Debian1212.12Debian 12 ARM
18
17
16
15
14
13
OK
d13.x86_64
Debian1313.1Debian 13 x86
18
17
16
15
14
13
OK
d13.aarch64
Debian1313.1Debian 13 ARM
18
17
16
15
14
13
OK
u22.x86_64
Ubuntu2222.04.5Ubuntu 22.04 x86
18
17
16
15
14
13
OK
u22.aarch64
Ubuntu2222.04.5Ubuntu 22.04 ARM
18
17
16
15
14
13
OK
u24.x86_64
Ubuntu2424.04.3Ubuntu 24.04 x86
18
17
16
15
14
13
OK
u24.aarch64
Ubuntu2424.04.3Ubuntu 24.04 ARM
18
17
16
15
14
13
OK

关于

PGEXT.CLOUD 项目由 PGSTY / VONNG (rh@vonng.com) 开发维护,并使用 Apache 2.0 许可证开源。

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