Common extensions
From PostgreSQL wiki
Jump to navigationJump to search
See also:
- Joel Jacobson's 2022 list of 1000+ extensions https://www.postgresql.org/message-id/flat/c556d011-c7fd-49bd-8ce4-8993dd074868%40www.fastmail.com
- Database of extensions put together by Deepak Mahto https://pgextensions.org/
- Database of extensions maintained by Evan H. Stanton https://tembo-io.notion.site/postgresql_extension_support-99a3595cffe94437bd233e04e089859a
- Pigsty list of 255 supported extensions (as of May 2024, this isn't on Evan's list) https://www.postgresql.org/about/news/pigsty-v27-released-free-rds-pg-with-255-extensions-available-2863/
.
Starting a table of some common extensions, based on where they are distributed/supported
Sources:
- Debian repo: Packages distributed https://qa.debian.org/developer.php?login=pkg-postgresql-public@lists.alioth.debian.org
- See also Apt/Packages
- PGDG apt: git repo https://git.postgresql.org/gitweb/?p=pgapt.git;a=blob;f=jenkins/pgapt-jobs.yaml
- (build script for PGDG apt packages; i think it's the best place to see what all is included in this repo)
- PGDG yum: git repo https://git.postgresql.org/gitweb/?p=pgrpms.git;a=tree;f=rpm/redhat/16;hb=HEAD
- See also RPM chart for repo https://yum.postgresql.org/rpmchart/
- See also list of extensions at PostgreSQL_16_Extension_Bugs
- PGXN source: https://pgxn.org/
Note: the same extension can have differently named packages in different distribution channels
.
TODO: i've added all packages from the debian repo, still need to check for packages in PGDG apt repo and the PGDG yum repo that aren't here
TODO: add & populate more columns, for example: BSDs? k8s operators? does EDB "stackbuilder" tool install some of these on windows/mac? widely used cloud providers?
TODO: remove entries that aren't distributed in at least two places??
| Extension | Debian repo | PGDG yum | PGXN source | Short Description |
|---|---|---|---|---|
| postgis | yes | yes | no | Geographic objects support |
| pgrouting | yes | yes | no | extends PostGIS to provide geospatial routing functionality |
| pgsql-ogr-fdw | yes | yes | yes | OGR is the vector half of the GDAL spatial data access library |
| hypopg | yes | yes | yes | PostgreSQL extension adding support for hypothetical indexes |
| ip4r | yes | yes | no | IPv4 and IPv6 types |
| orafce | yes | yes | yes | Oracle support functions |
| pg-rage-terminator | yes | no | no | PostgreSQL background worker that kill random sessions |
| pgextwlist | yes | no | no | PostgreSQL Extension Whitelisting |
| pgfincore | yes | yes | no | set of PostgreSQL functions to manage blocks in memory |
| pgl-ddl-deploy | yes | yes | no | Transparent DDL replication |
| pgmemcache | yes | yes | no | PostgreSQL user-defined functions that provide an interface to memcached |
| pgsql-asn1oid | yes | no | no | ASN.1 OID data type |
| pgtap | yes | yes | yes | Unit testing framework |
| plr | yes | yes | no | PostgreSQL user-defined functions that provide an interface to memcached |
| postgresql-debversion | yes | no | no | Debian version number type |
| postgresql-hll | yes | yes | yes | HyperLogLog extension |
| postgresql-pgmp | yes | yes | yes | arbitrary precision integers and rationals for PostgreSQL |
| postgresql-pllua | yes | yes | no | Lua procedural language |
| postgresql-plproxy | yes | no | yes | database partitioning/sharding system |
| postgresql-plsh | yes | yes | no | PL/sh procedural language |
| postgresql-prioritize | yes | yes | yes | Get and set the nice priorities of PostgreSQL backends |
| postgresql-unit | yes | no | no | SI Units (intl system of units) |
| prefix | yes | yes | no | Prefix Range module |
| preprepare | yes | no | no | pre prepare your PostgreSQL statements server side |
| toastinfo | yes | no | no | Show storage structure of varlena datatypes |
| wal2json | yes | yes | no | PostgreSQL logical decoding JSON output plugin |
