Version v3.7.0 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

Extension

Harness the synergistic power of PostgreSQL extensions

Pigsty allows you to harness the synergistic superpower of the Postgres extensions ecosystem with 3 things: Catalog, Repo, and pig.

Extension Catalog

    The complete list of <span class="text-lg font-black text-emerald-500">437</span> available PostgreSQL extensions

Software Repository

    The APT/YUM repo that deliver PostgreSQL extensions

Package Manger

    The missing package manager for PostgreSQL & Extensions

Quick Start

    How to get, install, config, manage these extensions?

There are 437 PostgreSQL extensions in the v3.7.0 catalog. PostgreSQL 18 is the default in v3.7.0.

The per-major figures below are the archive’s PG13–17 compatibility snapshot; the final PG18 breakdown was not recorded in this table. Use the v3.7.0 package aliases and release note for PG18.

Distro	All	PGDG	PIGSTY	CONTRIB	OTHER	MISS	PG17	PG16	PG15	PG14	PG13
EL	417	119	227	71	0	6	399	407	410	394	368
Debian	410	103	236	71	0	13	397	400	403	391	363

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

MIT ISC PostgreSQL BSD-0 BSD-2 BSD-3 Artistic Apache-2.0 MPL-2.0 GPL-2.0 GPL-3.0 LGPL-2.1 LGPL-3.0 AGPL-3.0 Timescale

Usage

Package

    Download and install extensions with package alias

Download

    Download Extensions from PGDG / Pigsty Repo

Install

    Install Postgres Extension Packages

Config

    Configure extensions and setup pre-loading

Download

    Download Extensions from PGDG / Pigsty Repo

Install

    Install Postgres Extension Packages

Config

    Configure extensions and setup pre-loading

Create

    CREATE Postgres Extension in Database

Update

    Upgrade Postgres Extension

Remove

    Uninstall Postgres Extension

Index

