Skip to content

PostgreSQL 扩展云

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

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

curl -fsSL https://repo.pigsty.cc/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

核心特点

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

扩展导航

类别 扩展
ADMIN
pg_repack
pg_rewrite
pg_query_rewrite
pg_squeeze
pg_dirtyread
pgfincore
pg_cooldown
ddlx
pglinter
prioritize
pg_checksums
pg_readonly
pgdd
pg_permissions
pgautofailover
pg_catcheck
pre_prepare
pg_upless
pgcozy
pg_orphaned
pg_crash
pg_cheat_funcs
fio
qos
pg_savior
safeupdate
pg_strict
pg_drop_events
table_log
pgelog
pgagent
pg_prewarm
pgpool_adm
pgpool_recovery
pgpool_regclass
lo
basic_archive
basebackup_to_shell
old_snapshot
adminpack
amcheck
pg_surgery
ETL
pglogical
pglogical_origin
pglogical_ticker
pgl_ddl_deploy
logical_ddl
pg_failover_slots
db_migrator
pgactive
spock
lolor
pgclone
pgmqtt
wal2json
wal2mongo
decoderbufs
decoder_raw
mimeo
repmgr
pg_fact_loader
pg_bulkload
test_decoding
pgoutput
FDW
wrappers
multicorn
odbc_fdw
jdbc_fdw
pgspider_ext
mysql_fdw
oracle_fdw
tds_fdw
db2_fdw
sqlite_fdw
pgbouncer_fdw
etcd_fdw
informix_fdw
nominatim_fdw
mongo_fdw
redis_fdw
redis
kafka_fdw
hdfs_fdw
firebird_fdw
rdf_fdw
aws_s3
log_fdw
dblink
file_fdw
postgres_fdw
FEAT
age
pg_liquid
onesparse
pgq
pgmq
pgmb
ulak
hll
rum
pg_ai_query
pg_ttl_index
pg_graphql
pg_jsonschema
jsquery
pg_hint_plan
hypopg
index_advisor
plan_filter
pg_variables
imgsmlr
pg_ivm
pg_incremental
pg_trickle
provsql
orioledb
pg_cardano
rdkit
omni
omni_auth
omni_aws
omni_cloudevents
omni_containers
omni_credentials
omni_csv
omni_datasets
omni_email
omni_http
omni_httpc
omni_httpd
omni_id
omni_json
omni_kube
omni_ledger
omni_manifest
omni_mimetypes
omni_os
omni_polyfill
omni_python
omni_regex
omni_rest
omni_schema
omni_seq
omni_service
omni_session
omni_shmem
omni_sql
omni_sqlite
omni_test
omni_txn
omni_types
omni_var
omni_vfs
omni_vfs_types_v1
omni_web
omni_worker
omni_xml
omni_yaml
bloom
FTS
pg_search
pgroonga
pgroonga_database
pg_bigm
zhparser
pg_bestmatch
vchord_bm25
pg_tokenizer
biscuit
pg_textsearch
pg_pinyin
pg_kazsearch
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
FUNC
pg_idkit
pgx_ulid
pg_uuidv7
permuteseq
pg_hashids
pg_slug_gen
sequential_uuids
typeid
snowflake
topn
quantile
lower_quantile
count_distinct
omnisketch
ddsketch
vasco
xicor
weighted_statistics
datasketches
tdigest
first_last_agg
extra_window_functions
floatvec
aggs_for_vecs
aggs_for_arrays
pg_csv
arraymath
pg_math
random
base36
base62
pg_base58
financial
convert
parray_gin
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
GIS
postgis
postgis_topology
postgis_raster
postgis_sfcgal
postgis_tiger_geocoder
address_standardizer
address_standardizer_data_us
pgrouting
pointcloud
pointcloud_postgis
h3
h3_postgis
q3c
ogr_fdw
geoip
pg_polyline
pg_eviltransform
pg_geohash
pghydro
pgh_raster
pgh_hgm
pgh_output
pgh_output_en_au
pgh_output_pt_br
pgh_consistency
mobilitydb
mobilitydb_datagen
tzf
earthdistance
LANG
pg_tle
plv8
pljs
pllua
hstore_pllua
plluau
hstore_plluau
plprql
pldbgapi
plpgsql_check
plprofiler
plsh
pljava
plr
plxslt
pgtap
faker
dbt2
pg_regresql
pltcl
pltclu
plperl
bool_plperl
hstore_plperl
jsonb_plperl
plperlu
bool_plperlu
jsonb_plperlu
hstore_plperlu
plpgsql
plpython3u
jsonb_plpython3u
ltree_plpython3u
hstore_plpython3u
OLAP
citus
citus_columnar
columnar
pg_analytics
pg_duckdb
pg_mooncake
storage_engine
pg_clickhouse
duckdb_fdw
pg_parquet
pg_fkpart
pg_partman
plproxy
pg_strom
tablefunc
RAG
vector
vchord
vectorscale
vectorize
pg_similarity
pg_rrf
smlar
pg_summarize
pg_tiktoken
pg4ml
pgml
SEC
passwordcheck_cracklib
supautils
pgsodium
column_encrypt
supabase_vault
pg_session_jwt
anon
pgsmcrypto
pg_enigma
pgaudit
pgauditlogtofile
pg_auditor
logerrors
pg_auth_mon
pg_jobmon
credcheck
pgcryptokey
pg_pwhash
login_hook
set_user
pg_snakeoil
pgextwlist
pg_command_fw
block_copy_command
sslutils
noset
pg_tde
sepgsql
auth_delay
pgcrypto
passwordcheck
SIM
documentdb
documentdb_core
documentdb_distributed
documentdb_extended_rum
orafce
pgtt
session_variable
pg_statement_rollback
ivorysql_ora
ora_btree_gin
ora_btree_gist
pg_get_functiondef
plisql
gb18030_2022
pg_dbms_metadata
pg_dbms_lock
pg_dbms_job
pg_dbms_errlog
pg_utl_smtp
babelfishpg_common
babelfishpg_tsql
babelfishpg_tds
babelfishpg_money
spat
pgmemcache
aux_mysql
STAT
pg_profile
pg_tracing
pg_stat_ch
pg_show_plans
pg_stat_kcache
pg_stat_monitor
pg_qualstats
pg_store_plans
pg_track_settings
pg_track_optimizer
pg_wait_sampling
pg_datasentinel
pgsentinel
system_stats
meta
pgnodemx
pg_proctab
pg_sqlog
bgw_replstatus
pgmeminfo
toastinfo
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
TIME
timescaledb
timescaledb_toolkit
timeseries
periods
temporal_tables
emaj
table_version
pg_cron
pg_task
pg_later
pg_dispatch
pg_background
pg_when
TYPE
prefix
semver
pg_text_semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap
pgfaceting
pg_sphere
country
pg_xenophile
l10n_table_dependent_extension
currency
collection
pgmp
numeral
pg_rational
uint
uint128
hashtypes
ip4r
pg_duration
uri
emailaddr
acl
debversion
pg_rrule
pgcalendar
timestamp9
pgbson
chkpass
isn
seg
cube
ltree
hstore
citext
xml2
UTIL
gzip
bzip
zstd
http
pg_net
pg_curl
pg_retry
pg_fsql
pg_protobuf
pgproto
pglock
pgjq
pgjwt
pg_smtp_client
pg_html5_email_address
url_encode
pgsql_tweaks
pg_extra_time
pgpcre
re2
icu_ext
pgqr
envvar
byteamagic
floatfile
external_file
pg_render
pg_readme
pg_readme_test_extension
ddl_historization
data_historization
schedoc
pg_isok
hashlib
xxhash
shacrypt
cryptint
pguecc
sparql
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 厂商:

