DEB List
312 Available PostgreSQL Extensions Deb in Debian / Ubuntu Distributions
Module:
There are 312 extensions available on EL compatible systems, 7 of them are DEB only, missing 21 RPM only extensions.
There are 70 built-in contrib extensions, in addition to 109 deb extensions provided by PGDG APT repository, and 133 deb extensions provided by Pigsty.
Name (URL) | Alias | PackageRepo | Version | Category | License | PG Versions | LOAD |
DDL |
DBSU |
RELOC |
Description | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
timescaledb | timescaledb |
timescaledb-2-postgresql-$v |
PGDG | 2.15.3 | TIME |
Timescale | 16 ,15 ,14 ,13 ,12 |
Enables scalable inserts and complex queries for time-series data (Apache 2 Edition) | ||||
periods | periods |
postgresql-$v-periods |
PGDG | 1.2 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING | ||||
temporal_tables | temporal_tables |
postgresql-$v-temporal-tables |
PIGSTY | 1.2.2 | TIME |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
temporal tables | ||||
emaj | emaj |
postgresql-$v-emaj |
PIGSTY | 4.4.0 | TIME |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
E-Maj extension enables fine-grained write logging and time travel on subsets of the database. | ||||
table_version | table_version |
postgresql-$v-tableversion |
PIGSTY | 1.10.3 | TIME |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL table versioning extension | ||||
pg_cron | pg_cron |
postgresql-$v-cron |
PGDG | 1.6 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Job scheduler for PostgreSQL | ||||
pg_later | pg_later |
postgresql-$v-pg-later |
PIGSTY | 0.1.1 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 |
pg_later: Run queries now and get results later | ||||
pg_background | pg_background |
postgresql-$v-pg-background |
PIGSTY | 1.0 | TIME |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
Run SQL queries in the background | ||||
pg_timetable | pg_timetable |
pg-timetable |
PIGSTY | 5.9.0 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Advanced scheduling for PostgreSQL | ||||
postgis | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS geometry and geography spatial types and functions | ||||
postgis_topology | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS topology spatial types and functions | ||||
postgis_raster | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS raster types and functions | ||||
postgis_sfcgal | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS SFCGAL functions | ||||
postgis_tiger_geocoder | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS tiger geocoder and reverse geocoder | ||||
address_standardizer | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | ||||
address_standardizer_data_us | postgis |
postgresql-$v-postgis-3* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
Address Standardizer US dataset example | ||||
pgrouting | pgrouting |
postgresql-$v-pgrouting* |
PGDG | 3.6.2 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
pgRouting Extension | ||||
pointcloud | pointcloud |
postgresql-$v-pointcloud |
PGDG | 1.2.5 | GIS |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
data type for lidar point clouds | ||||
pointcloud_postgis | pointcloud |
postgresql-$v-pointcloud |
PGDG | 1.2.5 | GIS |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
integration for pointcloud LIDAR data and PostGIS geometry data | ||||
h3 | pg_h3 |
postgresql-$v-h3 |
PGDG | 4.1.3 | GIS |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
H3 bindings for PostgreSQL | ||||
h3_postgis | pg_h3 |
postgresql-$v-h3 |
PGDG | 4.1.3 | GIS |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
H3 PostGIS integration | ||||
q3c | q3c |
postgresql-$v-q3c |
PGDG | 2.0.1 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
q3c sky indexing plugin | ||||
ogr_fdw | ogr_fdw |
postgresql-$v-ogr-fdw |
PGDG | 1.1 | GIS |
MIT | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for GIS data access | ||||
geoip | geoip |
postgresql-$v-geoip |
PIGSTY | 0.3.0 | GIS |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
IP-based geolocation query | ||||
mobilitydb | mobilitydb |
postgresql-$v-mobilitydb |
PGDG | 1.1.1 | GIS |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
MobilityDB geospatial trajectory data management & analysis platform | ||||
earthdistance | earthdistance |
postgresql-$v |
CONTRIB | 1.1 | GIS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
calculate great-circle distances on the surface of the Earth | ||||
vector | pgvector |
postgresql-$v-pgvector |
PGDG | 0.7.3 | RAG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
vector data type and ivfflat and hnsw access methods | ||||
vectorscale | pgvectorscale |
postgresql-$v-pgvectorscale |
PIGSTY | 0.2.0 | RAG |
PostgreSQL | 16 ,15 |
pgvectorscale: Advanced indexing for vector data | ||||
vectorize | pg_vectorize |
postgresql-$v-pg-vectorize |
PIGSTY | 0.17.0 | RAG |
PostgreSQL | 16 ,15 ,14 |
The simplest way to do vector search on Postgres | ||||
pg_similarity | pg_similarity |
postgresql-$v-similarity |
PGDG | 1.0 | RAG |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
support similarity queries | ||||
smlar | smlar |
postgresql-$v-smlar |
PIGSTY | 1.0 | RAG |
PostgreSQL | 15 ,14 ,13 |
Effective similarity search | ||||
pg_tiktoken | pg_tiktoken |
postgresql-$v-pg-tiktoken |
PIGSTY | 0.0.1 | RAG |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres | ||||
pgml | pgml |
postgresql-$v-pgml |
PIGSTY | 2.9.3 | RAG |
MIT | 16 ,15 ,14 |
PostgresML: Run AL/ML workloads with SQL interface | ||||
pg_search | pg_search |
postgresql-$v-pg-search |
PIGSTY | 0.10.2 | FTS |
AGPLv3 | 16 ,15 ,14 |
pg_search: Full text search for PostgreSQL using BM25 | ||||
pg_bigm | pg_bigm |
postgresql-$v-pg-bigm |
PIGSTY | 1.2 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
create 2-gram (bigram) index for faster full text search. | ||||
zhparser | zhparser |
postgresql-$v-zhparser |
PIGSTY | 2.2 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
a parser for full-text search of Chinese | ||||
hunspell_cs_cz | hunspell_cs_cz |
postgresql-$v-hunspell-cs-cz |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Czech Hunspell Dictionary | ||||
hunspell_de_de | hunspell_de_de |
postgresql-$v-hunspell-de-de |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
German Hunspell Dictionary | ||||
hunspell_en_us | hunspell_en_us |
postgresql-$v-hunspell-en-us |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
en_US Hunspell Dictionary | ||||
hunspell_fr | hunspell_fr |
postgresql-$v-hunspell-fr |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
French Hunspell Dictionary | ||||
hunspell_ne_np | hunspell_ne_np |
postgresql-$v-hunspell-ne-np |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Nepali Hunspell Dictionary | ||||
hunspell_nl_nl | hunspell_nl_nl |
postgresql-$v-hunspell-nl-nl |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Dutch Hunspell Dictionary | ||||
hunspell_nn_no | hunspell_nn_no |
postgresql-$v-hunspell-nn-no |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Norwegian (norsk) Hunspell Dictionary | ||||
hunspell_pt_pt | hunspell_pt_pt |
postgresql-$v-hunspell-pt-pt |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Portuguese Hunspell Dictionary | ||||
hunspell_ru_ru | hunspell_ru_ru |
postgresql-$v-hunspell-ru-ru |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Russian Hunspell Dictionary | ||||
hunspell_ru_ru_aot | hunspell_ru_ru_aot |
postgresql-$v-hunspell-ru-ru-aot |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Russian Hunspell Dictionary (from AOT.ru group) | ||||
fuzzystrmatch | fuzzystrmatch |
postgresql-$v |
CONTRIB | 1.2 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
determine similarities and distance between strings | ||||
pg_trgm | pg_trgm |
postgresql-$v |
CONTRIB | 1.6 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text similarity measurement and index searching based on trigrams | ||||
citus | citus |
postgresql-$v-citus-12.1 |
PGDG | 12.1-1 | OLAP |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Distributed PostgreSQL as an extension | ||||
citus_columnar | citus |
postgresql-$v-citus-12.1 |
PGDG | 11.3-1 | OLAP |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Citus columnar storage engine | ||||
columnar | hydra |
postgresql-$v-hydra |
PIGSTY | 11.1-11 | OLAP |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Hydra Columnar extension | ||||
pg_analytics | pg_analytics |
postgresql-$v-pg-analytics |
PIGSTY | 0.1.4 | OLAP |
AGPLv3 | 16 ,15 ,14 |
Postgres for analytics, powered by DuckDB | ||||
pg_lakehouse | pg_lakehouse |
postgresql-$v-pg-lakehouse |
PIGSTY | 0.9.0 | OLAP |
AGPLv3 | 16 ,15 ,14 |
pg_lakehouse: An analytical query engine for Postgres | ||||
duckdb_fdw | duckdb_fdw |
postgresql-$v-duckdb-fdw |
PIGSTY | 1.0.0 | OLAP |
MIT | 16 ,15 ,14 ,13 ,12 |
DuckDB Foreign Data Wrapper | ||||
pg_fkpart | pg_fkpart |
postgresql-$v-pg-fkpart |
PIGSTY | 1.7 | OLAP |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
Table partitioning by foreign key utility | ||||
pg_partman | pg_partman |
postgresql-$v-partman |
PGDG | 5.1.0 | OLAP |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension to manage partitioned tables by time or ID | ||||
plproxy | plproxy |
postgresql-$v-plproxy |
PGDG | 2.11.0 | OLAP |
BSD 0 | 16 ,15 ,14 ,13 ,12 |
Database partitioning implemented as procedural language | ||||
tablefunc | tablefunc |
postgresql-$v |
CONTRIB | 1.0 | OLAP |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions that manipulate whole tables, including crosstab | ||||
age | age |
postgresql-$v-age |
PGDG | 1.5.0 | FEAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
AGE graph database extension | ||||
hll | hll |
postgresql-$v-hll |
PGDG | 2.18 | FEAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
type for storing hyperloglog data | ||||
rum | rum |
postgresql-$v-rum |
PGDG | 1.3 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
RUM index access method | ||||
pg_graphql | pg_graphql |
postgresql-$v-pg-graphql |
PIGSTY | 1.5.7 | FEAT |
Apache-2.0 | 16 ,15 |
pg_graphql: GraphQL support | ||||
pg_jsonschema | pg_jsonschema |
postgresql-$v-pg-jsonschema |
PIGSTY | 0.3.1 | FEAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL extension providing JSON Schema validation | ||||
jsquery | jsquery |
postgresql-$v-jsquery |
PGDG | 1.1 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for jsonb inspection | ||||
pg_hint_plan | pg_hint_plan |
postgresql-$v-pg-hint-plan |
PGDG | 1.6.0 | FEAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Give PostgreSQL ability to manually force some decisions in execution plans. | ||||
hypopg | hypopg |
postgresql-$v-hypopg |
PGDG | 1.4.1 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Hypothetical indexes for PostgreSQL | ||||
index_advisor | index_advisor |
postgresql-$v-index-advisor |
PIGSTY | 0.2.0 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Query index advisor | ||||
imgsmlr | imgsmlr |
postgresql-$v-imgsmlr |
PIGSTY | 1.0 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Image similarity with haar | ||||
pg_ivm | pg_ivm |
postgresql-$v-pg-ivm |
PIGSTY | 1.8 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
incremental view maintenance on PostgreSQL | ||||
pgmq | pgmq |
postgresql-$v-pgmq |
PIGSTY | 1.2.1 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. | ||||
pgq | pgq |
postgresql-$v-pgq3 |
PGDG | 3.5.1 | FEAT |
ISC | 16 ,15 ,14 ,13 ,12 |
Generic queue for PostgreSQL | ||||
rdkit | rdkit |
postgresql-$v-rdkit |
PGDG | 4.3.0 | FEAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Cheminformatics functionality for PostgreSQL. | ||||
bloom | bloom |
postgresql-$v |
CONTRIB | 1.0 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
bloom access method - signature file based index | ||||
pg_tle | pg_tle |
postgresql-$v-pg-tle |
PIGSTY | 1.2.0 | LANG |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Trusted Language Extensions for PostgreSQL | ||||
plv8 | plv8 |
postgresql-$v-plv8 |
PIGSTY | 3.2.2 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/JavaScript (v8) trusted procedural language | ||||
plluau | pllua |
postgresql-$v-pllua |
PGDG | 2.0 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
Lua as an untrusted procedural language | ||||
hstore_plluau | pllua |
postgresql-$v-pllua |
PGDG | 1.0 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
Hstore transform for untrusted Lua | ||||
pllua | pllua |
postgresql-$v-pllua |
PGDG | 2.0 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
Lua as a procedural language | ||||
hstore_pllua | pllua |
postgresql-$v-pllua |
PGDG | 1.0 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
Hstore transform for Lua | ||||
plprql | plprql |
postgresql-$v-plprql |
PIGSTY | 0.1.0 | LANG |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Use PRQL in PostgreSQL - Pipelined Relational Query Language | ||||
pldbgapi | pldebugger |
postgresql-$v-pldebugger |
PGDG | 1.1 | LANG |
Artistic | 16 ,15 ,14 ,13 ,12 |
server-side support for debugging PL/pgSQL functions | ||||
plpgsql_check | plpgsql_check |
postgresql-$v-plpgsql-check |
PGDG | 2.7 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
extended check for plpgsql functions | ||||
plprofiler | plprofiler |
postgresql-$v-plprofiler |
PGDG | 4.2 | LANG |
Artistic | 16 ,15 ,14 ,13 ,12 |
server-side support for profiling PL/pgSQL functions | ||||
plsh | plsh |
postgresql-$v-plsh |
PGDG | 2 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
PL/sh procedural language | ||||
pljava | pljava |
postgresql-$v-pljava |
PGDG | 1.6.6 | LANG |
BSD 3 | 16 |
PL/Java procedural language (https://tada.github.io/pljava/) | ||||
plr | plr |
postgresql-$v-plr |
PGDG | 8.4.6 | LANG |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
load R interpreter and execute R script from within a database | ||||
pgtap | pgtap |
postgresql-$v-pgtap |
PGDG | 1.3.1 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Unit testing for PostgreSQL | ||||
pltcl | pltcl |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/Tcl procedural language | ||||
pltclu | pltcl |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/TclU untrusted procedural language | ||||
plperl | plperl |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/Perl procedural language | ||||
bool_plperl | plperl |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between bool and plperl | ||||
hstore_plperl | plperl |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between hstore and plperl | ||||
jsonb_plperl | plperl |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between jsonb and plperl | ||||
plperlu | plperlu |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/PerlU untrusted procedural language | ||||
bool_plperlu | plperlu |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between bool and plperlu | ||||
jsonb_plperlu | plperlu |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between jsonb and plperlu | ||||
hstore_plperlu | plperlu |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between hstore and plperlu | ||||
plpgsql | plpgsql |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/pgSQL procedural language | ||||
plpython3u | plpython3u |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/Python3U untrusted procedural language | ||||
jsonb_plpython3u | plpython3u |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between jsonb and plpython3u | ||||
ltree_plpython3u | plpython3u |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between ltree and plpython3u | ||||
hstore_plpython3u | plpython3u |
postgresql-$v |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between hstore and plpython3u | ||||
prefix | prefix |
postgresql-$v-prefix |
PGDG | 1.2.0 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Prefix Range module for PostgreSQL | ||||
semver | semver |
postgresql-$v-semver |
PGDG | 0.32.1 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Semantic version data type | ||||
unit | pgunit |
postgresql-$v-unit |
PGDG | 7 | TYPE |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
SI units extension | ||||
md5hash | md5hash |
postgresql-$v-md5hash |
PIGSTY | 1.0.1 | TYPE |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
type for storing 128-bit binary data inline | ||||
asn1oid | asn1oid |
postgresql-$v-asn1oid |
PGDG | 1 | TYPE |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
asn1oid extension | ||||
roaringbitmap | roaringbitmap |
postgresql-$v-roaringbitmap |
PGDG | 0.5 | TYPE |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
support for Roaring Bitmaps | ||||
pgfaceting | pgfaceting |
postgresql-$v-pgfaceting |
PGDG | 0.2.0 | TYPE |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
fast faceting queries using an inverted index | ||||
pg_sphere | pgsphere |
postgresql-$v-pgsphere |
PGDG | 1.5.1 | TYPE |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
spherical objects with useful functions, operators and index support | ||||
country | pg_country |
postgresql-$v-pg-country |
PIGSTY | 0.0.3 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Country data type, ISO 3166-1 | ||||
currency | pg_currency |
postgresql-$v-pg-currency |
PIGSTY | 0.0.3 | TYPE |
MIT | 16 ,15 ,14 ,13 ,12 |
Custom PostgreSQL currency type in 1Byte | ||||
pgmp | pgmp |
postgresql-$v-pgmp |
PGDG | 1.1 | TYPE |
LGPLv3 | 16 ,15 ,14 ,13 ,12 |
Multiple Precision Arithmetic extension | ||||
numeral | numeral |
postgresql-$v-numeral |
PGDG | 1 | TYPE |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
numeral datatypes extension | ||||
pg_rational | pg_rational |
postgresql-$v-rational |
PGDG | 0.0.2 | TYPE |
MIT | 16 ,15 ,14 ,13 ,12 |
bigint fractions | ||||
uint | pguint |
postgresql-$v-pguint |
PIGSTY | 0 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
unsigned integer types | ||||
ip4r | ip4r |
postgresql-$v-ip4r |
PGDG | 2.4 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
IPv4/v6 and IPv4/v6 range index type for PostgreSQL | ||||
uri | pg_uri |
postgresql-$v-pg-uri |
PIGSTY | 1.20151224 | TYPE |
PostgreSQL | 15 ,14 ,13 ,12 |
URI Data type for PostgreSQL | ||||
pgemailaddr | pgemailaddr |
postgresql-$v$v-pg-emailaddr |
PIGSTY | 0 | TYPE |
PostgreSQL | 15 ,14 ,13 ,12 |
Email address type for PostgreSQL | ||||
acl | acl |
postgresql-$v-acl |
PIGSTY | 1.0.4 | TYPE |
BSD-2 | 15 ,14 ,13 ,12 |
ACL Data type | ||||
debversion | debversion |
postgresql-$v-debversion |
PGDG | 1.1 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Debian version number data type | ||||
pg_rrule | pg_rrule |
postgresql-$v-pg-rrule |
PGDG | 0.2.0 | TYPE |
MIT | 16 ,15 ,14 ,13 ,12 |
RRULE field type for PostgreSQL | ||||
chkpass | chkpass |
postgresql-$v-chkpass |
PIGSTY | 1.0 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for auto-encrypted passwords | ||||
isn | isn |
postgresql-$v |
CONTRIB | 1.2 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data types for international product numbering standards | ||||
seg | seg |
postgresql-$v |
CONTRIB | 1.4 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for representing line segments or floating-point intervals | ||||
cube | cube |
postgresql-$v |
CONTRIB | 1.5 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for multidimensional cubes | ||||
ltree | ltree |
postgresql-$v |
CONTRIB | 1.2 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for hierarchical tree-like structures | ||||
hstore | hstore |
postgresql-$v |
CONTRIB | 1.8 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for storing sets of (key, value) pairs | ||||
citext | citext |
postgresql-$v |
CONTRIB | 1.6 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for case-insensitive character strings | ||||
xml2 | xml2 |
postgresql-$v |
CONTRIB | 1.1 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
XPath querying and XSLT | ||||
topn | topn |
postgresql-$v-topn |
PGDG | 2.6.0 | FUNC |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
type for top-n JSONB | ||||
gzip | pg_gzip |
postgresql-$v-gzip |
PIGSTY | 1.0 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
gzip and gunzip functions. | ||||
zstd | pg_zstd |
postgresql-$v-pg-zstd |
PIGSTY | 1.1.0 | FUNC |
ISC | 15 ,14 ,13 ,12 |
Zstandard compression algorithm implementation in PostgreSQL | ||||
http | pg_http |
postgresql-$v-http |
PGDG | 1.6 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
HTTP client for PostgreSQL, allows web page retrieval inside the database. | ||||
pg_net | pg_net |
postgresql-$v-pg-net |
PIGSTY | 0.9.2 | FUNC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Async HTTP Requests | ||||
pg_html5_email_address | pg_html5_email_address |
postgresql-$v-pg-html5-email-address |
PIGSTY | 1.2.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL email validation that is consistent with the HTML5 spec | ||||
pgsql_tweaks | pgsql_tweaks |
postgresql-$v-pgsql-tweaks |
PIGSTY | 0.10.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Some functions and views for daily usage | ||||
pg_extra_time | pg_extra_time |
postgresql-$v-pg-extra-time |
PIGSTY | 1.1.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Some date time functions and operators that, | ||||
timeit | pg_timeit |
postgresql-$v-pg-timeit |
PIGSTY | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
High-accuracy timing of SQL expressions | ||||
count_distinct | count_distinct |
postgresql-$v-count-distinct |
PIGSTY | 3.0.1 | FUNC |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate | ||||
extra_window_functions | extra_window_functions |
postgresql-$v-extra-window-functions |
PGDG | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extra Window Functions for PostgreSQL | ||||
first_last_agg | first_last_agg |
postgresql-$v-first-last-agg |
PGDG | 0.1.4 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
first() and last() aggregate functions | ||||
tdigest | tdigest |
postgresql-$v-tdigest |
PGDG | 1.4.1 | FUNC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Provides tdigest aggregate function. | ||||
aggs_for_vecs | aggs_for_vecs |
postgresql-$v-aggs-for-vecs |
PIGSTY | 1.3.0 | FUNC |
MIT | 15 ,14 ,13 ,12 |
Aggregate functions for array inputs | ||||
aggs_for_arrays | aggs_for_arrays |
postgresql-$v-aggs-for-arrays |
PIGSTY | 1.3.2 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Various functions for computing statistics on arrays of numbers | ||||
arraymath | pg_arraymath |
postgresql-$v-pg-arraymath |
PIGSTY | 1.1 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Array math and operators that work element by element on the contents of arrays | ||||
quantile | quantile |
postgresql-$v-quantile |
PIGSTY | 1.1.7 | FUNC |
BSD | 15 ,14 ,13 ,12 |
Quantile aggregation function | ||||
lower_quantile | lower_quantile |
postgresql-$v-lower-quantile |
PIGSTY | 1.0.0 | FUNC |
BSD-2 | 15 ,14 ,13 ,12 |
Lower quantile aggregate function | ||||
pg_idkit | pg_idkit |
postgresql-$v-pg-idkit |
PIGSTY | 0.2.3 | FUNC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) | ||||
pg_uuidv7 | pg_uuidv7 |
postgresql-$v-pg-uuidv7 |
PIGSTY | 1.5 | FUNC |
MPLv2 | 16 ,15 ,14 ,13 ,12 |
pg_uuidv7: create UUIDv7 values in postgres | ||||
permuteseq | permuteseq |
postgresql-$v-permuteseq |
PIGSTY | 1.2 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Pseudo-randomly permute sequences with a format-preserving encryption on elements | ||||
pg_hashids | pg_hashids |
postgresql-$v-pg-hashids |
PIGSTY | 1.3 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Short unique id generator for PostgreSQL, using hashids | ||||
sequential_uuids | sequential_uuids |
postgresql-$v-sequential-uuids |
PIGSTY | 1.0.2 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
generator of sequential UUIDs | ||||
pg_math | pg_math |
postgresql-$v-pg-math |
PIGSTY | 1.0 | FUNC |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
GSL statistical functions for postgresql | ||||
random | pg_random |
postgresql-$v-random |
PIGSTY | 2.0.0-dev | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
random data generator | ||||
base36 | pg_base36 |
postgresql-$v-base36 |
PIGSTY | 1.0.0 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Integer Base36 types | ||||
base62 | pg_base62 |
postgresql-$v-base62 |
PIGSTY | 0.0.1 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Base62 extension for PostgreSQL | ||||
floatvec | floatvec |
postgresql-$v-floatvec |
PIGSTY | 1.0.1 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Math for vectors (arrays) of numbers | ||||
financial | pg_financial |
postgresql-$v-pg-financial |
PIGSTY | 1.0.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Financial aggregate functions | ||||
pgjwt | pgjwt |
postgresql-$v-pgjwt |
PIGSTY | 0.2.0 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
JSON Web Token API for Postgresql | ||||
pg_hashlib | pg_hashlib |
postgresql-$v-pg-hashlib |
PIGSTY | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Stable hash functions for Postgres | ||||
shacrypt | shacrypt |
postgresql-$v-shacrypt |
PIGSTY | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes | ||||
cryptint | cryptint |
postgresql-$v-cryptint |
PIGSTY | 1.0.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Encryption functions for int and bigint values | ||||
pguecc | pg_ecdsa |
postgresql-$v-pg-ecdsa |
PIGSTY | 1.0 | FUNC |
BSD-2 | 16 ,15 ,14 ,13 ,12 |
uECC bindings for Postgres | ||||
pgpcre | pgpcre |
postgresql-$v-pgpcre |
PGDG | 1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Perl Compatible Regular Expression functions | ||||
icu_ext | icu_ext |
postgresql-$v-icu-ext |
PGDG | 1.8 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Access ICU functions | ||||
pgqr | pgqr |
postgresql-$v-pgqr |
PIGSTY | 1.0 | FUNC |
BSD-3 | 15 ,14 ,13 ,12 |
QR Code generator from PostgreSQL | ||||
envvar | envvar |
postgresql-$v-pg-envvar |
PIGSTY | 1.0.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Fetch the value of an environment variable | ||||
pg_protobuf | pg_protobuf |
postgresql-$v-pg-protobuf |
PIGSTY | 1.0 | FUNC |
MIT | 15 ,14 ,13 ,12 |
Protobuf support for PostgreSQL | ||||
url_encode | url_encode |
postgresql-$v-url-encode |
PIGSTY | 1.2.5 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
url_encode, url_decode functions | ||||
refint | refint |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for implementing referential integrity (obsolete) | ||||
autoinc | autoinc |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for autoincrementing fields | ||||
insert_username | insert_username |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for tracking who changed a table | ||||
moddatetime | moddatetime |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for tracking last modification time | ||||
tsm_system_time | tsm_system_time |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
TABLESAMPLE method which accepts time in milliseconds as a limit | ||||
dict_xsyn | dict_xsyn |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text search dictionary template for extended synonym processing | ||||
tsm_system_rows | tsm_system_rows |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
TABLESAMPLE method which accepts number of rows as a limit | ||||
tcn | tcn |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Triggered change notifications | ||||
uuid-ossp | uuid-ossp |
postgresql-$v |
CONTRIB | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
generate universally unique identifiers (UUIDs) | ||||
btree_gist | btree_gist |
postgresql-$v |
CONTRIB | 1.7 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
support for indexing common datatypes in GiST | ||||
btree_gin | btree_gin |
postgresql-$v |
CONTRIB | 1.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
support for indexing common datatypes in GIN | ||||
intarray | intarray |
postgresql-$v |
CONTRIB | 1.5 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions, operators, and index support for 1-D arrays of integers | ||||
intagg | intagg |
postgresql-$v |
CONTRIB | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
integer aggregator and enumerator (obsolete) | ||||
dict_int | dict_int |
postgresql-$v |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text search dictionary template for integers | ||||
unaccent | unaccent |
postgresql-$v |
CONTRIB | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text search dictionary that removes accents | ||||
pg_repack | pg_repack |
postgresql-$v-repack |
PGDG | 1.5.0 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Reorganize tables in PostgreSQL databases with minimal locks | ||||
pg_squeeze | pg_squeeze |
postgresql-$v-squeeze |
PGDG | 1.6 | ADMIN |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
A tool to remove unused space from a relation. | ||||
pg_dirtyread | pg_dirtyread |
postgresql-$v-dirtyread |
PGDG | 2 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Read dead but unvacuumed rows from table | ||||
pgfincore | pgfincore |
postgresql-$v-pgfincore |
PGDG | 1.3.1 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
examine and manage the os buffer cache | ||||
pgdd | pgdd |
postgresql-$v-pgdd |
PIGSTY | 0.5.2 | ADMIN |
MIT | 16 ,15 ,14 ,13 ,12 |
An in-database data dictionary providing database introspection via standard SQL query syntax. Developed using pgx (https://github.com/zombodb/pgx). | ||||
ddlx | ddlx |
postgresql-$v-ddlx |
PIGSTY | 0.27 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
DDL eXtractor functions | ||||
prioritize | pg_prioritize |
postgresql-16-prioritize |
PGDG | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
get and set the priority of PostgreSQL backends | ||||
pg_checksums | pg_checksums |
postgresql-$v-pg-checksums |
PGDG | 1.1 | ADMIN |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
Activate/deactivate/verify checksums in offline Postgres clusters | ||||
pg_readonly | pg_readonly |
postgresql-$v-pg-readonly |
PGDG | 1.0.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
cluster database read only | ||||
safeupdate | safeupdate |
postgresql-$v-pg-safeupdate |
PGDG | 1.4 | ADMIN |
ISC | 16 ,15 ,14 ,13 ,12 |
Require criteria for UPDATE and DELETE | ||||
pg_permissions | pg_permissions |
postgresql-$v-pg-permissions |
PIGSTY | 1.3 | ADMIN |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
view object permissions and compare them with the desired state | ||||
pgautofailover | pgautofailover |
postgresql-16-auto-failover |
PGDG | 2.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
pg_auto_failover | ||||
pg_catcheck | pg_catcheck |
postgresql-$v-pg-catcheck |
PGDG | 1.4.0 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Diagnosing system catalog corruption | ||||
pre_prepare | preprepare |
postgresql-$v-preprepare |
PGDG | 0.4 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Pre Prepare your Statement server side | ||||
pgcozy | pgcozy |
postgresql-$v-pgcozy |
PIGSTY | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. | ||||
pg_orphaned | pg_orphaned |
postgresql-$v-pg-orphaned |
PIGSTY | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Deal with orphaned files | ||||
pg_crash | pg_crash |
postgresql-$v-pg-crash |
PIGSTY | 1.0 | ADMIN |
BSD-3 | 16 ,15 ,14 ,13 ,12 |
Send random signals to random processes | ||||
pg_cheat_funcs | pg_cheat_funcs |
postgresql-$v-pg-cheat-funcs |
PIGSTY | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Provides cheat (but useful) functions | ||||
pg_savior | pg_savior |
postgresql-$v-pg-savior |
PIGSTY | 0.0.1 | ADMIN |
Apache-2.0 | 16 ,15 ,14 ,13 |
Postgres extension to save OOPS mistakes | ||||
table_log | table_log |
postgresql-$v-tablelog |
PGDG | 0.6.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
record table modification logs and PITR for table/row | ||||
pg_fio | pg_fio |
postgresql-$v-pg-fio |
PIGSTY | 1.0 | ADMIN |
BSD-3 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL File I/O Functions | ||||
pgpool_adm | pgpool |
postgresql-$v-pgpool2 |
PGDG | 1.5 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Administrative functions for pgPool | ||||
pgpool_recovery | pgpool |
postgresql-$v-pgpool2 |
PGDG | 1.4 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
recovery functions for pgpool-II for V4.3 | ||||
pgpool_regclass | pgpool |
postgresql-$v-pgpool2 |
PGDG | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
replacement for regclass | ||||
pgagent | pgagent |
pgagent |
PGDG | 4.2 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
A PostgreSQL job scheduler | ||||
vacuumlo | vacuumlo |
postgresql-$v |
CONTRIB | 16.3 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
utility program that will remove any orphaned large objects from a PostgreSQL database | ||||
pg_prewarm | pg_prewarm |
postgresql-$v |
CONTRIB | 1.2 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
prewarm relation data | ||||
oid2name | oid2name |
postgresql-$v |
CONTRIB | 16.3 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
utility program that helps administrators to examine the file structure used by PostgreSQL | ||||
lo | lo |
postgresql-$v |
CONTRIB | 1.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Large Object maintenance | ||||
basic_archive | basic_archive |
postgresql-$v |
CONTRIB | 16.3 | ADMIN |
PostgreSQL | 16 ,15 |
an example of an archive module | ||||
basebackup_to_shell | basebackup_to_shell |
postgresql-$v |
CONTRIB | 16.3 | ADMIN |
PostgreSQL | 16 ,15 |
adds a custom basebackup target called shell | ||||
old_snapshot | old_snapshot |
postgresql-$v |
CONTRIB | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 |
utilities in support of old_snapshot_threshold | ||||
adminpack | adminpack |
postgresql-$v |
CONTRIB | 2.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
administrative functions for PostgreSQL | ||||
amcheck | amcheck |
postgresql-$v |
CONTRIB | 1.3 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for verifying relation integrity | ||||
pg_surgery | pg_surgery |
postgresql-$v |
CONTRIB | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 |
extension to perform surgery on a damaged relation | ||||
pg_profile | pg_profile |
postgresql-$v-pg-profile |
PIGSTY | 4.6 | STAT |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL load profile repository and report builder | ||||
pg_show_plans | pg_show_plans |
postgresql-$v-show-plans |
PGDG | 2.1 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show query plans of all currently running SQL statements | ||||
pg_stat_kcache | pg_stat_kcache |
postgresql-$v-pg-stat-kcache |
PGDG | 2.2.3 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Kernel statistics gathering | ||||
pg_stat_monitor | pg_stat_monitor |
postgresql-$v-pg-stat-monitor |
PIGSTY | 2.0 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
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 | pg_qualstats |
postgresql-$v-pg-qualstats |
PGDG | 2.1.0 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
An extension collecting statistics about quals | ||||
pg_store_plans | pg_store_plans |
postgresql-$v-pg-store-plan |
PIGSTY | 1.8 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
track plan statistics of all SQL statements executed | ||||
pg_track_settings | pg_track_settings |
postgresql-$v-pg-track-settings |
PGDG | 2.1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Track settings changes | ||||
pg_wait_sampling | pg_wait_sampling |
postgresql-$v-pg-wait-sampling |
PGDG | 1.1 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
sampling based statistics of wait events | ||||
system_stats | system_stats |
postgresql-$v-system-stats |
PIGSTY | 2.0 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
EnterpriseDB system statistics for PostgreSQL | ||||
meta | pg_meta |
postgresql-$v-pg-meta |
PIGSTY | 0.4.0 | STAT |
BSD-2 | 16 ,15 ,14 ,13 ,12 |
Normalized, friendlier system catalog for PostgreSQL | ||||
pgnodemx | pgnodemx |
postgresql-$v-pgnodemx |
PIGSTY | 1.6 | STAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Capture node OS metrics via SQL queries | ||||
pg_proctab | pgnodemx |
postgresql-$v-pgnodemx |
PIGSTY | 0.0.10-compat | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL extension to access the OS process table | ||||
pg_sqlog | pg_sqlog |
postgresql-$v-pg-sqlog |
PIGSTY | 1.6 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Provide SQL interface to logs | ||||
bgw_replstatus | bgw_replstatus |
postgresql-$v-bgw-replstatus |
PGDG | 1.0.6 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Small PostgreSQL background worker to report whether a node is a replication master or standby | ||||
pgmeminfo | pgmeminfo |
postgresql-$v-pgmeminfo |
PIGSTY | 1.0 | STAT |
MIT | 16 ,15 ,14 ,13 ,12 |
show memory usage | ||||
toastinfo | toastinfo |
postgresql-$v-toastinfo |
PIGSTY | 1 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show details on toasted datums | ||||
pg_mon | pg_mon |
postgresql-$v-pg-mon |
PIGSTY | 1.0 | STAT |
MIT | 15 ,14 ,13 ,12 |
PostgreSQL extension to enhance query monitoring | ||||
pg_statviz | pg_statviz |
postgresql-$v-statviz |
PGDG | 0.6 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
stats visualization and time series analysis | ||||
pagevis | pagevis |
postgresql-$v-pagevis |
PIGSTY | 0.1 | STAT |
MIT | 16 ,15 ,14 ,13 ,12 |
Visualise database pages in ascii code | ||||
powa | powa |
postgresql-$v-powa |
PGDG | 4.2.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL Workload Analyser-core | ||||
pageinspect | pageinspect |
postgresql-$v |
CONTRIB | 1.12 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
inspect the contents of database pages at a low level | ||||
pgrowlocks | pgrowlocks |
postgresql-$v |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show row-level locking information | ||||
sslinfo | sslinfo |
postgresql-$v |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
information about SSL certificates | ||||
pg_buffercache | pg_buffercache |
postgresql-$v |
CONTRIB | 1.4 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
examine the shared buffer cache | ||||
pg_walinspect | pg_walinspect |
postgresql-$v |
CONTRIB | 1.1 | STAT |
PostgreSQL | 16 ,15 |
functions to inspect contents of PostgreSQL Write-Ahead Log | ||||
pg_freespacemap | pg_freespacemap |
postgresql-$v |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
examine the free space map (FSM) | ||||
pg_visibility | pg_visibility |
postgresql-$v |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
examine the visibility map (VM) and page-level visibility info | ||||
pgstattuple | pgstattuple |
postgresql-$v |
CONTRIB | 1.5 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show tuple-level statistics | ||||
auto_explain | auto_explain |
postgresql-$v |
CONTRIB | 16.3 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Provides a means for logging execution plans of slow statements automatically | ||||
pg_stat_statements | pg_stat_statements |
postgresql-$v |
CONTRIB | 1.10 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
track planning and execution statistics of all SQL statements executed | ||||
passwordcheck_cracklib | passwordcheck |
postgresql-$v-passwordcheck-cracklib |
PIGSTY | 3.0.0 | SEC |
LGPLv2 | 16 ,15 ,14 ,13 ,12 |
Strengthen PostgreSQL user password checks with cracklib | ||||
supautils | supautils |
postgresql-$v-supautils |
PIGSTY | 3.1.9 | SEC |
Apache-2.0 | 16 ,15 ,14 ,13 |
Extension that secures a cluster on a cloud environment | ||||
pgsodium | pgsodium |
postgresql-$v-pgsodium |
PIGSTY | 3.1.9 | SEC |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Postgres extension for libsodium functions | ||||
supabase_vault | pg_vault |
postgresql-$v-vault |
PIGSTY | 0.2.8 | SEC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Supabase Vault Extension | ||||
anon | anonymizer |
postgresql-$v-anonymizer |
PIGSTY | 1.3.2 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Data anonymization tools | ||||
pg_tde | pg_tde |
postgresql-$v-pg-tde |
PIGSTY | 1.0 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
pg_tde access method | ||||
pgsmcrypto | pgsmcrypto |
postgresql-$v-pgsmcrypto |
PIGSTY | 0.1.0 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
PostgreSQL SM Algorithm Extension | ||||
pgaudit | pgaudit |
postgresql-$v-pgaudit |
PGDG | 16.0 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
provides auditing functionality | ||||
pgauditlogtofile | pgauditlogtofile |
postgresql-$v-pgauditlogtofile |
PGDG | 1.6 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
pgAudit addon to redirect audit log to an independent file | ||||
pg_auth_mon | pg_auth_mon |
postgresql-$v-pg-auth-mon |
PIGSTY | 1.1 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
monitor connection attempts per user | ||||
credcheck | credcheck |
postgresql-$v-credcheck |
PGDG | 2.7.0 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
credcheck - postgresql plain text credential checker | ||||
pgcryptokey | pgcryptokey |
postgresql-$v-pgcryptokey |
PIGSTY | 1.0 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
cryptographic key management | ||||
pg_jobmon | pg_jobmon |
postgresql-$v-pg-jobmon |
PIGSTY | 1.4.1 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension for logging and monitoring functions in PostgreSQL | ||||
logerrors | logerrors |
postgresql-$v-logerrors |
PIGSTY | 2.1 | SEC |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Function for collecting statistics about messages in logfile | ||||
login_hook | login_hook |
postgresql-$v-login-hook |
PIGSTY | 1.5 | SEC |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
login_hook - hook to execute login_hook.login() at login time | ||||
set_user | set_user |
postgresql-$v-set-user |
PGDG | 4.0.1 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
similar to SET ROLE but with added logging | ||||
pg_snakeoil | pg_snakeoil |
postgresql-$v-snakeoil |
PGDG | 1 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
The PostgreSQL Antivirus | ||||
pgextwlist | pgextwlist |
postgresql-$v-pgextwlist |
PIGSTY | 1.17 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL Extension Whitelisting | ||||
pg_auditor | pg_auditor |
postgresql-$v-pg-auditor |
PIGSTY | 0.2 | SEC |
BSD-3 | 16 ,15 ,14 ,13 ,12 |
Audit data changes and provide flashback ability | ||||
sslutils | sslutils |
postgresql-$v-sslutils |
PIGSTY | 1.3 | SEC |
PostgreSQL | 15 ,14 ,13 ,12 |
A Postgres extension for managing SSL certificates through SQL | ||||
noset | noset |
postgresql-$v-noset |
PIGSTY | 0.3.0 | SEC |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Module for blocking SET variables for non-super users. | ||||
sepgsql | sepgsql |
postgresql-$v |
CONTRIB | 16.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
label-based mandatory access control (MAC) based on SELinux security policy. | ||||
auth_delay | auth_delay |
postgresql-$v |
CONTRIB | 16.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
pause briefly before reporting authentication failure | ||||
pgcrypto | pgcrypto |
postgresql-$v |
CONTRIB | 1.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
cryptographic functions | ||||
passwordcheck | passwordcheck |
postgresql-$v |
CONTRIB | 16.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
checks user passwords and reject weak password | ||||
wrappers | wrappers |
postgresql-$v-wrappers |
PIGSTY | 0.4.1 | FDW |
Apache-2.0 | 16 ,15 ,14 |
Foreign data wrappers developed by Supabase | ||||
mysql_fdw | mysql_fdw |
postgresql-$v-mysql-fdw |
PGDG | 1.2 | FDW |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for querying a MySQL server | ||||
oracle_fdw | oracle_fdw |
postgresql-$v-oracle-fdw |
PGDG | 1.2 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign data wrapper for Oracle access | ||||
tds_fdw | tds_fdw |
postgresql-$v-tds-fdw |
PGDG | 2.0.3 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) | ||||
sqlite_fdw | sqlite_fdw |
postgresql-$v-sqlite-fdw |
PGDG | 1.1 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
SQLite Foreign Data Wrapper | ||||
redis_fdw | redis_fdw |
postgresql-$v-redis-fdw |
PIGSTY | 1.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for querying a Redis server | ||||
redis | pg_redis_pubsub |
postgresql-$v-pg-redis-pubsub |
PIGSTY | 0.0.1 | FDW |
MIT | 16 ,15 ,14 ,13 ,12 |
Send redis pub/sub messages to Redis from PostgreSQL Directly | ||||
kafka_fdw | kafka_fdw |
postgresql-$v-kafka-fdw |
PIGSTY | 0.0.3 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
kafka Foreign Data Wrapper for CSV formated messages | ||||
aws_s3 | aws_s3 |
postgresql-$v-aws-s3 |
PIGSTY | 0.0.1 | FDW |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
aws_s3 postgres extension to import/export data from/to s3 | ||||
log_fdw | log_fdw |
postgresql-$v-log-fdw |
PIGSTY | 1.4 | FDW |
Apache-2.0 | 16 ,15 ,14 |
foreign-data wrapper for Postgres log file access | ||||
dblink | dblink |
postgresql-$v |
CONTRIB | 1.2 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
connect to other PostgreSQL databases from within a database | ||||
file_fdw | file_fdw |
postgresql-$v |
CONTRIB | 1.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for flat file access | ||||
postgres_fdw | postgres_fdw |
postgresql-$v |
CONTRIB | 1.1 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for remote PostgreSQL servers | ||||
orafce | orafce |
postgresql-$v-orafce |
PGDG | 4.10 | SIM |
BSD 0 | 16 ,15 ,14 ,13 ,12 |
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | ||||
pgtt | pgtt |
postgresql-$v-pgtt |
PGDG | 4.0.0 | SIM |
ISC | 16 ,15 ,14 ,13 ,12 |
Extension to add Global Temporary Tables feature to PostgreSQL | ||||
session_variable | session_variable |
postgresql-$v-session-variable |
PIGSTY | 3.3 | SIM |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
Registration and manipulation of session variables and constants | ||||
pg_statement_rollback | pg_statement_rollback |
postgresql-$v-pg-statement-rollback |
PIGSTY | 1.4 | SIM |
ISC | 16 ,15 ,14 ,13 ,12 |
Server side rollback at statement level for PostgreSQL like Oracle or DB2 | ||||
babelfishpg_common | babelfishpg_common |
babelfishpg-common |
WILTON | 3.3.3 | SIM |
Apache-2.0 | 15 |
SQL Server Transact SQL Datatype Support | ||||
babelfishpg_tsql | babelfishpg_tsql |
babelfishpg-tsql |
WILTON | 3.3.1 | SIM |
Apache-2.0 | 15 |
SQL Server Transact SQL compatibility | ||||
babelfishpg_tds | babelfishpg_tds |
babelfishpg-tds |
WILTON | 1.0.0 | SIM |
Apache-2.0 | 15 |
SQL Server TDS protocol extension | ||||
babelfishpg_money | babelfishpg_money |
babelfishpg-money |
WILTON | 1.1.0 | SIM |
Apache-2.0 | 15 |
SQL Server Money Data Type | ||||
pgmemcache | pgmemcache |
postgresql-$v-pgmemcache |
PGDG | 2.3.0 | SIM |
MIT | 16 ,15 ,14 ,13 ,12 |
memcached interface | ||||
pglogical | pglogical |
postgresql-$v-pglogical* |
PGDG | 2.4.4 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL Logical Replication | ||||
pglogical_origin | pglogical |
postgresql-$v-pglogical* |
PGDG | 1.0.0 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Dummy extension for compatibility when upgrading from Postgres 9.4 | ||||
pglogical_ticker | pglogical |
postgresql-$v-pglogical* |
PGDG | 1.4 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Have an accurate view on pglogical replication delay | ||||
pgl_ddl_deploy | pgl_ddl_deploy |
postgresql-$v-pgl-ddl-deploy |
PGDG | 2.2 | ETL |
MIT | 16 ,15 ,14 ,13 ,12 |
automated ddl deployment using pglogical | ||||
pg_failover_slots | pg_failover_slots |
postgresql-$v-pg-failover-slots |
PIGSTY | 1.0.1 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PG Failover Slots extension | ||||
wal2json | wal2json |
postgresql-$v-wal2json |
PGDG | 2.5.3 | ETL |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Changing data capture in JSON format | ||||
wal2mongo | wal2mongo |
postgresql-$v-wal2mongo |
PIGSTY | 1.0.7 | ETL |
Apache-2.0 | 16 ,15 ,14 ,13 |
PostgreSQL logical decoding output plugin for MongoDB | ||||
decoderbufs | decoderbufs |
postgresql-$v-decoderbufs |
PGDG | 0.1.0 | ETL |
MIT | 16 ,15 ,14 ,13 ,12 |
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format | ||||
decoder_raw | decoder_raw |
postgresql-$v-decoder-raw |
PIGSTY | 1.0 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Output plugin for logical replication in Raw SQL format | ||||
test_decoding | test_decoding |
postgresql-$v |
CONTRIB | 16.3 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
SQL-based test/example module for WAL logical decoding | ||||
mimeo | mimeo |
postgresql-$v-mimeo |
PGDG | 1.5.1 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension for specialized, per-table replication between PostgreSQL instances | ||||
repmgr | repmgr |
postgresql-$v-repmgr |
PGDG | 5.4 | ETL |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
Replication manager for PostgreSQL | ||||
pgcopydb | pgcopydb |
pgcopydb |
PIGSTY | 0.15 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Copy a Postgres database to a target Postgres server | ||||
pgloader | pgloader |
pgloader |
PGDG | 3.6.10 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Migrate to PostgreSQL in a single command! | ||||
pg_fact_loader | pg_fact_loader |
postgresql-$v-pg-fact-loader |
PGDG | 2.0 | ETL |
MIT | 16 ,15 ,14 ,13 ,12 |
build fact tables with Postgres | ||||
pg_bulkload | pg_bulkload |
postgresql-$v-pg-bulkload |
PIGSTY | 3.1.21 | ETL |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
pg_bulkload is a high speed data loading utility for PostgreSQL |
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.