Category	Extensions
TIME	`emaj` `periods` `pg_background` `pg_cron` `pg_later` `pg_task` `table_version` `temporal_tables` `timescaledb` `timescaledb_toolkit` `timeseries`
GIS	`address_standardizer` `address_standardizer_data_us` `earthdistance` `geoip` `h3` `h3_postgis` `mobilitydb` `ogr_fdw` `pg_geohash` `pg_polyline` `pgrouting` `pointcloud` `pointcloud_postgis` `postgis` `postgis_raster` `postgis_sfcgal` `postgis_tiger_geocoder` `postgis_topology` `q3c` `tzf`
RAG	`pg4ml` `pg_similarity` `pg_summarize` `pg_tiktoken` `pgml` `smlar` `vchord` `vector` `vectorize` `vectorscale`
FTS	`fuzzystrmatch` `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` `pg_bestmatch` `pg_bigm` `pg_search` `pg_tokenizer` `pg_trgm` `pgroonga` `pgroonga_database` `vchord_bm25` `zhparser`
OLAP	`citus` `citus_columnar` `columnar` `duckdb_fdw` `pg_analytics` `pg_duckdb` `pg_fkpart` `pg_mooncake` `pg_parquet` `pg_partman` `pg_strom` `plproxy` `tablefunc`
FEAT	`age` `bloom` `hll` `hypopg` `imgsmlr` `index_advisor` `jsquery` `omni` `omni_auth` `omni_aws` `omni_cloudevents` `omni_containers` `omni_credentials` `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_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` `orioledb` `pg_cardano` `pg_graphql` `pg_hint_plan` `pg_incremental` `pg_ivm` `pg_jsonschema` `pgmq` `pgq` `plan_filter` `rdkit` `rum`
LANG	`bool_plperl` `bool_plperlu` `dbt2` `faker` `hstore_pllua` `hstore_plluau` `hstore_plperl` `hstore_plperlu` `hstore_plpython3u` `jsonb_plperl` `jsonb_plperlu` `jsonb_plpython3u` `ltree_plpython3u` `pg_tle` `pgtap` `pldbgapi` `pljava` `pllua` `plluau` `plperl` `plperlu` `plpgsql` `plpgsql_check` `plprofiler` `plprql` `plpython3u` `plr` `plsh` `pltcl` `pltclu` `plv8`
TYPE	`acl` `asn1oid` `chkpass` `citext` `collection` `country` `cube` `currency` `debversion` `emailaddr` `hashtypes` `hstore` `ip4r` `isn` `l10n_table_dependent_extension` `ltree` `md5hash` `numeral` `pg_duration` `pg_rational` `pg_rrule` `pg_sphere` `pg_xenophile` `pgfaceting` `pglite_fusion` `pgmp` `pgpdf` `prefix` `roaringbitmap` `seg` `semver` `timestamp9` `uint` `uint128` `unit` `uri` `xml2`
UTIL	`bzip` `cryptint` `data_historization` `ddl_historization` `envvar` `floatfile` `gzip` `hashlib` `http` `icu_ext` `pg_curl` `pg_extra_time` `pg_html5_email_address` `pg_net` `pg_protobuf` `pg_readme` `pg_readme_test_extension` `pg_render` `pg_smtp_client` `pgjq` `pgjwt` `pgpcre` `pgqr` `pgsql_tweaks` `pguecc` `schedoc` `shacrypt` `sparql` `url_encode` `xxhash` `zstd`
FUNC	`aggs_for_arrays` `aggs_for_vecs` `arraymath` `autoinc` `base36` `base62` `btree_gin` `btree_gist` `convert` `count_distinct` `ddsketch` `dict_int` `dict_xsyn` `extra_window_functions` `financial` `first_last_agg` `floatvec` `insert_username` `intagg` `intarray` `lower_quantile` `moddatetime` `omnisketch` `permuteseq` `pg_base58` `pg_hashids` `pg_idkit` `pg_math` `pg_uuidv7` `pgx_ulid` `quantile` `random` `refint` `sequential_uuids` `tcn` `tdigest` `topn` `tsm_system_rows` `tsm_system_time` `unaccent` `uuid-ossp` `vasco` `xicor`
ADMIN	`adminpack` `amcheck` `basebackup_to_shell` `basic_archive` `ddlx` `fio` `lo` `old_snapshot` `pg_catcheck` `pg_cheat_funcs` `pg_checksums` `pg_cooldown` `pg_crash` `pg_dirtyread` `pg_drop_events` `pg_orphaned` `pg_permissions` `pg_prewarm` `pg_readonly` `pg_repack` `pg_savior` `pg_squeeze` `pg_surgery` `pg_upless` `pgagent` `pgautofailover` `pgcozy` `pgdd` `pgfincore` `pgpool_adm` `pgpool_recovery` `pgpool_regclass` `pre_prepare` `prioritize` `safeupdate` `table_log`
STAT	`auto_explain` `bgw_replstatus` `explain_ui` `meta` `pageinspect` `pagevis` `pg_buffercache` `pg_freespacemap` `pg_logicalinspect` `pg_overexplain` `pg_proctab` `pg_profile` `pg_qualstats` `pg_relusage` `pg_show_plans` `pg_sqlog` `pg_stat_kcache` `pg_stat_monitor` `pg_stat_statements` `pg_store_plans` `pg_tracing` `pg_track_settings` `pg_visibility` `pg_wait_sampling` `pg_walinspect` `pgmeminfo` `pgnodemx` `pgrowlocks` `pgsentinel` `pgstattuple` `powa` `sslinfo` `system_stats` `toastinfo`
SEC	`anon` `auth_delay` `credcheck` `logerrors` `login_hook` `noset` `passwordcheck` `passwordcheck_cracklib` `pg_auditor` `pg_auth_mon` `pg_jobmon` `pg_session_jwt` `pg_snakeoil` `pg_tde` `pgaudit` `pgauditlogtofile` `pgcrypto` `pgcryptokey` `pgextwlist` `pgsmcrypto` `pgsodium` `sepgsql` `set_user` `sslutils` `supabase_vault` `supautils`
FDW	`aws_s3` `db2_fdw` `dblink` `file_fdw` `firebird_fdw` `hdfs_fdw` `jdbc_fdw` `kafka_fdw` `log_fdw` `mongo_fdw` `multicorn` `mysql_fdw` `odbc_fdw` `oracle_fdw` `pgbouncer_fdw` `pgspider_ext` `postgres_fdw` `redis` `redis_fdw` `sqlite_fdw` `tds_fdw` `wrappers`
SIM	`babelfishpg_common` `babelfishpg_money` `babelfishpg_tds` `babelfishpg_tsql` `documentdb` `documentdb_core` `documentdb_distributed` `orafce` `pg_dbms_job` `pg_dbms_lock` `pg_dbms_metadata` `pg_statement_rollback` `pgmemcache` `pgtt` `session_variable` `spat`
ETL	`db_migrator` `decoder_raw` `decoderbufs` `mimeo` `pg_bulkload` `pg_fact_loader` `pg_failover_slots` `pgactive` `pgl_ddl_deploy` `pglogical` `pglogical_origin` `pglogical_ticker` `pgoutput` `repmgr` `test_decoding` `wal2json` `wal2mongo`

Quick Start

Install, Load, create, update PostgreSQL extensions

Package

Extension Packages and Alias

Download

Download PostgreSQL Extension

Install

Install PostgreSQL Extension

Config

Preload extensions and configure extension parameters

Create

Create & Enable PostgreSQL Extension

Update

How to update PostgreSQL extensions to newer versions

Remove

How to remove PostgreSQL extensions