PostgreSQL Extension Repository
The supplementary APT and YUM repo for PostgreSQL extensions, maintained and used by Pigsty
TIME
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| timescaledb | Timescale | PIGSTY | PIGSTY | Enables scalable inserts and complex queries for time-series data |
| timescaledb_toolkit | Timescale | PIGSTY | PIGSTY | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities |
| timeseries | PostgreSQL | PIGSTY | PIGSTY | Convenience API for Tembo time series stack |
| periods | PostgreSQL | PGDG | PGDG | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| temporal_tables | BSD 2-Clause | PIGSTY | PIGSTY | temporal tables |
| emaj | GPL-3.0 | PGDG | PIGSTY | Enables fine-grained write logging and time travel on subsets of the database. |
| table_version | BSD 3-Clause | PIGSTY | PIGSTY | PostgreSQL table versioning extension |
| pg_cron | PostgreSQL | PGDG | PGDG | Job scheduler for PostgreSQL |
| pg_task | MIT | PGDG | PIGSTY | execute any sql command at any specific time at background |
| pg_later | PostgreSQL | PIGSTY | PIGSTY | pg_later: Run queries now and get results later |
| pg_background | GPL-3.0 | PGDG | PIGSTY | Run SQL queries in the background |
GIS
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| postgis | GPL-2.0 | PGDG | PGDG | PostGIS geometry and geography spatial types and functions |
| postgis_topology | GPL-2.0 | PGDG | PGDG | PostGIS topology spatial types and functions |
| postgis_raster | GPL-2.0 | PGDG | PGDG | PostGIS raster types and functions |
| postgis_sfcgal | GPL-2.0 | PGDG | PGDG | PostGIS SFCGAL functions |
| postgis_tiger_geocoder | GPL-2.0 | PGDG | PGDG | PostGIS tiger geocoder and reverse geocoder |
| address_standardizer | GPL-2.0 | PGDG | PGDG | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
| address_standardizer_data_us | GPL-2.0 | PGDG | PGDG | Address Standardizer US dataset example |
| pgrouting | GPL-2.0 | PGDG | PGDG | pgRouting Extension |
| pointcloud | BSD 3-Clause | PIGSTY | PGDG | data type for lidar point clouds |
| pointcloud_postgis | BSD 3-Clause | PGDG | PGDG | integration for pointcloud LIDAR data and PostGIS geometry data |
| h3 | Apache-2.0 | PGDG | PGDG | H3 bindings for PostgreSQL |
| h3_postgis | Apache-2.0 | PGDG | PGDG | H3 PostGIS integration |
| q3c | GPL-2.0 | PIGSTY | PGDG | q3c sky indexing plugin |
| ogr_fdw | MIT | PGDG | PGDG | foreign-data wrapper for GIS data access |
| geoip | BSD 2-Clause | PIGSTY | PIGSTY | IP-based geolocation query |
| pg_polyline | MIT | PIGSTY | PIGSTY | Fast Google Encoded Polyline encoding & decoding for postgres |
| pg_geohash | MIT | PIGSTY | PIGSTY | Handle geohash based functionality for spatial coordinates |
| mobilitydb | GPL-3.0 | - | PGDG | MobilityDB geospatial trajectory data management & analysis platform |
| earthdistance | PostgreSQL | CONTRIB | CONTRIB | calculate great-circle distances on the surface of the Earth |
RAG
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| vector | PostgreSQL | PGDG | PGDG | vector data type and ivfflat and hnsw access methods |
| vchord | AGPL-3.0 | PIGSTY | PIGSTY | Vector database plugin for Postgres, written in Rust |
| vectorscale | PostgreSQL | PIGSTY | PIGSTY | pgvectorscale: Advanced indexing for vector data |
| vectorize | PostgreSQL | PIGSTY | PIGSTY | The simplest way to do vector search on Postgres |
| pg_similarity | BSD 3-Clause | PIGSTY | PGDG | support similarity queries |
| smlar | PostgreSQL | PIGSTY | PIGSTY | Effective similarity search |
| pg_summarize | PostgreSQL | PIGSTY | PIGSTY | Text Summarization using LLMs. Built using pgrx |
| pg_tiktoken | Apache-2.0 | PIGSTY | PIGSTY | pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres |
| pg4ml | AGPL-3.0 | PIGSTY | PIGSTY | Machine learning framework for PostgreSQL |
| pgml | MIT | - | PIGSTY | PostgresML: Run AL/ML workloads with SQL interface |
FTS
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| pg_search | AGPL-3.0 | PIGSTY | PIGSTY | pg_search: Full text search for PostgreSQL using BM25 |
| pgroonga | PostgreSQL | PIGSTY | PIGSTY | Use Groonga as index, fast full text search platform for all languages! |
| pgroonga_database | PostgreSQL | PIGSTY | PIGSTY | PGroonga database management module |
| pg_bigm | PostgreSQL | PGDG | PIGSTY | create 2-gram (bigram) index for faster full text search. |
| zhparser | PostgreSQL | PIGSTY | PIGSTY | a parser for full-text search of Chinese |
| pg_bestmatch | Apache-2.0 | PIGSTY | PIGSTY | Generate BM25 sparse vector inside PostgreSQL |
| vchord_bm25 | AGPL-3.0 | PIGSTY | PIGSTY | A postgresql extension for bm25 ranking algorithm |
| hunspell_cs_cz | PostgreSQL | PIGSTY | PIGSTY | Czech Hunspell Dictionary |
| hunspell_de_de | PostgreSQL | PIGSTY | PIGSTY | German Hunspell Dictionary |
| hunspell_en_us | PostgreSQL | PIGSTY | PIGSTY | en_US Hunspell Dictionary |
| hunspell_fr | PostgreSQL | PIGSTY | PIGSTY | French Hunspell Dictionary |
| hunspell_ne_np | PostgreSQL | PIGSTY | PIGSTY | Nepali Hunspell Dictionary |
| hunspell_nl_nl | PostgreSQL | PIGSTY | PIGSTY | Dutch Hunspell Dictionary |
| hunspell_nn_no | PostgreSQL | PIGSTY | PIGSTY | Norwegian (norsk) Hunspell Dictionary |
| hunspell_pt_pt | PostgreSQL | PIGSTY | PIGSTY | Portuguese Hunspell Dictionary |
| hunspell_ru_ru | PostgreSQL | PIGSTY | PIGSTY | Russian Hunspell Dictionary |
| hunspell_ru_ru_aot | PostgreSQL | PIGSTY | PIGSTY | Russian Hunspell Dictionary (from AOT.ru group) |
| fuzzystrmatch | PostgreSQL | CONTRIB | CONTRIB | determine similarities and distance between strings |
| pg_trgm | PostgreSQL | CONTRIB | CONTRIB | text similarity measurement and index searching based on trigrams |
OLAP
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| citus | AGPL-3.0 | PIGSTY | PIGSTY | Distributed PostgreSQL as an extension |
| citus_columnar | AGPL-3.0 | PIGSTY | PIGSTY | Citus columnar storage engine |
| columnar | AGPL-3.0 | PIGSTY | PIGSTY | Hydra Columnar extension |
| pg_analytics | PostgreSQL | PIGSTY | PIGSTY | Postgres for analytics, powered by DuckDB |
| pg_duckdb | MIT | PIGSTY | PIGSTY | DuckDB Embedded in Postgres |
| pg_mooncake | MIT | PIGSTY | PIGSTY | Columnstore Table in Postgres |
| duckdb_fdw | MIT | PIGSTY | PIGSTY | DuckDB Foreign Data Wrapper |
| pg_parquet | PostgreSQL | PIGSTY | PIGSTY | copy data between Postgres and Parquet |
| pg_fkpart | GPL-2.0 | PIGSTY | PIGSTY | Table partitioning by foreign key utility |
| pg_partman | PostgreSQL | PGDG | PGDG | Extension to manage partitioned tables by time or ID |
| plproxy | BSD 0-Clause | PIGSTY | PGDG | Database partitioning implemented as procedural language |
| pg_strom | PostgreSQL | PGDG | - | PG-Strom - big-data processing acceleration using GPU and NVME |
| tablefunc | PostgreSQL | CONTRIB | CONTRIB | functions that manipulate whole tables, including crosstab |
FEAT
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| omni | Apache-2.0 | PIGSTY | PIGSTY | Advanced adapter for Postgres extensions |
| omni_auth | Apache-2.0 | PIGSTY | PIGSTY | Basic session management |
| omni_aws | Apache-2.0 | PIGSTY | PIGSTY | Amazon Web Services APIs (S3) |
| omni_containers | Apache-2.0 | PIGSTY | PIGSTY | Docker container management |
| omni_credentials | Apache-2.0 | PIGSTY | PIGSTY | Application credential management |
| omni_http | Apache-2.0 | PIGSTY | PIGSTY | Basic HTTP types |
| omni_httpc | Apache-2.0 | PIGSTY | PIGSTY | HTTP client |
| omni_httpd | Apache-2.0 | PIGSTY | PIGSTY | HTTP server |
| omni_id | Apache-2.0 | PIGSTY | PIGSTY | Identity types |
| omni_json | Apache-2.0 | PIGSTY | PIGSTY | JSON toolkit |
| omni_kube | Apache-2.0 | PIGSTY | PIGSTY | Kubernetes (k8s) integration |
| omni_ledger | Apache-2.0 | PIGSTY | PIGSTY | Financial ledger |
| omni_manifest | Apache-2.0 | PIGSTY | PIGSTY | Package installation manifests |
| omni_mimetypes | Apache-2.0 | PIGSTY | PIGSTY | MIME types |
| omni_os | Apache-2.0 | PIGSTY | PIGSTY | Operating system integration |
| omni_polyfill | Apache-2.0 | PIGSTY | PIGSTY | Postgres API polyfills |
| omni_python | Apache-2.0 | PIGSTY | PIGSTY | First-class Python support |
| omni_regex | Apache-2.0 | PIGSTY | PIGSTY | PCRE-compatible regular expressions |
| omni_rest | Apache-2.0 | PIGSTY | PIGSTY | REST API toolkit (with PostgREST support) |
| omni_schema | Apache-2.0 | PIGSTY | PIGSTY | Advanced schema management tooling |
| omni_seq | Apache-2.0 | PIGSTY | PIGSTY | Distributed integer sequences |
| omni_service | Apache-2.0 | PIGSTY | PIGSTY | Service management |
| omni_session | Apache-2.0 | PIGSTY | PIGSTY | Session management |
| omni_sql | Apache-2.0 | PIGSTY | PIGSTY | Programmatic SQL manipulation |
| omni_test | Apache-2.0 | PIGSTY | PIGSTY | Testing framework |
| omni_txn | Apache-2.0 | PIGSTY | PIGSTY | Transaction management |
| omni_types | Apache-2.0 | PIGSTY | PIGSTY | Advanced types |
| omni_var | Apache-2.0 | PIGSTY | PIGSTY | Scoped variables |
| omni_vfs | Apache-2.0 | PIGSTY | PIGSTY | Virtual File System |
| omni_vfs_types_v1 | Apache-2.0 | PIGSTY | PIGSTY | Virtual File System types (v1) |
| omni_web | Apache-2.0 | PIGSTY | PIGSTY | Common web stack primitives |
| omni_xml | Apache-2.0 | PIGSTY | PIGSTY | XML toolkit |
| omni_yaml | Apache-2.0 | PIGSTY | PIGSTY | YAML toolkit |
| documentdb_core | MIT | PIGSTY | PIGSTY | Core API surface for DocumentDB on PostgreSQL |
| age | Apache-2.0 | PIGSTY | PGDG | AGE graph database extension |
| hll | Apache-2.0 | PGDG | PGDG | type for storing hyperloglog data |
| rum | PostgreSQL | PGDG | PGDG | RUM index access method |
| pg_graphql | Apache-2.0 | PIGSTY | PIGSTY | pg_graphql: GraphQL support |
| pg_jsonschema | Apache-2.0 | PIGSTY | PIGSTY | PostgreSQL extension providing JSON Schema validation |
| jsquery | PostgreSQL | PGDG | PGDG | data type for jsonb inspection |
| pg_hint_plan | BSD 3-Clause | PGDG | PGDG | Give PostgreSQL ability to manually force some decisions in execution plans. |
| hypopg | PostgreSQL | PGDG | PGDG | Hypothetical indexes for PostgreSQL |
| index_advisor | PostgreSQL | PIGSTY | PIGSTY | Query index advisor |
| plan_filter | PostgreSQL | PIGSTY | PIGSTY | filter statements by their execution plans. |
| imgsmlr | PostgreSQL | PIGSTY | PIGSTY | Image similarity with haar |
| pg_ivm | PostgreSQL | PGDG | PIGSTY | incremental view maintenance on PostgreSQL |
| pg_incremental | PostgreSQL | PGDG | PIGSTY | Incremental Processing by Crunchy Data |
| pgmq | PostgreSQL | PIGSTY | PIGSTY | A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. |
| pgq | ISC | PGDG | PGDG | Generic queue for PostgreSQL |
| pg_cardano | MIT | PIGSTY | PIGSTY | A suite of Cardano-related tools |
| rdkit | BSD 3-Clause | - | PGDG | Cheminformatics functionality for PostgreSQL. |
| bloom | PostgreSQL | CONTRIB | CONTRIB | bloom access method - signature file based index |
LANG
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| pg_tle | Apache-2.0 | PIGSTY | PIGSTY | Trusted Language Extensions for PostgreSQL |
| plv8 | PostgreSQL | PIGSTY | PIGSTY | PL/JavaScript (v8) trusted procedural language |
| pllua | MIT | PGDG | PGDG | Lua as a procedural language |
| hstore_pllua | MIT | - | PGDG | Hstore transform for Lua |
| plluau | MIT | PGDG | PGDG | Lua as an untrusted procedural language |
| hstore_plluau | MIT | - | PGDG | Hstore transform for untrusted Lua |
| plprql | Apache-2.0 | PIGSTY | PIGSTY | Use PRQL in PostgreSQL - Pipelined Relational Query Language |
| pldbgapi | Artistic | PGDG | PGDG | server-side support for debugging PL/pgSQL functions |
| plpgsql_check | MIT | PGDG | PGDG | extended check for plpgsql functions |
| plprofiler | Artistic | PGDG | PGDG | server-side support for profiling PL/pgSQL functions |
| plsh | MIT | PGDG | PGDG | PL/sh procedural language |
| pljava | BSD 3-Clause | PGDG | PGDG | PL/Java procedural language (https://tada.github.io/pljava/) |
| plr | GPL-2.0 | PGDG | PGDG | load R interpreter and execute R script from within a database |
| pgtap | PostgreSQL | PGDG | PGDG | Unit testing for PostgreSQL |
| faker | PostgreSQL | PGDG | - | Wrapper for the Faker Python library |
| dbt2 | Artistic | PGDG | - | OSDL-DBT-2 test kit |
| pltcl | PostgreSQL | CONTRIB | CONTRIB | PL/Tcl procedural language |
| pltclu | PostgreSQL | CONTRIB | CONTRIB | PL/TclU untrusted procedural language |
| plperl | PostgreSQL | CONTRIB | CONTRIB | PL/Perl procedural language |
| bool_plperl | PostgreSQL | CONTRIB | CONTRIB | transform between bool and plperl |
| hstore_plperl | PostgreSQL | CONTRIB | CONTRIB | transform between hstore and plperl |
| jsonb_plperl | PostgreSQL | CONTRIB | CONTRIB | transform between jsonb and plperl |
| plperlu | PostgreSQL | CONTRIB | CONTRIB | PL/PerlU untrusted procedural language |
| bool_plperlu | PostgreSQL | CONTRIB | CONTRIB | transform between bool and plperlu |
| jsonb_plperlu | PostgreSQL | CONTRIB | CONTRIB | transform between jsonb and plperlu |
| hstore_plperlu | PostgreSQL | CONTRIB | CONTRIB | transform between hstore and plperlu |
| plpgsql | PostgreSQL | CONTRIB | CONTRIB | PL/pgSQL procedural language |
| plpython3u | PostgreSQL | CONTRIB | CONTRIB | PL/Python3U untrusted procedural language |
| jsonb_plpython3u | PostgreSQL | CONTRIB | CONTRIB | transform between jsonb and plpython3u |
| ltree_plpython3u | PostgreSQL | CONTRIB | CONTRIB | transform between ltree and plpython3u |
| hstore_plpython3u | PostgreSQL | CONTRIB | CONTRIB | transform between hstore and plpython3u |
TYPE
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| prefix | PostgreSQL | PGDG | PGDG | Prefix Range module for PostgreSQL |
| semver | PostgreSQL | PGDG | PGDG | Semantic version data type |
| unit | GPL-2.0 | PGDG | PGDG | SI units extension |
| pgpdf | GPL-3.0 | PIGSTY | PIGSTY | PDF type with meta admin & Full-Text Search |
| pglite_fusion | MIT | PIGSTY | PIGSTY | Embed an SQLite database in your PostgreSQL table |
| md5hash | BSD 2-Clause | PIGSTY | PIGSTY | type for storing 128-bit binary data inline |
| asn1oid | GPL-3.0 | PIGSTY | PGDG | asn1oid extension |
| roaringbitmap | Apache-2.0 | PIGSTY | PGDG | support for Roaring Bitmaps |
| pgfaceting | BSD 3-Clause | PIGSTY | PGDG | fast faceting queries using an inverted index |
| pg_sphere | BSD 3-Clause | PIGSTY | PGDG | spherical objects with useful functions, operators and index support |
| country | PostgreSQL | PIGSTY | PIGSTY | Country data type, ISO 3166-1 |
| pg_xenophile | PostgreSQL | PIGSTY | PIGSTY | More than the bare necessities for PostgreSQL i18n and l10n. |
| currency | MIT | PIGSTY | PIGSTY | Custom PostgreSQL currency type in 1Byte |
| pgmp | LGPL-3.0 | PGDG | PGDG | Multiple Precision Arithmetic extension |
| numeral | GPL-2.0 | PIGSTY | PGDG | numeral datatypes extension |
| pg_rational | MIT | PIGSTY | PGDG | bigint fractions |
| uint | PostgreSQL | PIGSTY | PIGSTY | unsigned integer types |
| uint128 | PostgreSQL | PIGSTY | PIGSTY | Native uint128 type |
| hashtypes | PostgreSQL | PIGSTY | PIGSTY | sha1, md5 and other data types for PostgreSQL |
| ip4r | PostgreSQL | PGDG | PGDG | IPv4/v6 and IPv4/v6 range index type for PostgreSQL |
| pg_duration | MIT | PIGSTY | PIGSTY | data type for representing durations |
| uri | PostgreSQL | PIGSTY | PIGSTY | URI Data type for PostgreSQL |
| emailaddr | PostgreSQL | PIGSTY | PIGSTY | Email address type for PostgreSQL |
| acl | BSD 2-Clause | PIGSTY | PIGSTY | ACL Data type |
| debversion | PostgreSQL | - | PGDG | Debian version number data type |
| pg_rrule | MIT | - | PGDG | RRULE field type for PostgreSQL |
| timestamp9 | MIT | PGDG | PIGSTY | timestamp nanosecond resolution |
| chkpass | PostgreSQL | PIGSTY | PIGSTY | data type for auto-encrypted passwords |
| isn | PostgreSQL | CONTRIB | CONTRIB | data types for international product numbering standards |
| seg | PostgreSQL | CONTRIB | CONTRIB | data type for representing line segments or floating-point intervals |
| cube | PostgreSQL | CONTRIB | CONTRIB | data type for multidimensional cubes |
| ltree | PostgreSQL | CONTRIB | CONTRIB | data type for hierarchical tree-like structures |
| hstore | PostgreSQL | CONTRIB | CONTRIB | data type for storing sets of (key, value) pairs |
| citext | PostgreSQL | CONTRIB | CONTRIB | data type for case-insensitive character strings |
| xml2 | PostgreSQL | CONTRIB | CONTRIB | XPath querying and XSLT |
UTIL
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| zstd | ISC | PIGSTY | PIGSTY | Zstandard compression algorithm implementation in PostgreSQL |
| gzip | MIT | PGDG | PIGSTY | gzip and gunzip functions. |
| http | MIT | PGDG | PGDG | HTTP client for PostgreSQL, allows web page retrieval inside the database. |
| pg_net | Apache-2.0 | PIGSTY | PIGSTY | Async HTTP Requests |
| pg_curl | MIT | PIGSTY | PIGSTY | Run curl actions for data transfer in URL syntax |
| pgjq | MIT | PIGSTY | PIGSTY | Use jq in Postgres |
| pgjwt | MIT | PIGSTY | PIGSTY | JSON Web Token API for Postgresql |
| pg_smtp_client | MIT | PIGSTY | PIGSTY | PostgreSQL extension to send email using SMTP |
| pg_html5_email_address | PostgreSQL | PIGSTY | PIGSTY | PostgreSQL email validation that is consistent with the HTML5 spec |
| url_encode | PostgreSQL | PIGSTY | PIGSTY | url_encode, url_decode functions |
| pgsql_tweaks | PostgreSQL | PGDG | PIGSTY | Some functions and views for daily usage |
| pg_extra_time | PostgreSQL | PGDG | PIGSTY | Some date time functions and operators that, |
| pgpcre | PostgreSQL | PIGSTY | PGDG | Perl Compatible Regular Expression functions |
| icu_ext | PostgreSQL | PIGSTY | PGDG | Access ICU functions |
| pgqr | BSD 3-Clause | PIGSTY | PIGSTY | QR Code generator from PostgreSQL |
| pg_protobuf | MIT | PIGSTY | PIGSTY | Protobuf support for PostgreSQL |
| envvar | PostgreSQL | PIGSTY | PIGSTY | Fetch the value of an environment variable |
| floatfile | MIT | PIGSTY | PIGSTY | Simple file storage for arrays of floats |
| pg_readme | PostgreSQL | PGDG | PIGSTY | Generate a README.md document for a database extension or schema |
| ddl_historization | GPL-2.0 | PIGSTY | PIGSTY | Historize the ddl changes inside PostgreSQL database |
| data_historization | PostgreSQL | PIGSTY | PIGSTY | PLPGSQL Script to historize data in partitionned table |
| schedoc | GPL-3.0 | PIGSTY | PIGSTY | Cross documentation between Django and DBT projects |
| hashlib | PostgreSQL | PIGSTY | PIGSTY | Stable hash functions for Postgres |
| xxhash | BSD 2-Clause | PIGSTY | PIGSTY | xxhash functions for PostgreSQL |
| shacrypt | PostgreSQL | PIGSTY | PIGSTY | Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes |
| cryptint | PostgreSQL | PIGSTY | PIGSTY | Encryption functions for int and bigint values |
| pguecc | BSD 2-Clause | PIGSTY | PIGSTY | uECC bindings for Postgres |
| sparql | Apache-2.0 | PIGSTY | PIGSTY | Query SPARQL datasource with SQL |
FUNC
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| pg_idkit | Apache-2.0 | PIGSTY | PIGSTY | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
| pg_uuidv7 | MPL-2.0 | PGDG | PIGSTY | pg_uuidv7: create UUIDv7 values in postgres |
| permuteseq | PostgreSQL | PIGSTY | PIGSTY | Pseudo-randomly permute sequences with a format-preserving encryption on elements |
| pg_hashids | MIT | PIGSTY | PIGSTY | Short unique id generator for PostgreSQL, using hashids |
| sequential_uuids | MIT | PGDG | PIGSTY | generator of sequential UUIDs |
| topn | AGPL-3.0 | PGDG | PIGSTY | type for top-n JSONB |
| quantile | BSD 2-Clause | PIGSTY | PIGSTY | Quantile aggregation function |
| lower_quantile | BSD 2-Clause | PIGSTY | PIGSTY | Lower quantile aggregate function |
| count_distinct | BSD 2-Clause | PIGSTY | PIGSTY | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| omnisketch | PostgreSQL | PIGSTY | PIGSTY | data structure for on-line agg of data into approximate sketch |
| ddsketch | PostgreSQL | PIGSTY | PIGSTY | Provides ddsketch aggregate function |
| vasco | GPL-3.0 | PIGSTY | PIGSTY | discover hidden correlations in your data with MIC |
| xicor | GPL-3.0 | PIGSTY | PIGSTY | XI Correlation Coefficient in Postgres |
| tdigest | Apache-2.0 | PGDG | PGDG | Provides tdigest aggregate function. |
| first_last_agg | PostgreSQL | PIGSTY | PGDG | first() and last() aggregate functions |
| extra_window_functions | PostgreSQL | PGDG | PGDG | Extra Window Functions for PostgreSQL |
| floatvec | MIT | PIGSTY | PIGSTY | Math for vectors (arrays) of numbers |
| aggs_for_vecs | MIT | PIGSTY | PIGSTY | Aggregate functions for array inputs |
| aggs_for_arrays | MIT | PIGSTY | PIGSTY | Various functions for computing statistics on arrays of numbers |
| arraymath | MIT | PIGSTY | PIGSTY | Array math and operators that work element by element on the contents of arrays |
| pg_math | GPL-3.0 | PIGSTY | PIGSTY | GSL statistical functions for postgresql |
| random | PostgreSQL | PIGSTY | PIGSTY | random data generator |
| base36 | MIT | PIGSTY | PIGSTY | Integer Base36 types |
| base62 | MIT | PIGSTY | PIGSTY | Base62 extension for PostgreSQL |
| pg_base58 | MIT | PIGSTY | PIGSTY | Base58 Encoder/Decoder Extension for PostgreSQL |
| financial | PostgreSQL | PIGSTY | PIGSTY | Financial aggregate functions |
| refint | PostgreSQL | CONTRIB | CONTRIB | functions for implementing referential integrity (obsolete) |
| autoinc | PostgreSQL | CONTRIB | CONTRIB | functions for autoincrementing fields |
| insert_username | PostgreSQL | CONTRIB | CONTRIB | functions for tracking who changed a table |
| moddatetime | PostgreSQL | CONTRIB | CONTRIB | functions for tracking last modification time |
| tsm_system_time | PostgreSQL | CONTRIB | CONTRIB | TABLESAMPLE method which accepts time in milliseconds as a limit |
| dict_xsyn | PostgreSQL | CONTRIB | CONTRIB | text search dictionary template for extended synonym processing |
| tsm_system_rows | PostgreSQL | CONTRIB | CONTRIB | TABLESAMPLE method which accepts number of rows as a limit |
| tcn | PostgreSQL | CONTRIB | CONTRIB | Triggered change notifications |
| uuid-ossp | PostgreSQL | CONTRIB | CONTRIB | generate universally unique identifiers (UUIDs) |
| btree_gist | PostgreSQL | CONTRIB | CONTRIB | support for indexing common datatypes in GiST |
| btree_gin | PostgreSQL | CONTRIB | CONTRIB | support for indexing common datatypes in GIN |
| intarray | PostgreSQL | CONTRIB | CONTRIB | functions, operators, and index support for 1-D arrays of integers |
| intagg | PostgreSQL | CONTRIB | CONTRIB | integer aggregator and enumerator (obsolete) |
| dict_int | PostgreSQL | CONTRIB | CONTRIB | text search dictionary template for integers |
| unaccent | PostgreSQL | CONTRIB | CONTRIB | text search dictionary that removes accents |
ADMIN
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| pg_repack | BSD 3-Clause | PGDG | PGDG | Reorganize tables in PostgreSQL databases with minimal locks |
| pg_squeeze | BSD 2-Clause | PGDG | PGDG | A tool to remove unused space from a relation. |
| pg_dirtyread | BSD 3-Clause | PIGSTY | PGDG | Read dead but unvacuumed rows from table |
| pgfincore | BSD 3-Clause | PGDG | PGDG | examine and manage the os buffer cache |
| pg_cooldown | Apache-2.0 | PIGSTY | PIGSTY | remove buffered pages for specific relations |
| ddlx | PostgreSQL | PIGSTY | PIGSTY | DDL eXtractor functions |
| prioritize | PostgreSQL | PGDG | PGDG | get and set the priority of PostgreSQL backends |
| pg_checksums | BSD 2-Clause | PGDG | PGDG | Activate/deactivate/verify checksums in offline Postgres clusters |
| pg_readonly | PostgreSQL | PGDG | PGDG | cluster database read only |
| pg_upless | PostgreSQL | PIGSTY | PIGSTY | Detect Useless UPDATE |
| pg_permissions | BSD 2-Clause | PGDG | PIGSTY | view object permissions and compare them with the desired state |
| pgautofailover | PostgreSQL | PGDG | PGDG | pg_auto_failover |
| pg_catcheck | BSD 3-Clause | PGDG | PGDG | Diagnosing system catalog corruption |
| pre_prepare | PostgreSQL | PIGSTY | PGDG | Pre Prepare your Statement server side |
| pgcozy | PostgreSQL | PIGSTY | PIGSTY | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. |
| pg_orphaned | PostgreSQL | PIGSTY | PIGSTY | Deal with orphaned files |
| pg_crash | BSD 3-Clause | PIGSTY | PIGSTY | Send random signals to random processes |
| pg_cheat_funcs | PostgreSQL | PIGSTY | PIGSTY | Provides cheat (but useful) functions |
| fio | BSD 3-Clause | PIGSTY | PIGSTY | PostgreSQL File I/O Functions |
| pg_savior | Apache-2.0 | PIGSTY | PIGSTY | Postgres extension to save OOPS mistakes |
| safeupdate | ISC | PGDG | PGDG | Require criteria for UPDATE and DELETE |
| pg_drop_events | PostgreSQL | PGDG | PIGSTY | logs transaction ids of drop table, drop column, drop materialized view statements |
| table_log | PostgreSQL | PIGSTY | PGDG | record table modification logs and PITR for table/row |
| pgagent | PostgreSQL | PGDG | PGDG | A PostgreSQL job scheduler |
| pg_prewarm | PostgreSQL | CONTRIB | CONTRIB | prewarm relation data |
| pgpool_adm | PostgreSQL | PGDG | PGDG | Administrative functions for pgPool |
| pgpool_recovery | PostgreSQL | PGDG | PGDG | recovery functions for pgpool-II for V4.3 |
| lo | PostgreSQL | CONTRIB | CONTRIB | Large Object maintenance |
| pgpool_regclass | PostgreSQL | PGDG | PGDG | replacement for regclass |
| basic_archive | PostgreSQL | CONTRIB | CONTRIB | an example of an archive module |
| basebackup_to_shell | PostgreSQL | CONTRIB | CONTRIB | adds a custom basebackup target called shell |
| old_snapshot | PostgreSQL | CONTRIB | CONTRIB | utilities in support of old_snapshot_threshold |
| adminpack | PostgreSQL | CONTRIB | CONTRIB | administrative functions for PostgreSQL |
| amcheck | PostgreSQL | CONTRIB | CONTRIB | functions for verifying relation integrity |
| pg_surgery | PostgreSQL | CONTRIB | CONTRIB | extension to perform surgery on a damaged relation |
STAT
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| pg_profile | BSD 2-Clause | PGDG | PIGSTY | PostgreSQL load profile repository and report builder |
| pg_tracing | MIT | PIGSTY | PIGSTY | Distributed Tracing for PostgreSQL |
| pg_show_plans | PostgreSQL | PGDG | PGDG | show query plans of all currently running SQL statements |
| pg_stat_kcache | BSD 3-Clause | PGDG | PGDG | Kernel statistics gathering |
| pg_stat_monitor | BSD 3-Clause | PGDG | PIGSTY | 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_qualstats | BSD 3-Clause | PGDG | PGDG | An extension collecting statistics about quals |
| pg_store_plans | BSD 3-Clause | PIGSTY | PIGSTY | track plan statistics of all SQL statements executed |
| pg_track_settings | PostgreSQL | PGDG | PGDG | Track settings changes |
| pg_wait_sampling | PostgreSQL | PGDG | PGDG | sampling based statistics of wait events |
| system_stats | PostgreSQL | PGDG | PIGSTY | EnterpriseDB system statistics for PostgreSQL |
| meta | BSD 2-Clause | PIGSTY | PIGSTY | Normalized, friendlier system catalog for PostgreSQL |
| pgnodemx | Apache-2.0 | PIGSTY | PIGSTY | Capture node OS metrics via SQL queries |
| pg_proctab | BSD 3-Clause | PIGSTY | PIGSTY | PostgreSQL extension to access the OS process table |
| pg_sqlog | BSD 3-Clause | PIGSTY | PIGSTY | Provide SQL interface to logs |
| bgw_replstatus | PostgreSQL | PGDG | PGDG | Small PostgreSQL background worker to report whether a node is a replication master or standby |
| pgmeminfo | MIT | PIGSTY | PIGSTY | show memory usage |
| toastinfo | PostgreSQL | PIGSTY | PIGSTY | show details on toasted datums |
| explain_ui | PostgreSQL | PIGSTY | PIGSTY | easily jump into a visual plan UI for any SQL query |
| pg_relusage | PostgreSQL | PIGSTY | PIGSTY | Log all the queries that reference a particular column |
| pagevis | MIT | PIGSTY | PIGSTY | Visualise database pages in ascii code |
| powa | PostgreSQL | PGDG | PGDG | PostgreSQL Workload Analyser-core |
| pageinspect | PostgreSQL | CONTRIB | CONTRIB | inspect the contents of database pages at a low level |
| pgrowlocks | PostgreSQL | CONTRIB | CONTRIB | show row-level locking information |
| sslinfo | PostgreSQL | CONTRIB | CONTRIB | information about SSL certificates |
| pg_buffercache | PostgreSQL | CONTRIB | CONTRIB | examine the shared buffer cache |
| pg_walinspect | PostgreSQL | CONTRIB | CONTRIB | functions to inspect contents of PostgreSQL Write-Ahead Log |
| pg_freespacemap | PostgreSQL | CONTRIB | CONTRIB | examine the free space map (FSM) |
| pg_visibility | PostgreSQL | CONTRIB | CONTRIB | examine the visibility map (VM) and page-level visibility info |
| pgstattuple | PostgreSQL | CONTRIB | CONTRIB | show tuple-level statistics |
| auto_explain | PostgreSQL | CONTRIB | CONTRIB | Provides a means for logging execution plans of slow statements automatically |
| pg_stat_statements | PostgreSQL | CONTRIB | CONTRIB | track planning and execution statistics of all SQL statements executed |
SEC
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| passwordcheck_cracklib | LGPL-2.1 | PGDG | PIGSTY | Strengthen PostgreSQL user password checks with cracklib |
| supautils | Apache-2.0 | PIGSTY | PIGSTY | Extension that secures a cluster on a cloud environment |
| pgsodium | BSD 3-Clause | PIGSTY | PIGSTY | Postgres extension for libsodium functions |
| supabase_vault | Apache-2.0 | PIGSTY | PIGSTY | Supabase Vault Extension |
| pg_session_jwt | Apache-2.0 | PIGSTY | PIGSTY | Manage authentication sessions using JWTs |
| anon | PostgreSQL | PIGSTY | PIGSTY | PostgreSQL Anonymizer (anon) extension |
| pg_tde | MIT | PIGSTY | PIGSTY | pg_tde access method |
| pgsmcrypto | MIT | PIGSTY | PIGSTY | PostgreSQL SM Algorithm Extension |
| pgaudit | PostgreSQL | PGDG | PGDG | provides auditing functionality |
| pgauditlogtofile | PostgreSQL | PGDG | PGDG | pgAudit addon to redirect audit log to an independent file |
| pg_auth_mon | MIT | PGDG | PIGSTY | monitor connection attempts per user |
| credcheck | MIT | PGDG | PGDG | credcheck - postgresql plain text credential checker |
| pgcryptokey | PostgreSQL | PIGSTY | PIGSTY | cryptographic key management |
| pg_jobmon | PostgreSQL | PGDG | PIGSTY | Extension for logging and monitoring functions in PostgreSQL |
| logerrors | BSD 3-Clause | PGDG | PIGSTY | Function for collecting statistics about messages in logfile |
| login_hook | GPL-3.0 | PGDG | PIGSTY | login_hook - hook to execute login_hook.login() at login time |
| set_user | PostgreSQL | PGDG | PGDG | similar to SET ROLE but with added logging |
| pg_snakeoil | PostgreSQL | PIGSTY | PGDG | The PostgreSQL Antivirus |
| pgextwlist | PostgreSQL | PIGSTY | PIGSTY | PostgreSQL Extension Whitelisting |
| pg_auditor | BSD 3-Clause | PIGSTY | PIGSTY | Audit data changes and provide flashback ability |
| sslutils | PostgreSQL | PIGSTY | PIGSTY | A Postgres extension for managing SSL certificates through SQL |
| noset | AGPL-3.0 | PIGSTY | PIGSTY | Module for blocking SET variables for non-super users. |
| sepgsql | PostgreSQL | CONTRIB | CONTRIB | label-based mandatory access control (MAC) based on SELinux security policy. |
| auth_delay | PostgreSQL | CONTRIB | CONTRIB | pause briefly before reporting authentication failure |
| pgcrypto | PostgreSQL | CONTRIB | CONTRIB | cryptographic functions |
| passwordcheck | PostgreSQL | CONTRIB | CONTRIB | checks user passwords and reject weak password |
FDW
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| wrappers | Apache-2.0 | PIGSTY | PIGSTY | Foreign data wrappers developed by Supabase |
| multicorn | PostgreSQL | PGDG | - | Fetch foreign data in Python in your PostgreSQL server. |
| odbc_fdw | PostgreSQL | PGDG | - | Foreign data wrapper for accessing remote databases using ODBC |
| jdbc_fdw | PostgreSQL | PGDG | - | foreign-data wrapper for remote servers available over JDBC |
| mysql_fdw | BSD 3-Clause | PGDG | PGDG | Foreign data wrapper for querying a MySQL server |
| oracle_fdw | PostgreSQL | PGDG | PGDG | foreign data wrapper for Oracle access |
| tds_fdw | PostgreSQL | PGDG | PGDG | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
| db2_fdw | PostgreSQL | PGDG | - | foreign data wrapper for DB2 access |
| sqlite_fdw | PostgreSQL | PGDG | PGDG | SQLite Foreign Data Wrapper |
| pgbouncer_fdw | PostgreSQL | PGDG | - | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions |
| mongo_fdw | LGPL-3.0 | PGDG | - | foreign data wrapper for MongoDB access |
| redis_fdw | PostgreSQL | PIGSTY | PIGSTY | Foreign data wrapper for querying a Redis server |
| redis | MIT | PIGSTY | PIGSTY | Send redis pub/sub messages to Redis from PostgreSQL Directly |
| kafka_fdw | PostgreSQL | PIGSTY | PIGSTY | kafka Foreign Data Wrapper for CSV formatted messages |
| hdfs_fdw | BSD 3-Clause | PGDG | - | foreign-data wrapper for remote hdfs servers |
| firebird_fdw | PostgreSQL | PIGSTY | PIGSTY | Foreign data wrapper for Firebird |
| aws_s3 | Apache-2.0 | PIGSTY | PIGSTY | aws_s3 postgres extension to import/export data from/to s3 |
| log_fdw | Apache-2.0 | PIGSTY | PIGSTY | foreign-data wrapper for Postgres log file access |
| dblink | PostgreSQL | CONTRIB | CONTRIB | connect to other PostgreSQL databases from within a database |
| file_fdw | PostgreSQL | CONTRIB | CONTRIB | foreign-data wrapper for flat file access |
| postgres_fdw | PostgreSQL | CONTRIB | CONTRIB | foreign-data wrapper for remote PostgreSQL servers |
SIM
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| orafce | BSD 0-Clause | PGDG | PGDG | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| pgtt | ISC | PGDG | PGDG | Extension to add Global Temporary Tables feature to PostgreSQL |
| session_variable | GPL-3.0 | PIGSTY | PIGSTY | Registration and manipulation of session variables and constants |
| pg_statement_rollback | ISC | PGDG | PIGSTY | Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
| pg_dbms_metadata | PostgreSQL | PGDG | - | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
| pg_dbms_lock | PostgreSQL | PGDG | - | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
| pg_dbms_job | PostgreSQL | PGDG | - | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
| babelfishpg_common | Apache-2.0 | WILTON | WILTON | SQL Server Transact SQL Datatype Support |
| babelfishpg_tsql | Apache-2.0 | WILTON | WILTON | SQL Server Transact SQL compatibility |
| babelfishpg_tds | Apache-2.0 | WILTON | WILTON | SQL Server TDS protocol extension |
| babelfishpg_money | Apache-2.0 | WILTON | WILTON | SQL Server Money Data Type |
| pgmemcache | MIT | PGDG | PGDG | memcached interface |
ETL
| Name | License | RPM | DEB | Description |
|---|---|---|---|---|
| pglogical | PostgreSQL | PGDG | PGDG | PostgreSQL Logical Replication |
| pglogical_origin | PostgreSQL | PGDG | PGDG | Dummy extension for compatibility when upgrading from Postgres 9.4 |
| pglogical_ticker | PostgreSQL | PIGSTY | PGDG | Have an accurate view on pglogical replication delay |
| pgl_ddl_deploy | MIT | PGDG | PGDG | automated ddl deployment using pglogical |
| pg_failover_slots | PostgreSQL | PIGSTY | PIGSTY | PG Failover Slots extension |
| db_migrator | BSD 3-Clause | PIGSTY | PIGSTY | Tools to migrate other databases to PostgreSQL |
| wal2json | BSD 3-Clause | PGDG | PGDG | Changing data capture in JSON format |
| wal2mongo | Apache-2.0 | PIGSTY | PIGSTY | PostgreSQL logical decoding output plugin for MongoDB |
| decoderbufs | MIT | PGDG | PGDG | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| decoder_raw | PostgreSQL | PIGSTY | PIGSTY | Output plugin for logical replication in Raw SQL format |
| pgoutput | PostgreSQL | CONTRIB | CONTRIB | Logical Replication output plugin |
| test_decoding | PostgreSQL | CONTRIB | CONTRIB | SQL-based test/example module for WAL logical decoding |
| mimeo | PostgreSQL | PIGSTY | PGDG | Extension for specialized, per-table replication between PostgreSQL instances |
| repmgr | GPL-3.0 | PGDG | PGDG | Replication manager for PostgreSQL |
| pg_fact_loader | MIT | PGDG | PGDG | build fact tables with Postgres |
| pg_bulkload | BSD 3-Clause | PGDG | PIGSTY | pg_bulkload is a high speed data loading utility for PostgreSQL |
PIGSTY