Pigsty Extension Catalog

Extensions are the soul of PostgreSQL. Pigsty builds, collects, and integrates 464 PG ecosystem extensions for out-of-the-box use.

Pigsty provides the following three pieces of infrastructure to help users harness the collaborative superpowers of the PostgreSQL extension ecosystem:

Extension Catalog: Browse detailed information, usage, metadata, download links and docs for 464 extensions
Extension Repository: Get pre-built RPM/DEB binary packages, available on 14 Linux systems
Package Manager: Use the pig CLI tool to abstract away OS and architecture differences

curl -fsSL https://repo.pigsty.io/pig | bash   # Install pig CLI tool
pig repo add pigsty pgdg -u                    # Configure repos on your Linux distro
pig install pg18                               # Install PostgreSQL 18 kernel from PGDG
pig install pg_duckdb -v 18                    # e.g., install pg_duckdb for PG 18

Everything can be solved with PostgreSQL! Check out our blog post: PostgreSQL is eating the database world!

Key Features

Quantity: Unparalleled extension count: 464 available extensions, the most in the PG extension ecosystem
Quality: Native Linux RPM/DEB packages, fully compatible with PGDG packaging standards
Ease of Use: Provides the pig package manager, abstracting away OS and architecture differences for out-of-the-box use
Compatibility: Extensions are fully compatible with PGDG packaging standards, seamlessly usable with PGDG repositories
Distribution: Global repository distribution via Cloudflare CDN
Open Source: Fully open source, with convenient build tools and free public software infrastructure

Extension Statistics

Type	All	PGDG	PIGSTY	CONTRIB	PG18	PG17	PG16	PG15	PG14
ALL	464	162	283	71	441	450	441	437	425
EL	458	129	258	71	431	443	435	431	419
Debian	449	107	271	71	426	436	426	422	410

See: Extension List, RPM List, DEB List, Repository

Extension Categories

Type	Package
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_eviltransform` `pg_geohash` `mobilitydb` `pg_tzf`
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` `pg_pinyin` `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`
OLAP	`citus` `hydra` `pg_analytics` `pg_duckdb` `pg_mooncake` `pg_clickhouse` `duckdb_fdw` `pg_parquet` `pg_fkpart` `pg_partman` `plproxy` `pg_strom`
FEAT	`age` `hll` `rum` `pg_ai_query` `pg_ttl_index` `pg_graphql` `pg_jsonschema` `jsquery` `pg_hint_plan` `hypopg` `index_advisor` `pg_plan_filter` `imgsmlr` `pg_ivm` `pg_incremental` `pgmb` `pgmq` `pgq` `orioledb` `pg_cardano` `rdkit` `omnigres`
LANG	`pg_tle` `plv8` `pljs` `pllua` `plprql` `pldebugger` `plpgsql_check` `plprofiler` `plsh` `pljava` `plr` `plxslt` `pgtap` `faker` `dbt2`
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`
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` `snowflake` `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`
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_qos` `pg_savior` `safeupdate` `pg_strict` `pg_drop_events` `table_log` `pgagent` `pgpool`
STAT	`pg_profile` `pg_tracing` `pg_show_plans` `pg_stat_kcache` `pg_stat_monitor` `pg_qualstats` `pg_store_plans` `pg_track_settings` `pg_track_optimizer` `pg_wait_sampling` `pgsentinel` `system_stats` `pg_meta` `pgnodemx` `pg_sqlog` `bgw_replstatus` `pgmeminfo` `toastinfo` `pg_explain_ui` `pg_relusage` `pagevis` `powa`
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` `pg_pwhash` `login_hook` `set_user` `pg_snakeoil` `pgextwlist` `sslutils` `pg_noset` `pg_tde`
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` `pg_redis_pubsub` `kafka_fdw` `hdfs_fdw` `firebird_fdw` `aws_s3` `log_fdw`
SIM	`documentdb` `orafce` `pgtt` `session_variable` `pg_statement_rollback` `ivorysql` `pg_dbms_metadata` `pg_dbms_lock` `pg_dbms_job` `pg_dbms_errlog` `pg_utl_smtp` `babelfish` `spat` `pgmemcache` `openhalo`
ETL	`pglogical` `pglogical_ticker` `pgl_ddl_deploy` `pg_failover_slots` `db_migrator` `pgactive` `spock` `lolor` `wal2json` `wal2mongo` `decoderbufs` `decoder_raw` `mimeo` `repmgr` `pg_fact_loader` `pg_bulkload`

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

Compatible Systems

System	Version	x86_64	aarch64	PG Ver
`RockyLinux 8`	`8`	`el8.x86_64`	`el8.aarch64`	1817161514
`RockyLinux 9`	`9`	`el9.x86_64`	`el9.aarch64`	1817161514
`RockyLinux 10`	`10`	`el10.x86_64`	`el10.aarch64`	1817161514
`Debian 12`	`12`	`d12.x86_64`	`d12.aarch64`	1817161514
`Debian 13`	`13`	`d13.x86_64`	`d13.aarch64`	1817161514
`Ubuntu 22.04`	`22.04`	`u22.x86_64`	`u22.aarch64`	1817161514
`Ubuntu 24.04`	`24.04`	`u24.x86_64`	`u24.aarch64`	1817161514

See: Operating System, RPM List, DEB List

Partners

Pigsty provides an unparalleled PostgreSQL extension delivery experience. Several PostgreSQL vendors are using it for delivery.

Pigsty

Out-of-the-box, open-source, enterprise-grade PostgreSQL RDS distribution

Omnigres

PostgreSQL as a Platform, application development inside the database

AutoBase

Ansible-based PG cluster automation deployment, open-source DBaaS

TensorChord

Cloud-native AI infrastructure, developers of several well-known PG extensions

WENWU IT

Enterprise PostgreSQL service provider

About

This project is developed and maintained by PGSTY / VONNG, and is open-sourced under the Apache 2.0 license.

Repository	Description
pgsty	PGSTY organization homepage
pgsty/pgext	This website, extension metadata, and management tools
pgsty/pigsty	PostgreSQL database distribution
pgsty/pig	PostgreSQL package manager
pgsty/rpm	RPM build source code
pgsty/deb	DEB build source code
pgsty/infra-pkg	Infrastructure package repository