兼容系统

OS Vendor Major Minor Fullname PG Major Version Comment
el8.x86_64
EL 8 8.10 RockyLinux 8 x86
18
17
16
15
14
Near EOL
el8.aarch64
EL 8 8.10 RockyLinux 8 ARM
18
17
16
15
14
Near EOL
el9.x86_64
EL 9 9.7 RockyLinux 9 x86
18
17
16
15
14
OK
el9.aarch64
EL 9 9.7 RockyLinux 9 ARM
18
17
16
15
14
OK
el10.x86_64
EL 10 10.1 RockyLinux 10 x86
18
17
16
15
14
OK
el10.aarch64
EL 10 10.1 RockyLinux 10 ARM
18
17
16
15
14
OK
d12.x86_64
Debian 12 12.13 Debian 12 x86
18
17
16
15
14
OK
d12.aarch64
Debian 12 12.13 Debian 12 ARM
18
17
16
15
14
OK
d13.x86_64
Debian 13 13.3 Debian 13 x86
18
17
16
15
14
OK
d13.aarch64
Debian 13 13.3 Debian 13 ARM
18
17
16
15
14
OK
u22.x86_64
Ubuntu 22 22.04.5 Ubuntu 22.04 x86
18
17
16
15
14
OK
u22.aarch64
Ubuntu 22 22.04.5 Ubuntu 22.04 ARM
18
17
16
15
14
OK
u24.x86_64
Ubuntu 24 24.04.3 Ubuntu 24.04 x86
18
17
16
15
14
OK
u24.aarch64
Ubuntu 24 24.04.3 Ubuntu 24.04 ARM
18
17
16
15
14
OK
u26.x86_64
Ubuntu 26 26.04.0 Ubuntu 26.04 x86
18
17
16
15
14
OK
u26.aarch64
Ubuntu 26 26.04.0 Ubuntu 26.04 ARM
18
17
16
15
14
OK

关于

PGEXT.CLOUD 项目由 PGSTY / VONNG (rh@vonng.com) 开发维护,并使用 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/rpm RPM 构建源代码
github.com/pgsty/deb DEB 构建源代码
github.com/pgsty/infra-pkg 基础设施包仓库
Last updated on