Extension List
List of PostgreSQL extensions supported by Pigsty, and their compatibility on different OS distros.
Module:
Categories:
Pigsty offers a total of 234 available extensions, including 208 on EL systems and 174 on Deb systems.
There are 73 PostgreSQL contrib extensions, leaving 161 additional extensions, of which 20 are compiled and packaged by Pigsty. Non-contrib RPM extensions total 135, of which 35 are unique to EL systems; non-contrib DEB extensions total 101, of which 26 are unique to Deb systems.
Major Extension
RPM Extension List
Currently, the major version PostgreSQL 16 has the following extensions available on EL systems. (Take RockyLinux 8.9 as standard):
There are 208 extensions available on EL systems, including 20 extensions maintained and packaged by Pigsty, 73 PostgreSQL Contrib extensions, and 115 extensions provided by the PGDG official repo. There are 60 extensions that are only available on EL systems.
| Extension | Version | Provider | Category | Description |
|---|---|---|---|---|
| pg_tle | 1.3.4 | PIGSTY | ADMIN | Trusted Language Extensions for PostgreSQL |
| duckdb_fdw | 1.1 | PIGSTY | FDW | DuckDB Foreign Data Wrapper |
| age | 1.5.0 | PIGSTY | FEAT | AGE graph database extension |
| columnar | 11.1-10 | PIGSTY | FEAT | Hydra Columnar extension |
| pg_analytics | 0.5.6 | PIGSTY | FEAT | Real-time analytics for PostgreSQL using columnar storage and vectorized execution |
| pg_bigm | 1.2.0 | PIGSTY | FEAT | create 2-gram (bigram) index for faster full text search. |
| pg_bm25 | 0.5.6 | PIGSTY | FEAT | pg_bm25: Full text search for PostgreSQL using BM25 |
| pg_graphql | 1.5.0 | PIGSTY | FEAT | pg_graphql: GraphQL support |
| pgml | 2.8.1 | PIGSTY | FEAT | PostgresML: Run AL/ML workloads with SQL interface |
| svector | 0.5.6 | PIGSTY | FEAT | pg_sparse: Sparse vector data type and sparse HNSW access methods |
| zhparse | 2.2 | PIGSTY | FEAT | a parser for full-text search of Chinese |
| gzip | 1 | PIGSTY | FUNC | gzip and gunzip functions. |
| http | 1.6 | PIGSTY | FUNC | HTTP client for PostgreSQL, allows web page retrieval inside the database. |
| imgsmlr | 1.0.0 | PIGSTY | FUNC | Image similarity with haar |
| pg_net | 0.8.0 | PIGSTY | FUNC | Async HTTP |
| pg_similarity | 1.0.0 | PIGSTY | FUNC | support similarity queries |
| pgjwt | 0.2.0 | PIGSTY | FUNC | JSON Web Token API for Postgresql |
| supabase_vault | 0.2.9 | PIGSTY | FUNC | Supabase Vault Extension |
| pointcloud | 1.2.5 | PIGSTY | GIS | data type for lidar point clouds |
| roaringbitmap | 0.5 | PIGSTY | TYPE | support for Roaring Bitmaps |
| anon | 1.3.1 | PGDG | ADMIN | Data anonymization tools |
| credcheck | 2.2.0 | PGDG | ADMIN | credcheck - postgresql plain text credential checker |
| login_hook | 1.5 | PGDG | ADMIN | login_hook - hook to execute login_hook.login() at login time |
| pg_background | 1 | PGDG | ADMIN | Run SQL queries in the background |
| pg_bulkload | 3.1.21 | PGDG | ADMIN | pg_bulkload is a high speed data loading utility for PostgreSQL |
| pg_cron | 1.6 | PGDG | ADMIN | Job scheduler for PostgreSQL |
| pg_fact_loader | 2 | PGDG | ADMIN | build fact tables with Postgres |
| pg_jobmon | 1.4.1 | PGDG | ADMIN | Extension for logging and monitoring functions in PostgreSQL |
| pg_readonly | 1.0.0 | PGDG | ADMIN | cluster database read only |
| pg_repack | 1.5.0 | PGDG | ADMIN | Reorganize tables in PostgreSQL databases with minimal locks |
| pg_squeeze | 1.6 | PGDG | ADMIN | A tool to remove unused space from a relation. |
| pgagent | 4.2 | PGDG | ADMIN | A PostgreSQL job scheduler |
| pgautofailover | 2.1 | PGDG | ADMIN | pg_auto_failover |
| pgfincore | 1.3.1 | PGDG | ADMIN | examine and manage the os buffer cache |
| pgl_ddl_deploy | 2.2 | PGDG | ADMIN | automated ddl deployment using pglogical |
| pglogical | 2.4.4 | PGDG | ADMIN | PostgreSQL Logical Replication |
| pglogical_origin | 1.0.0 | PGDG | ADMIN | Dummy extension for compatibility when upgrading from Postgres 9.4 |
| pgpool_adm | 1.5 | PGDG | ADMIN | Administrative functions for pgPool |
| pgpool_recovery | 1.4 | PGDG | ADMIN | recovery functions for pgpool-II for V4.3 |
| pgpool_regclass | 1.0 | PGDG | ADMIN | replacement for regclass |
| prioritize | 1 | PGDG | ADMIN | get and set the priority of PostgreSQL backends |
| repmgr | 5.4 | PGDG | ADMIN | Replication manager for PostgreSQL |
| passwordcracklib | 3.0.0 | PGDG | AUDIT | null |
| pgaudit | 16 | PGDG | AUDIT | provides auditing functionality |
| pgauditlogtofile | 1.5 | PGDG | AUDIT | pgAudit addon to redirect audit log to an independent file |
| pgcryptokey | 1 | PGDG | AUDIT | cryptographic key management |
| set_user | 4.0.1 | PGDG | AUDIT | similar to SET ROLE but with added logging |
| hdfs_fdw | 2.0.5 | PGDG | FDW | foreign-data wrapper for remote hdfs servers |
| mongo_fdw | 1.1 | PGDG | FDW | foreign data wrapper for MongoDB access |
| multicorn | 2.4 | PGDG | FDW | null |
| mysql_fdw | 1.2 | PGDG | FDW | Foreign data wrapper for querying a MySQL server |
| ogr_fdw | 1.1 | PGDG | FDW | foreign-data wrapper for GIS data access |
| pgbouncer_fdw | 1.1.0 | PGDG | FDW | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions |
| sqlite_fdw | 1.1 | PGDG | FDW | SQLite Foreign Data Wrapper |
| tds_fdw | 2.0.3 | PGDG | FDW | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
| decoderbufs | 0.1.0 | PGDG | FEAT | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| emaj | 4.3.1 | PGDG | FEAT | E-Maj extension enables fine-grained write logging and time travel on subsets of the database. |
| jsquery | 1.1 | PGDG | FEAT | data type for jsonb inspection |
| periods | 1.2 | PGDG | FEAT | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| pg_hint_plan | 1.6.0 | PGDG | FEAT | Give PostgreSQL ability to manually force some decisions in execution plans. |
| pg_ivm | 1.7 | PGDG | FEAT | incremental view maintenance on PostgreSQL |
| pgmemcache | 2.3.0 | PGDG | FEAT | memcached interface |
| pgq | 3.5.1 | PGDG | FEAT | Generic queue for PostgreSQL |
| pgsodium | 3.1.9 | PGDG | FEAT | Postgres extension for libsodium functions |
| safeupdate | 1.4 | PGDG | FEAT | Require criteria for UPDATE and DELETE |
| table_version | 1.10.3 | PGDG | FEAT | PostgreSQL table versioning extension |
| temporal_tables | 1.2.2 | PGDG | FEAT | temporal tables |
| timescaledb | 2.14.1 | PGDG | FEAT | Enables scalable inserts and complex queries for time-series data (Apache 2 Edition) |
| vector | 0.6.0 | PGDG | FEAT | vector data type and ivfflat and hnsw access methods |
| wal2json | 2.5.3 | PGDG | FEAT | Changing data capture in JSON format |
| count_distinct | 3.0.1 | PGDG | FUNC | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| dbt2 | 0.45.0 | PGDG | FUNC | OSDL-DBT-2 test kit |
| ddlx | 0.27 | PGDG | FUNC | DDL eXtractor functions |
| extra_window_functions | 1 | PGDG | FUNC | |
| mysqlcompat | 0.0.7 | PGDG | FUNC | null |
| orafce | 4.9 | PGDG | FUNC | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| pg_dbms_job | 1.5.0 | PGDG | FUNC | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
| pg_dbms_lock | 1.0.0 | PGDG | FUNC | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
| pg_extra_time | 1.1.2 | PGDG | FUNC | Some date time functions and operators that, |
| pgsql_tweaks | 0.10.2 | PGDG | FUNC | Some functions and views for daily usage |
| tdigest | 1.4.1 | PGDG | FUNC | Provides tdigest aggregate function. |
| topn | 2.6.0 | PGDG | FUNC | type for top-n JSONB |
| address_standardizer | 3.4.2 | PGDG | GIS | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
| address_standardizer_data_us | 3.4.2 | PGDG | GIS | Address Standardizer US dataset example |
| h3 | 4.1.3 | PGDG | GIS | H3 bindings for PostgreSQL |
| h3_postgis | 4.1.3 | PGDG | GIS | H3 PostGIS integration |
| pgrouting | 3.6.0 | PGDG | GIS | pgRouting Extension |
| pointcloud_postgis | 1.2.5 | PGDG | GIS | integration for pointcloud LIDAR data and PostGIS geometry data |
| postgis | 3.4.2 | PGDG | GIS | PostGIS geometry and geography spatial types and functions |
| postgis_raster | 3.4.2 | PGDG | GIS | PostGIS raster types and functions |
| postgis_sfcgal | 3.4.2 | PGDG | GIS | PostGIS SFCGAL functions |
| postgis_tiger_geocoder | 3.4.2 | PGDG | GIS | PostGIS tiger geocoder and reverse geocoder |
| postgis_topology | 3.4.2 | PGDG | GIS | PostGIS topology spatial types and functions |
| hll | 2.18 | PGDG | INDEX | type for storing hyperloglog data |
| pgtt | 3.1.0 | PGDG | INDEX | Extension to add Global Temporary Tables feature to PostgreSQL |
| rum | 1.3 | PGDG | INDEX | RUM index access method |
| pllua | 2 | PGDG | LANG | Lua as a procedural language |
| plluau | 2 | PGDG | LANG | Lua as an untrusted procedural language |
| plpgsql_check | 2.7 | PGDG | LANG | extended check for plpgsql functions |
| plr | 8.4.6 | PGDG | LANG | load R interpreter and execute R script from within a database |
| plsh | 2 | PGDG | LANG | PL/sh procedural language |
| citus | 12.1-1 | PGDG | SHARD | Distributed PostgreSQL as an extension |
| citus_columnar | 11.3-1 | PGDG | SHARD | Citus columnar storage engine |
| pg_fkpart | 1.7 | PGDG | SHARD | Table partitioning by foreign key utility |
| pg_partman | 5.0.1 | PGDG | SHARD | Extension to manage partitioned tables by time or ID |
| plproxy | 2.10.0 | PGDG | SHARD | Database partitioning implemented as procedural language |
| pg_dbms_metadata | 1.0.0 | PGDG | SIM | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
| hypopg | 1.4.0 | PGDG | STAT | Hypothetical indexes for PostgreSQL |
| logerrors | 2.1 | PGDG | STAT | Function for collecting statistics about messages in logfile |
| pg_auth_mon | 1.1 | PGDG | STAT | monitor connection attempts per user |
| pg_permissions | 1.1 | PGDG | STAT | view object permissions and compare them with the desired state |
| pg_profile | 4.4 | PGDG | STAT | PostgreSQL load profile repository and report builder |
| pg_qualstats | 2.1.0 | PGDG | STAT | An extension collecting statistics about quals |
| pg_stat_kcache | 2.2.3 | PGDG | STAT | Kernel statistics gathering |
| pg_stat_monitor | 2 | PGDG | STAT | The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information. |
| pg_statviz | 0.6 | PGDG | STAT | stats visualization and time series analysis |
| pg_store_plans | 1.7 | PGDG | STAT | track plan statistics of all SQL statements executed |
| pg_track_settings | 2.1.2 | PGDG | STAT | Track settings changes |
| pg_wait_sampling | 1.1 | PGDG | STAT | sampling based statistics of wait events |
| pgexporter_ext | 0.2.3 | PGDG | STAT | pgexporter extension for extra metrics |
| pgmeminfo | 1 | PGDG | STAT | show memory usage |
| pldbgapi | 1.1 | PGDG | STAT | server-side support for debugging PL/pgSQL functions |
| plprofiler | 4.2 | PGDG | STAT | server-side support for profiling PL/pgSQL functions |
| powa | 4.2.2 | PGDG | STAT | PostgreSQL Workload Analyser-core |
| system_stats | 1 | PGDG | STAT | EnterpriseDB system statistics for PostgreSQL |
| faker | 0.5.3 | PGDG | TEST | Wrapper for the Faker Python library |
| geoip | 0.2.4 | PGDG | TYPE | null |
| ip4r | 2.4 | PGDG | TYPE | NULL |
| pg_uuidv7 | 1.4 | PGDG | TYPE | pg_uuidv7: create UUIDv7 values in postgres |
| pgmp | 1.1 | PGDG | TYPE | Multiple Precision Arithmetic extension |
| prefix | 1.2.0 | PGDG | TYPE | Prefix Range module for PostgreSQL |
| semver | 0.32.1 | PGDG | TYPE | Semantic version data type |
| timestamp9 | 1.4.0 | PGDG | TYPE | timestamp nanosecond resolution |
| uint | 0 | PGDG | TYPE | unsigned integer types |
| unit | 7 | PGDG | TYPE | SI units extension |
| adminpack | 2.1 | CONTRIB | ADMIN | administrative functions for PostgreSQL |
| lo | 1.1 | CONTRIB | ADMIN | Large Object maintenance |
| old_snapshot | 1 | CONTRIB | ADMIN | utilities in support of old_snapshot_threshold |
| pg_prewarm | 1.2 | CONTRIB | ADMIN | prewarm relation data |
| pg_surgery | 1 | CONTRIB | ADMIN | extension to perform surgery on a damaged relation |
| auth_delay | null | CONTRIB | CONTRIB | pause briefly before reporting authentication failure |
| auto_explain | null | CONTRIB | CONTRIB | Provides a means for logging execution plans of slow statements automatically |
| basebackup_to_shell | null | CONTRIB | CONTRIB | adds a custom basebackup target called shell |
| basic_archive | null | CONTRIB | CONTRIB | an example of an archive module |
| hstore_plpython | null | CONTRIB | CONTRIB | transform between hstore and plpython |
| jsonb_plpython | null | CONTRIB | CONTRIB | transform between jsonb and plpython |
| ltree_plpython | null | CONTRIB | CONTRIB | transform between ltree and plpython |
| oid2name | null | CONTRIB | CONTRIB | utility program that helps administrators to examine the file structure used by PostgreSQL |
| passwordcheck | null | CONTRIB | CONTRIB | checks user passwords and reject weak password |
| sepgsql | null | CONTRIB | CONTRIB | label-based mandatory access control (MAC) based on SELinux security policy. |
| test_decoding | null | CONTRIB | CONTRIB | SQL-based test/example module for WAL logical decoding |
| vacuumlo | null | CONTRIB | CONTRIB | utility program that will remove any orphaned large objects from a PostgreSQL database |
| dblink | 1.2 | CONTRIB | FDW | connect to other PostgreSQL databases from within a database |
| file_fdw | 1 | CONTRIB | FDW | foreign-data wrapper for flat file access |
| postgres_fdw | 1.1 | CONTRIB | FDW | foreign-data wrapper for remote PostgreSQL servers |
| autoinc | 1 | CONTRIB | FUNC | functions for autoincrementing fields |
| btree_gin | 1.3 | CONTRIB | FUNC | support for indexing common datatypes in GIN |
| btree_gist | 1.7 | CONTRIB | FUNC | support for indexing common datatypes in GiST |
| dict_int | 1 | CONTRIB | FUNC | text search dictionary template for integers |
| dict_xsyn | 1 | CONTRIB | FUNC | text search dictionary template for extended synonym processing |
| earthdistance | 1.1 | CONTRIB | FUNC | calculate great-circle distances on the surface of the Earth |
| fuzzystrmatch | 1.1 | CONTRIB | FUNC | determine similarities and distance between strings |
| insert_username | 1 | CONTRIB | FUNC | functions for tracking who changed a table |
| intagg | 1.1 | CONTRIB | FUNC | integer aggregator and enumerator (obsolete) |
| intarray | 1.5 | CONTRIB | FUNC | functions, operators, and index support for 1-D arrays of integers |
| moddatetime | 1 | CONTRIB | FUNC | functions for tracking last modification time |
| pg_trgm | 1.6 | CONTRIB | FUNC | text similarity measurement and index searching based on trigrams |
| pgcrypto | 1.3 | CONTRIB | FUNC | cryptographic functions |
| refint | 1 | CONTRIB | FUNC | functions for implementing referential integrity (obsolete) |
| tablefunc | 1 | CONTRIB | FUNC | functions that manipulate whole tables, including crosstab |
| tcn | 1 | CONTRIB | FUNC | Triggered change notifications |
| tsm_system_rows | 1 | CONTRIB | FUNC | TABLESAMPLE method which accepts number of rows as a limit |
| tsm_system_time | 1 | CONTRIB | FUNC | TABLESAMPLE method which accepts time in milliseconds as a limit |
| unaccent | 1.1 | CONTRIB | FUNC | text search dictionary that removes accents |
| uuid-ossp | 1.1 | CONTRIB | FUNC | generate universally unique identifiers (UUIDs) |
| amcheck | 1.3 | CONTRIB | INDEX | functions for verifying relation integrity |
| bloom | 1 | CONTRIB | INDEX | bloom access method - signature file based index |
| bool_plperl | 1 | CONTRIB | LANG | transform between bool and plperl |
| bool_plperlu | 1 | CONTRIB | LANG | transform between bool and plperlu |
| hstore_plperl | 1 | CONTRIB | LANG | transform between hstore and plperl |
| hstore_plperlu | 1 | CONTRIB | LANG | transform between hstore and plperlu |
| hstore_plpython3u | 1 | CONTRIB | LANG | transform between hstore and plpython3u |
| jsonb_plperl | 1 | CONTRIB | LANG | transform between jsonb and plperl |
| jsonb_plperlu | 1 | CONTRIB | LANG | transform between jsonb and plperlu |
| jsonb_plpython3u | 1 | CONTRIB | LANG | transform between jsonb and plpython3u |
| ltree_plpython3u | 1 | CONTRIB | LANG | transform between ltree and plpython3u |
| plperl | 1 | CONTRIB | LANG | PL/Perl procedural language |
| plperlu | 1 | CONTRIB | LANG | PL/PerlU untrusted procedural language |
| plpgsql | 1 | CONTRIB | LANG | PL/pgSQL procedural language |
| plpython3u | 1 | CONTRIB | LANG | PL/Python3U untrusted procedural language |
| pltcl | 1 | CONTRIB | LANG | PL/Tcl procedural language |
| pltclu | 1 | CONTRIB | LANG | PL/TclU untrusted procedural language |
| pageinspect | 1.12 | CONTRIB | STAT | inspect the contents of database pages at a low level |
| pg_buffercache | 1.3 | CONTRIB | STAT | examine the shared buffer cache |
| pg_freespacemap | 1.2 | CONTRIB | STAT | examine the free space map (FSM) |
| pg_stat_statements | 1.1 | CONTRIB | STAT | track planning and execution statistics of all SQL statements executed |
| pg_visibility | 1.2 | CONTRIB | STAT | examine the visibility map (VM) and page-level visibility info |
| pg_walinspect | 1.1 | CONTRIB | STAT | functions to inspect contents of PostgreSQL Write-Ahead Log |
| pgrowlocks | 1.2 | CONTRIB | STAT | show row-level locking information |
| pgstattuple | 1.5 | CONTRIB | STAT | show tuple-level statistics |
| sslinfo | 1.2 | CONTRIB | STAT | information about SSL certificates |
| citext | 1.6 | CONTRIB | TYPE | data type for case-insensitive character strings |
| cube | 1.5 | CONTRIB | TYPE | data type for multidimensional cubes |
| hstore | 1.8 | CONTRIB | TYPE | data type for storing sets of (key, value) pairs |
| isn | 1.2 | CONTRIB | TYPE | data types for international product numbering standards |
| ltree | 1.2 | CONTRIB | TYPE | data type for hierarchical tree-like structures |
| seg | 1.4 | CONTRIB | TYPE | data type for representing line segments or floating-point intervals |
| xml2 | 1.1 | CONTRIB | TYPE | XPath querying and XSLT |
DEB Extension List
Currently, the major version PostgreSQL 16 has the following extensions available on debian/ubuntu systems. (Take Ubuntu 22.04 as standard):
There are 208 extensions available on Deb systems, including 8 extensions maintained and packaged by Pigsty, 73 PostgreSQL Contrib extensions, and 93 extensions provided by the PGDG official APT repo. There are 26 extensions that are only available on Deb systems.
| Extension | Version | Provider | Category | Description |
|---|---|---|---|---|
| age | 1.5.0 | PIGSTY | FEAT | AGE graph database extension |
| pg_analytics | 0.5.6 | PIGSTY | FEAT | Real-time analytics for PostgreSQL using columnar storage and vectorized execution |
| pg_bm25 | 0.5.6 | PIGSTY | FEAT | pg_bm25: Full text search for PostgreSQL using BM25 |
| pg_graphql | 1.5.0 | PIGSTY | FEAT | pg_graphql: GraphQL support |
| pgml | 2.8.1 | PIGSTY | FEAT | PostgresML: Run AL/ML workloads with SQL interface |
| pg_sparse | 0.5.6 | PIGSTY | FEAT | pg_sparse: Sparse vector data type and sparse HNSW access methods |
| pg_similarity | 1.0 | PIGSTY | FUNC | support similarity queries |
| pointcloud | 1.2.5 | PIGSTY | GIS | data type for lidar point clouds |
| credcheck | 2.6.0 | PGDG | ADMIN | credcheck - postgresql plain text credential checker |
| londiste | 3.8 | PGDG | ADMIN | Londiste replication support code |
| mimeo | 1.5.1 | PGDG | ADMIN | Extension for specialized, per-table replication between PostgreSQL instances |
| pg_cron | 1.6 | PGDG | ADMIN | Job scheduler for PostgreSQL |
| pg_dirtyread | 2 | PGDG | ADMIN | Read dead but unvacuumed rows from table |
| pg_fact_loader | 2.0 | PGDG | ADMIN | build fact tables with Postgres |
| pg_repack | 1.5.0 | PGDG | ADMIN | Reorganize tables in PostgreSQL databases with minimal locks |
| pg_squeeze | 1.6 | PGDG | ADMIN | A tool to remove unused space from a relation. |
| pgautofailover | 2.1 | PGDG | ADMIN | pg_auto_failover |
| pgfincore | 1.3.1 | PGDG | ADMIN | examine and manage the os buffer cache |
| pgl_ddl_deploy | 2.2 | PGDG | ADMIN | automated ddl deployment using pglogical |
| pglogical | 2.4.4 | PGDG | ADMIN | PostgreSQL Logical Replication |
| pglogical_origin | 1.0.0 | PGDG | ADMIN | Dummy extension for compatibility when upgrading from Postgres 9.4 |
| pglogical_ticker | 1.4 | PGDG | ADMIN | Have an accurate view on pglogical replication delay |
| pgpool_adm | 1.4 | PGDG | ADMIN | Administrative functions for pgPool |
| pgpool_recovery | 1.4 | PGDG | ADMIN | recovery functions for pgpool-II for V4.3 |
| pgpool_regclass | 1.0 | PGDG | ADMIN | replacement for regclass |
| prioritize | 1.0 | PGDG | ADMIN | get and set the priority of PostgreSQL backends |
| repmgr | 5.4 | PGDG | ADMIN | Replication manager for PostgreSQL |
| toastinfo | 1 | PGDG | ADMIN | show details on toasted datums |
| pgaudit | 16.0 | PGDG | AUDIT | provides auditing functionality |
| pgauditlogtofile | 1.5 | PGDG | AUDIT | pgAudit addon to redirect audit log to an independent file |
| set_user | 4.0.1 | PGDG | AUDIT | similar to SET ROLE but with added logging |
| mysql_fdw | 1.2 | PGDG | FDW | Foreign data wrapper for querying a MySQL server |
| ogr_fdw | 1.1 | PGDG | FDW | foreign-data wrapper for GIS data access |
| oracle_fdw | 1.2 | PGDG | FDW | foreign data wrapper for Oracle access |
| tds_fdw | 2.0.3 | PGDG | FDW | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
| decoderbufs | 0.1.0 | PGDG | FEAT | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| icu_ext | 1.8 | PGDG | FEAT | PostgreSQL extension (in C) to expose functionality from the ICU library |
| jsquery | 1.1 | PGDG | FEAT | data type for jsonb inspection |
| omnidb_plpgsql_debugger | 1.0.0 | PGDG | FEAT | Enable PL/PgSQL Debugger on OmniDB |
| periods | 1.2 | PGDG | FEAT | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| pg_snakeoil | 1 | PGDG | FEAT | PostgreSQL Anti-Virus |
| pgmemcache | 2.3.0 | PGDG | FEAT | memcached interface |
| pgq | 3.5 | PGDG | FEAT | Generic queue for PostgreSQL |
| pgq_node | 3.5 | PGDG | FEAT | Generic queue for PostgreSQL, node extension |
| pre_prepare | 0.4 | PGDG | FEAT | Prepare your prepare statement on server-side |
| rdkit | 4.3.0 | PGDG | FEAT | Cheminformatics functionality for PostgreSQL. |
| timescaledb | 2.14.1 | PGDG | FEAT | Enables scalable inserts and complex queries for time-series data (Apache 2 Edition) |
| vector | 0.6.1 | PGDG | FEAT | vector data type and ivfflat and hnsw access methods |
| extra_window_functions | 1.0 | PGDG | FUNC | |
| first_last_agg | 0.1.4 | PGDG | FUNC | first() and last() aggregate functions |
| orafce | 4.9 | PGDG | FUNC | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| pg_sphere | 1.4.2 | PGDG | FUNC | spherical objects with useful functions, operators and index support |
| pgpcre | 1 | PGDG | FUNC | Perl Compatible Regular Expression functions |
| q3c | 2.0.1 | PGDG | FUNC | q3c sky indexing plugin |
| table_log | 0.6.1 | PGDG | FUNC | Module to log changes on tables |
| tdigest | 1.4.1 | PGDG | FUNC | Provides tdigest aggregate function. |
| topn | 2.6.0 | PGDG | FUNC | type for top-n JSONB |
| address_standardizer-3 | 3.4.2 | PGDG | GIS | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
| address_standardizer_data_us-3 | 3.4.2 | PGDG | GIS | Address Standardizer US dataset example |
| h3 | 4.1.3 | PGDG | GIS | H3 bindings for PostgreSQL |
| h3_postgis | 4.1.3 | PGDG | GIS | H3 PostGIS integration |
| pgrouting | 3.6.1 | PGDG | GIS | pgRouting Extension |
| pointcloud_postgis | 1.2.5 | PGDG | GIS | integration for pointcloud LIDAR data and PostGIS geometry data |
| postgis-3 | 3.4.2 | PGDG | GIS | PostGIS geometry and geography spatial types and functions |
| postgis_raster-3 | 3.4.2 | PGDG | GIS | PostGIS raster types and functions |
| postgis_sfcgal-3 | 3.4.2 | PGDG | GIS | PostGIS SFCGAL functions |
| postgis_tiger_geocoder-3 | 3.4.2 | PGDG | GIS | PostGIS tiger geocoder and reverse geocoder |
| postgis_topology-3 | 3.4.2 | PGDG | GIS | PostGIS topology spatial types and functions |
| hll | 2.18 | PGDG | INDEX | type for storing hyperloglog data |
| rum | 1.3 | PGDG | INDEX | RUM index access method |
| hstore_pllua | 1.0 | PGDG | LANG | Hstore transform for Lua |
| hstore_plluau | 1.0 | PGDG | LANG | transform between hstore and plluau |
| pljava | 1.6.6 | PGDG | LANG | PL/Java procedural language |
| pllua | 2.0 | PGDG | LANG | Lua as a procedural language |
| plluau | 2.0 | PGDG | LANG | Lua as an untrusted procedural language |
| plpgsql_check | 2.7 | PGDG | LANG | extended check for plpgsql functions |
| plr | 8.4.6 | PGDG | LANG | load R interpreter and execute R script from within a database |
| plsh | 2 | PGDG | LANG | PL/sh procedural language |
| citus | 12.1-1 | PGDG | SHARD | Distributed PostgreSQL as an extension |
| citus_columnar | 11.3-1 | PGDG | SHARD | Citus columnar storage engine |
| pg_partman | 5.0.1 | PGDG | SHARD | Extension to manage partitioned tables by time or ID |
| plproxy | 2.11.0 | PGDG | SHARD | Database partitioning implemented as procedural language |
| hypopg | 1.4.0 | PGDG | STAT | Hypothetical indexes for PostgreSQL |
| pg_qualstats | 2.1.0 | PGDG | STAT | An extension collecting statistics about quals |
| pg_show_plans | 2.0 | PGDG | STAT | show query plans of all currently running SQL statements |
| pg_stat_kcache | 2.2.3 | PGDG | STAT | Kernel statistics gathering |
| pg_track_settings | 2.1.2 | PGDG | STAT | Track settings changes |
| pg_wait_sampling | 1.1 | PGDG | STAT | sampling based statistics of wait events |
| pldbgapi | 1.1 | PGDG | STAT | server-side support for debugging PL/pgSQL functions |
| plprofiler | 4.2 | PGDG | STAT | server-side support for profiling PL/pgSQL functions |
| powa | 4.2.2 | PGDG | STAT | PostgreSQL Workload Analyser-core |
| pgtap | 1.3.2 | PGDG | TEST | Unit testing for PostgreSQL |
| asn1oid | 1 | PGDG | TYPE | asn1oid extension |
| debversion | 1.1 | PGDG | TYPE | Debian version number data type |
| ip4r | 2.4 | PGDG | TYPE | NULL |
| numeral | 1 | PGDG | TYPE | numeral datatypes extension |
| pg_rational | 0.0.1 | PGDG | TYPE | bigint fractions |
| pgmp | 1.1 | PGDG | TYPE | Multiple Precision Arithmetic extension |
| prefix | 1.2.0 | PGDG | TYPE | Prefix Range module for PostgreSQL |
| semver | 0.32.1 | PGDG | TYPE | Semantic version data type |
| unit | 7 | PGDG | TYPE | SI units extension |
| adminpack | 2.1 | CONTRIB | ADMIN | administrative functions for PostgreSQL |
| lo | 1.1 | CONTRIB | ADMIN | Large Object maintenance |
| old_snapshot | 1.0 | CONTRIB | ADMIN | utilities in support of old_snapshot_threshold |
| pg_prewarm | 1.2 | CONTRIB | ADMIN | prewarm relation data |
| pg_surgery | 1.0 | CONTRIB | ADMIN | extension to perform surgery on a damaged relation |
| auth_delay | null | CONTRIB | CONTRIB | pause briefly before reporting authentication failure |
| auto_explain | null | CONTRIB | CONTRIB | Provides a means for logging execution plans of slow statements automatically |
| basebackup_to_shell | null | CONTRIB | CONTRIB | adds a custom basebackup target called shell |
| basic_archive | null | CONTRIB | CONTRIB | an example of an archive module |
| hstore_plpython | null | CONTRIB | CONTRIB | transform between hstore and plpython |
| jsonb_plpython | null | CONTRIB | CONTRIB | transform between jsonb and plpython |
| ltree_plpython | null | CONTRIB | CONTRIB | transform between ltree and plpython |
| oid2name | null | CONTRIB | CONTRIB | utility program that helps administrators to examine the file structure used by PostgreSQL |
| passwordcheck | null | CONTRIB | CONTRIB | checks user passwords and reject weak password |
| sepgsql | null | CONTRIB | CONTRIB | label-based mandatory access control (MAC) based on SELinux security policy. |
| test_decoding | null | CONTRIB | CONTRIB | SQL-based test/example module for WAL logical decoding |
| vacuumlo | null | CONTRIB | CONTRIB | utility program that will remove any orphaned large objects from a PostgreSQL database |
| dblink | 1.2 | CONTRIB | FDW | connect to other PostgreSQL databases from within a database |
| null | 1.0 | CONTRIB | FDW | foreign-data wrapper for flat file access |
| postgres_fdw | 1.1 | CONTRIB | FDW | foreign-data wrapper for remote PostgreSQL servers |
| autoinc | 1.0 | CONTRIB | FUNC | functions for autoincrementing fields |
| btree_gin | 1.3 | CONTRIB | FUNC | support for indexing common datatypes in GIN |
| btree_gist | 1.7 | CONTRIB | FUNC | support for indexing common datatypes in GiST |
| dict_int | 1.0 | CONTRIB | FUNC | text search dictionary template for integers |
| dict_xsyn | 1.0 | CONTRIB | FUNC | text search dictionary template for extended synonym processing |
| earthdistance | 1.1 | CONTRIB | FUNC | calculate great-circle distances on the surface of the Earth |
| fuzzystrmatch | 1.2 | CONTRIB | FUNC | determine similarities and distance between strings |
| insert_username | 1.0 | CONTRIB | FUNC | functions for tracking who changed a table |
| intagg | 1.1 | CONTRIB | FUNC | integer aggregator and enumerator (obsolete) |
| intarray | 1.5 | CONTRIB | FUNC | functions, operators, and index support for 1-D arrays of integers |
| moddatetime | 1.0 | CONTRIB | FUNC | functions for tracking last modification time |
| pg_trgm | 1.6 | CONTRIB | FUNC | text similarity measurement and index searching based on trigrams |
| pgcrypto | 1.3 | CONTRIB | FUNC | cryptographic functions |
| refint | 1.0 | CONTRIB | FUNC | functions for implementing referential integrity (obsolete) |
| tablefunc | 1.0 | CONTRIB | FUNC | functions that manipulate whole tables, including crosstab |
| tcn | 1.0 | CONTRIB | FUNC | Triggered change notifications |
| tsm_system_rows | 1.0 | CONTRIB | FUNC | TABLESAMPLE method which accepts number of rows as a limit |
| tsm_system_time | 1.0 | CONTRIB | FUNC | TABLESAMPLE method which accepts time in milliseconds as a limit |
| unaccent | 1.1 | CONTRIB | FUNC | text search dictionary that removes accents |
| uuid-ossp | 1.1 | CONTRIB | FUNC | generate universally unique identifiers (UUIDs) |
| amcheck | 1.3 | CONTRIB | INDEX | functions for verifying relation integrity |
| bloom | 1.0 | CONTRIB | INDEX | bloom access method - signature file based index |
| bool_plperl | 1.0 | CONTRIB | LANG | transform between bool and plperl |
| bool_plperlu | 1.0 | CONTRIB | LANG | transform between bool and plperlu |
| hstore_plperl | 1.0 | CONTRIB | LANG | transform between hstore and plperl |
| hstore_plperlu | 1.0 | CONTRIB | LANG | transform between hstore and plperlu |
| hstore_plpython3u | 1.0 | CONTRIB | LANG | transform between hstore and plpython3u |
| jsonb_plperl | 1.0 | CONTRIB | LANG | transform between jsonb and plperl |
| jsonb_plperlu | 1.0 | CONTRIB | LANG | transform between jsonb and plperlu |
| jsonb_plpython3u | 1.0 | CONTRIB | LANG | transform between jsonb and plpython3u |
| ltree_plpython3u | 1.0 | CONTRIB | LANG | transform between ltree and plpython3u |
| plperl | 1.0 | CONTRIB | LANG | PL/Perl procedural language |
| plperlu | 1.0 | CONTRIB | LANG | PL/PerlU untrusted procedural language |
| plpgsql | 1.0 | CONTRIB | LANG | PL/pgSQL procedural language |
| plpython3u | 1.0 | CONTRIB | LANG | PL/Python3U untrusted procedural language |
| pltcl | 1.0 | CONTRIB | LANG | PL/Tcl procedural language |
| pltclu | 1.0 | CONTRIB | LANG | PL/TclU untrusted procedural language |
| pageinspect | 1.12 | CONTRIB | STAT | inspect the contents of database pages at a low level |
| pg_buffercache | 1.4 | CONTRIB | STAT | examine the shared buffer cache |
| pg_freespacemap | 1.2 | CONTRIB | STAT | examine the free space map (FSM) |
| pg_stat_statements | 1.10 | CONTRIB | STAT | track planning and execution statistics of all SQL statements executed |
| pg_visibility | 1.2 | CONTRIB | STAT | examine the visibility map (VM) and page-level visibility info |
| pg_walinspect | 1.1 | CONTRIB | STAT | functions to inspect contents of PostgreSQL Write-Ahead Log |
| pgrowlocks | 1.2 | CONTRIB | STAT | show row-level locking information |
| pgstattuple | 1.5 | CONTRIB | STAT | show tuple-level statistics |
| sslinfo | 1.2 | CONTRIB | STAT | information about SSL certificates |
| citext | 1.6 | CONTRIB | TYPE | data type for case-insensitive character strings |
| cube | 1.5 | CONTRIB | TYPE | data type for multidimensional cubes |
| hstore | 1.8 | CONTRIB | TYPE | data type for storing sets of (key, value) pairs |
| isn | 1.2 | CONTRIB | TYPE | data types for international product numbering standards |
| ltree | 1.2 | CONTRIB | TYPE | data type for hierarchical tree-like structures |
| seg | 1.4 | CONTRIB | TYPE | data type for representing line segments or floating-point intervals |
| xml2 | 1.1 | CONTRIB | TYPE | XPath querying and XSLT |
Caveat: some extensions are not available on Debian/Ubuntu systems, you can build from source, including:
http,gzip,pg_tle,roaringbitmap,zhparser,pgjwt,vault,hydra,imgsmlr,pg_bigm,duckdb_fdw.ageandpointcloudare included in deb repo.pg_graphql,pg_net,pg_bm25,pg_analytics,svectoris available on Ubuntu 22.04.
Pigsty Extension
Currently, the major version PostgreSQL 16 has the following extensions available, here are the extensions RPMs maintained by Pigsty (only available on EL7/8/9):
| name | version | source | comment |
|---|---|---|---|
| pgml | 2.8.1 | PIGSTY | PostgresML: access most advanced machine learning algorithms and pretrained models with SQL |
| age | 1.5.0 | PIGSTY | Apache AGE graph database extension |
| pointcloud | 1.2.5 | PIGSTY | A PostgreSQL extension for storing point cloud (LIDAR) data. |
| http | 1.6 | PIGSTY | HTTP client for PostgreSQL, allows web page retrieval inside the database. |
| gzip | 1.0 | PIGSTY | Gzip and unzip with SQL |
| pg_tle | 1.3.4 | PIGSTY | Trusted Language Extensions for PostgreSQL |
| roaringbitmap | 0.5 | PIGSTY | Support for Roaring Bitmaps |
| zhparser | 2.2 | PIGSTY | Parser for full-text search of Chinese |
| pg_net | 0.8.0 | PIGSTY | A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL |
| pgjwt | 0.2.0 | PIGSTY | JSON Web Token API for Postgresql |
| vault | 0.2.9 | PIGSTY | Extension for storing encrypted secrets in the Vault |
| pg_graphql | 1.5.0 | PIGSTY | GraphQL support for PostgreSQL |
| hydra | 1.1.1 | PIGSTY | Hydra is open source, column-oriented Postgres extension |
| imgsmlr ❋ | 1.0.0 | PIGSTY | ImgSmlr method is based on Haar wavelet transform |
| pg_similarity ❋ | 1.0.0 | PIGSTY | set of functions and operators for executing similarity queries |
| pg_bigm ❋ | 1.2.0 | PIGSTY | full text search capability with create 2-gram (bigram) index. |
| svector | 0.5.6 | PIGSTY | pg_sparse: Sparse vector data type and sparse HNSW access methods |
| pg_bm25 | 0.5.6 | PIGSTY | ParadeDB: pg_bm25: Full text search for PostgreSQL using BM25 |
| pg_analytics | 0.5.6 | PIGSTY | ParadeDB: Real-time analytics for PostgreSQL using columnar storage and vectorized execution |
| duckdb_fdw | 1.1 | PIGSTY | DuckDB Foreign Data Wrapper |
Caveat: some extensions are not available on Debian/Ubuntu systems, you can build from source, including:
http,gzip,pg_tle,roaringbitmap,zhparser,pgjwt,vault,hydra,imgsmlr,pg_bigm,duckdb_fdw.ageandpointcloudare included in deb repo.pg_graphql,pg_net,pg_bm25,pg_analytics,svectoris available on Ubuntu 22.04.
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.