PostgreSQL Extension Cloud

PGEXT.CLOUD provides three things to help you harness the synergistic superpower of the PostgreSQL extensions ecosystem:

Catalog : Find the extension you need, with unparalleled 440 extensions included
Repository : Get pre-built RPM/DEB packages on 14 mainstream Linux Distributions
PIG Package Manager : The Missing Package Manager for PostgreSQL & Extension Ecosystem

curl -fsSL https://repo.pigsty.io/pig | bash  # install pig cli
pig repo set                  # setup upstream repository on your linux
pig install pg18              # install PostgreSQL 18 kernel pkg from PGDG
pig install pg_duckdb -v 18   # e.g. install pg_duckdb extension for PG 18

Just use PostgreSQL for everything! Also check our blog post: PostgreSQL is eating the Database World

Highlights

440 Extensions : the largest catalog in the postgres ecosystem
Linux Native : RPM/DEB packages, properly built, freely compose
Handy CLI : pig on apt/dnf, zero‑config installs; out-of-the-box
Compatibility : PGDG‑Compliant, drop‑in with official PG kernel
Fast & Reliable : Distribute via Cloudflare CDN in worldwide
Commitment : Driven by PG experts, with love and commitment
Free & OSS : Reproducible building, Public infra, free for all

Catalog

TIME	GIS	RAG	FTS	OLAP	FEAT	LANG	TYPE
UTIL	FUNC	ADMIN	STAT	SEC	FDW	SIM	ETL

TIME

TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …

GIS

GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…

RAG

Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…

FTS

ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…

OLAP

DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …

FEAT

OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…

LANG

Develop, Test, Package, and Deliver Stored Procedures written in various PL/Languages: Java, Js, Lua, R, Sh, PRQL, …

TYPE

Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…

UTIL

Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…

FUNC

Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…

ADMIN

Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…

STAT

Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…

SEC

Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Error, Extension White List, …

FDW

Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…

SIM

Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!

ETL

Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…

Category	Packages
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 pg_biscuit pg_textsearch 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 pg_clickhouse duckdb_fdw pg_parquet pg_fkpart pg_partman plproxy pg_strom tablefunc
FEAT	age hll rum pg_ai_query 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 pg_retry 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	pg_idkit pgx_ulid pg_uuidv7 permuteseq pg_hashids sequential_uuids pg_typeid topn quantile lower_quantile count_distinct omnisketch ddsketch vasco pgxicor pg_weighted_statistics 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 pglinter 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 pgsmcrypto pg_enigma pgaudit pgauditlogtofile pg_auditor logerrors pg_auth_mon pg_jobmon credcheck pgcryptokey login_hook set_user pg_snakeoil pgextwlist sslutils pg_noset pg_tde 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

Platform

Pigsty provides complete extension support on these linux distributions major versions::

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

Users

The PGSTY.CLOUD is used by some PostgreSQL Distribution Maker and Vendors to deliver PG extensions to their users and customers.

About

The PGEXT.CLOUD is maintained by PGSTY / VONNG ([email protected]), and open-sourced under the Apache License 2.0.

GitHub Repo	Description
github.com/pgsty	The PGSTY Organization
github.com/pgsty/pgext	This website and extension Data
github.com/pgsty/pigsty	PostgreSQL Database Distribution
github.com/pgsty/pig	PostgreSQL Package Manager
github.com/pgsty/rpm	RPM Building Specs
github.com/pgsty/deb	DEB Building Specs
github.com/pgsty/infra-pkg	Infra Package Building Specs