RPM List
328 Available PostgreSQL Extension RPM in RHEL & Compatible Distributions
Module:
There are 328 extensions available on EL compatible systems, 21 of them are RPM exclusive, missing 7 DEB exclusive extensions.
There are 70 built-in contrib extensions, in addition to 135 rpm extensions provided by PGDG YUM repository, and 121 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 |
periods_$v* |
PGDG | 1.2 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING | |||||
temporal_tables | temporal_tables |
temporal_tables_$v* |
PGDG | 1.2.2 | TIME |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
temporal tables | |||||
emaj | emaj |
e-maj_$v* |
PGDG | 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 |
table_version_$v* |
PGDG | 1.10.3 | TIME |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL table versioning extension | |||||
pg_cron | pg_cron |
pg_cron_$v* |
PGDG | 1.6 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Job scheduler for PostgreSQL | |||||
pg_later | pg_later |
pg_later_$v |
PIGSTY | 0.1.1 | TIME |
PostgreSQL | 16 ,15 ,14 ,13 |
pg_later: Run queries now and get results later | |||||
pg_background | pg_background |
pg_background_$v* |
PGDG | 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 |
postgis34_$v* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS geometry and geography spatial types and functions | |||||
postgis_topology | postgis |
postgis34_$v* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS topology spatial types and functions | |||||
postgis_raster | postgis |
postgis34_$v* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS raster types and functions | |||||
postgis_sfcgal | postgis |
postgis34_$v* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS SFCGAL functions | |||||
postgis_tiger_geocoder | postgis |
postgis34_$v* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
PostGIS tiger geocoder and reverse geocoder | |||||
address_standardizer | postgis |
postgis34_$v* |
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 |
postgis34_$v* |
PGDG | 3.5.0 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
Address Standardizer US dataset example | |||||
pgrouting | pgrouting |
pgrouting_$v* |
PGDG | 3.6.2 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
pgRouting Extension | |||||
pointcloud | pointcloud |
pointcloud_$v* |
PIGSTY | 1.2.5 | GIS |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
data type for lidar point clouds | |||||
pointcloud_postgis | pointcloud |
pointcloud_$v* |
PGDG | 1.2.5 | GIS |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
integration for pointcloud LIDAR data and PostGIS geometry data | |||||
h3 | pg_h3 |
h3-pg_$v* |
PGDG | 4.1.3 | GIS |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
H3 bindings for PostgreSQL | |||||
h3_postgis | pg_h3 |
h3-pg_$v* |
PGDG | 4.1.3 | GIS |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
H3 PostGIS integration | |||||
q3c | q3c |
q3c_$v* |
PIGSTY | 2.0.1 | GIS |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
q3c sky indexing plugin | |||||
ogr_fdw | ogr_fdw |
ogr_fdw_$v* |
PGDG | 1.1 | GIS |
MIT | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for GIS data access | |||||
geoip | geoip |
geoip_$v* |
PGDG | 0.3.0 | GIS |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
IP-based geolocation query | |||||
pg_geohash | pg_geohash |
pg_geohash_$v* |
PIGSTY | 1.0 | GIS |
MIT | 15 ,14 ,13 ,12 |
Handle geohash based functionality for spatial coordinates | |||||
earthdistance | earthdistance |
postgresql$v-contrib |
CONTRIB | 1.1 | GIS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
calculate great-circle distances on the surface of the Earth | |||||
vector | pgvector |
pgvector_$v* |
PGDG | 0.7.3 | RAG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
vector data type and ivfflat and hnsw access methods | |||||
vectorscale | pgvectorscale |
pgvectorscale_$v |
PIGSTY | 0.2.0 | RAG |
PostgreSQL | 16 ,15 |
pgvectorscale: Advanced indexing for vector data | |||||
vectorize | pg_vectorize |
pg_vectorize_$v |
PIGSTY | 0.17.0 | RAG |
PostgreSQL | 16 ,15 ,14 |
The simplest way to do vector search on Postgres | |||||
pg_similarity | pg_similarity |
pg_similarity_$v* |
PIGSTY | 1.0 | RAG |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
support similarity queries | |||||
smlar | smlar |
smlar_$v* |
PIGSTY | 1.0 | RAG |
PostgreSQL | 15 ,14 ,13 |
Effective similarity search | |||||
pg_tiktoken | pg_tiktoken |
pg_tiktoken_$v |
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 |
pgml_$v |
PIGSTY | 2.9.3 | RAG |
MIT | 16 ,15 ,14 |
PostgresML: Run AL/ML workloads with SQL interface | |||||
pg_search | pg_search |
pg_search_$v |
PIGSTY | 0.10.2 | FTS |
AGPLv3 | 16 ,15 ,14 |
pg_search: Full text search for PostgreSQL using BM25 | |||||
pg_bigm | pg_bigm |
pg_bigm_$v* |
PGDG | 1.2 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
create 2-gram (bigram) index for faster full text search. | |||||
zhparser | zhparser |
zhparser_$v* |
PIGSTY | 2.2 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
a parser for full-text search of Chinese | |||||
hunspell_cs_cz | hunspell_cs_cz |
hunspell_cs_cz_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Czech Hunspell Dictionary | |||||
hunspell_de_de | hunspell_de_de |
hunspell_de_de_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
German Hunspell Dictionary | |||||
hunspell_en_us | hunspell_en_us |
hunspell_en_us_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
en_US Hunspell Dictionary | |||||
hunspell_fr | hunspell_fr |
hunspell_fr_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
French Hunspell Dictionary | |||||
hunspell_ne_np | hunspell_ne_np |
hunspell_ne_np_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Nepali Hunspell Dictionary | |||||
hunspell_nl_nl | hunspell_nl_nl |
hunspell_nl_nl_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Dutch Hunspell Dictionary | |||||
hunspell_nn_no | hunspell_nn_no |
hunspell_nn_no_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Norwegian (norsk) Hunspell Dictionary | |||||
hunspell_pt_pt | hunspell_pt_pt |
hunspell_pt_pt_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Portuguese Hunspell Dictionary | |||||
hunspell_ru_ru | hunspell_ru_ru |
hunspell_ru_ru_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Russian Hunspell Dictionary | |||||
hunspell_ru_ru_aot | hunspell_ru_ru_aot |
hunspell_ru_ru_aot_$v |
PIGSTY | 1.0 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Russian Hunspell Dictionary (from AOT.ru group) | |||||
fuzzystrmatch | fuzzystrmatch |
postgresql$v-contrib |
CONTRIB | 1.2 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
determine similarities and distance between strings | |||||
pg_trgm | pg_trgm |
postgresql$v-contrib |
CONTRIB | 1.6 | FTS |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text similarity measurement and index searching based on trigrams | |||||
citus | citus |
citus_$v* |
PGDG | 12.1-1 | OLAP |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Distributed PostgreSQL as an extension | |||||
citus_columnar | citus |
citus_$v* |
PGDG | 11.3-1 | OLAP |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Citus columnar storage engine | |||||
columnar | hydra |
hydra_$v* |
PIGSTY | 11.1-11 | OLAP |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
Hydra Columnar extension | |||||
pg_analytics | pg_analytics |
pg_analytics_$v |
PIGSTY | 0.1.4 | OLAP |
AGPLv3 | 16 ,15 ,14 |
Postgres for analytics, powered by DuckDB | |||||
pg_lakehouse | pg_lakehouse |
pg_lakehouse_$v |
PIGSTY | 0.9.0 | OLAP |
AGPLv3 | 16 ,15 ,14 |
pg_lakehouse: An analytical query engine for Postgres | |||||
pg_duckdb | pg_duckdb |
pg_duckdb_$v* |
PIGSTY | 0.0.1 | OLAP |
MIT | 16 |
DuckDB Embedded in Postgres | |||||
duckdb_fdw | duckdb_fdw |
duckdb_fdw_$v* |
PIGSTY | 1.0.0 | OLAP |
MIT | 16 ,15 ,14 ,13 ,12 |
DuckDB Foreign Data Wrapper | |||||
parquet_s3_fdw | parquet_s3_fdw |
parquet_s3_fdw_$v* |
PIGSTY | 0.3.1 | OLAP |
MIT | 16 |
foreign-data wrapper for parquet on S3 | |||||
pg_fkpart | pg_fkpart |
pg_fkpart_$v* |
PGDG | 1.7 | OLAP |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
Table partitioning by foreign key utility | |||||
pg_partman | pg_partman |
pg_partman_$v* |
PGDG | 5.1.0 | OLAP |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension to manage partitioned tables by time or ID | |||||
plproxy | plproxy |
plproxy_$v* |
PGDG | 2.11.0 | OLAP |
BSD 0 | 16 ,15 ,14 ,13 ,12 |
Database partitioning implemented as procedural language | |||||
pg_strom | pg_strom |
pg_strom_$v* |
PGDG | 5.1 | OLAP |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PG-Strom - big-data processing acceleration using GPU and NVME | |||||
tablefunc | tablefunc |
postgresql$v-contrib |
CONTRIB | 1.0 | OLAP |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions that manipulate whole tables, including crosstab | |||||
age | age |
apache-age_$v* |
PIGSTY | 1.5.0 | FEAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
AGE graph database extension | |||||
hll | hll |
hll_$v* |
PGDG | 2.18 | FEAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
type for storing hyperloglog data | |||||
rum | rum |
rum_$v |
PGDG | 1.3 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
RUM index access method | |||||
pg_graphql | pg_graphql |
pg_graphql_$v |
PIGSTY | 1.5.7 | FEAT |
Apache-2.0 | 16 ,15 |
pg_graphql: GraphQL support | |||||
pg_jsonschema | pg_jsonschema |
pg_jsonschema_$v |
PIGSTY | 0.3.1 | FEAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL extension providing JSON Schema validation | |||||
jsquery | jsquery |
jsquery_$v* |
PGDG | 1.1 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for jsonb inspection | |||||
pg_hint_plan | pg_hint_plan |
pg_hint_plan_$v* |
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 |
hypopg_$v* |
PGDG | 1.4.1 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Hypothetical indexes for PostgreSQL | |||||
index_advisor | index_advisor |
index_advisor_$v |
PIGSTY | 0.2.0 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Query index advisor | |||||
imgsmlr | imgsmlr |
imgsmlr_$v* |
PIGSTY | 1.0 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Image similarity with haar | |||||
pg_ivm | pg_ivm |
pg_ivm_$v* |
PGDG | 1.8 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
incremental view maintenance on PostgreSQL | |||||
pgmq | pgmq |
pgmq_$v |
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 |
pgq_$v* |
PGDG | 3.5.1 | FEAT |
ISC | 16 ,15 ,14 ,13 ,12 |
Generic queue for PostgreSQL | |||||
bloom | bloom |
postgresql$v-contrib |
CONTRIB | 1.0 | FEAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
bloom access method - signature file based index | |||||
pg_tle | pg_tle |
pg_tle_$v* |
PIGSTY | 1.2.0 | LANG |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Trusted Language Extensions for PostgreSQL | |||||
plv8 | plv8 |
plv8_$v* |
PIGSTY | 3.2.2 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/JavaScript (v8) trusted procedural language | |||||
plluau | pllua |
pllua_$v* |
PGDG | 2.0 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
Lua as an untrusted procedural language | |||||
pllua | pllua |
pllua_$v* |
PGDG | 2.0 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
Lua as a procedural language | |||||
plprql | plprql |
plprql_$v |
PIGSTY | 0.1.0 | LANG |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Use PRQL in PostgreSQL - Pipelined Relational Query Language | |||||
pldbgapi | pldebugger |
pldebugger_$v* |
PGDG | 1.1 | LANG |
Artistic | 16 ,15 ,14 ,13 ,12 |
server-side support for debugging PL/pgSQL functions | |||||
plpgsql_check | plpgsql_check |
plpgsql_check_$v* |
PGDG | 2.7 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
extended check for plpgsql functions | |||||
plprofiler | plprofiler |
plprofiler_$v* |
PGDG | 4.2 | LANG |
Artistic | 16 ,15 ,14 ,13 ,12 |
server-side support for profiling PL/pgSQL functions | |||||
plsh | plsh |
plsh_$v* |
PGDG | 2 | LANG |
MIT | 16 ,15 ,14 ,13 ,12 |
PL/sh procedural language | |||||
pljava | pljava |
pljava_$v* |
PGDG | 1.6.6 | LANG |
BSD 3 | 16 |
PL/Java procedural language (https://tada.github.io/pljava/) | |||||
plr | plr |
plr_$v* |
PGDG | 8.4.6 | LANG |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
load R interpreter and execute R script from within a database | |||||
pgtap | pgtap |
pgtap_$v* |
PGDG | 1.3.1 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Unit testing for PostgreSQL | |||||
faker | faker |
postgresql_faker_$v* |
PGDG | 0.5.3 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Wrapper for the Faker Python library | |||||
dbt2 | dbt2 |
dbt2-pg$v-extensions* |
PGDG | 0.45.0 | LANG |
Artistic | 16 ,15 ,14 ,13 ,12 |
OSDL-DBT-2 test kit | |||||
pltcl | pltcl |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/Tcl procedural language | |||||
pltclu | pltcl |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/TclU untrusted procedural language | |||||
plperl | plperl |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/Perl procedural language | |||||
bool_plperl | plperl |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between bool and plperl | |||||
hstore_plperl | plperl |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between hstore and plperl | |||||
jsonb_plperl | plperl |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between jsonb and plperl | |||||
plperlu | plperlu |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/PerlU untrusted procedural language | |||||
bool_plperlu | plperlu |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between bool and plperlu | |||||
jsonb_plperlu | plperlu |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between jsonb and plperlu | |||||
hstore_plperlu | plperlu |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between hstore and plperlu | |||||
plpgsql | plpgsql |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/pgSQL procedural language | |||||
plpython3u | plpython3u |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PL/Python3U untrusted procedural language | |||||
jsonb_plpython3u | plpython3u |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between jsonb and plpython3u | |||||
ltree_plpython3u | plpython3u |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between ltree and plpython3u | |||||
hstore_plpython3u | plpython3u |
postgresql$v-contrib |
CONTRIB | 1.0 | LANG |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
transform between hstore and plpython3u | |||||
prefix | prefix |
prefix_$v* |
PGDG | 1.2.0 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Prefix Range module for PostgreSQL | |||||
semver | semver |
semver_$v* |
PGDG | 0.32.1 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Semantic version data type | |||||
unit | pgunit |
postgresql-unit_$v* |
PGDG | 7 | TYPE |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
SI units extension | |||||
md5hash | md5hash |
md5hash_$v* |
PIGSTY | 1.0.1 | TYPE |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
type for storing 128-bit binary data inline | |||||
asn1oid | asn1oid |
asn1oid_$v* |
PIGSTY | 1 | TYPE |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
asn1oid extension | |||||
roaringbitmap | roaringbitmap |
pg_roaringbitmap_$v* |
PIGSTY | 0.5 | TYPE |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
support for Roaring Bitmaps | |||||
pgfaceting | pgfaceting |
pgfaceting_$v |
PIGSTY | 0.2.0 | TYPE |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
fast faceting queries using an inverted index | |||||
pg_sphere | pgsphere |
pgsphere_$v* |
PIGSTY | 1.5.1 | TYPE |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
spherical objects with useful functions, operators and index support | |||||
country | pg_country |
pg_country_$v* |
PIGSTY | 0.0.3 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Country data type, ISO 3166-1 | |||||
currency | pg_currency |
pg_currency_$v* |
PIGSTY | 0.0.3 | TYPE |
MIT | 16 ,15 ,14 ,13 ,12 |
Custom PostgreSQL currency type in 1Byte | |||||
pgmp | pgmp |
pgmp_$v* |
PGDG | 1.1 | TYPE |
LGPLv3 | 16 ,15 ,14 ,13 ,12 |
Multiple Precision Arithmetic extension | |||||
numeral | numeral |
numeral_$v* |
PIGSTY | 1 | TYPE |
GPLv2 | 16 ,15 ,14 ,13 ,12 |
numeral datatypes extension | |||||
pg_rational | pg_rational |
pg_rational_$v* |
PIGSTY | 0.0.2 | TYPE |
MIT | 16 ,15 ,14 ,13 ,12 |
bigint fractions | |||||
uint | pguint |
pguint_$v* |
PGDG | 0 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
unsigned integer types | |||||
ip4r | ip4r |
ip4r_$v* |
PGDG | 2.4 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
IPv4/v6 and IPv4/v6 range index type for PostgreSQL | |||||
uri | pg_uri |
pg_uri_$v* |
PIGSTY | 1.20151224 | TYPE |
PostgreSQL | 15 ,14 ,13 ,12 |
URI Data type for PostgreSQL | |||||
pgemailaddr | pgemailaddr |
pg_emailaddr_$v* |
PIGSTY | 0 | TYPE |
PostgreSQL | 15 ,14 ,13 ,12 |
Email address type for PostgreSQL | |||||
acl | acl |
acl_$v* |
PIGSTY | 1.0.4 | TYPE |
BSD-2 | 15 ,14 ,13 ,12 |
ACL Data type | |||||
timestamp9 | timestamp9 |
timestamp9_$v* |
PGDG | 1.4.0 | TYPE |
MIT | 16 ,15 ,14 ,13 ,12 |
timestamp nanosecond resolution | |||||
chkpass | chkpass |
chkpass_$v* |
PIGSTY | 1.0 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for auto-encrypted passwords | |||||
isn | isn |
postgresql$v-contrib |
CONTRIB | 1.2 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data types for international product numbering standards | |||||
seg | seg |
postgresql$v-contrib |
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 |
CONTRIB | 1.5 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for multidimensional cubes | |||||
ltree | ltree |
postgresql$v-contrib |
CONTRIB | 1.2 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for hierarchical tree-like structures | |||||
hstore | hstore |
postgresql$v-contrib |
CONTRIB | 1.8 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for storing sets of (key, value) pairs | |||||
citext | citext |
postgresql$v-contrib |
CONTRIB | 1.6 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
data type for case-insensitive character strings | |||||
xml2 | xml2 |
postgresql$v-contrib |
CONTRIB | 1.1 | TYPE |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
XPath querying and XSLT | |||||
topn | topn |
topn_$v* |
PGDG | 2.6.0 | FUNC |
AGPLv3 | 16 ,15 ,14 ,13 ,12 |
type for top-n JSONB | |||||
gzip | pg_gzip |
pgsql_gzip_$v* |
PGDG | 1.0 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
gzip and gunzip functions. | |||||
zstd | pg_zstd |
pg_zstd_$v* |
PIGSTY | 1.1.0 | FUNC |
ISC | 15 ,14 ,13 ,12 |
Zstandard compression algorithm implementation in PostgreSQL | |||||
http | pg_http |
pgsql_http_$v* |
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 |
pg_net_$v* |
PGDG | 0.9.2 | FUNC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Async HTTP Requests | |||||
pg_html5_email_address | pg_html5_email_address |
pg_html5_email_address_$v |
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 |
pgsql_tweaks_$v* |
PGDG | 0.10.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Some functions and views for daily usage | |||||
pg_extra_time | pg_extra_time |
pg_extra_time_$v* |
PGDG | 1.1.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Some date time functions and operators that, | |||||
timeit | pg_timeit |
pg_timeit_$v* |
PIGSTY | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
High-accuracy timing of SQL expressions | |||||
count_distinct | count_distinct |
count_distinct_$v* |
PGDG | 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 |
extra_window_functions_$v* |
PGDG | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extra Window Functions for PostgreSQL | |||||
first_last_agg | first_last_agg |
first_last_agg_$v |
PIGSTY | 0.1.4 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
first() and last() aggregate functions | |||||
tdigest | tdigest |
tdigest_$v* |
PGDG | 1.4.1 | FUNC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Provides tdigest aggregate function. | |||||
aggs_for_vecs | aggs_for_vecs |
aggs_for_vecs_$v* |
PIGSTY | 1.3.0 | FUNC |
MIT | 15 ,14 ,13 ,12 |
Aggregate functions for array inputs | |||||
aggs_for_arrays | aggs_for_arrays |
aggs_for_arrays_$v* |
PIGSTY | 1.3.2 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Various functions for computing statistics on arrays of numbers | |||||
arraymath | pg_arraymath |
pg_arraymath_$v* |
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 |
quantile_$v* |
PIGSTY | 1.1.7 | FUNC |
BSD | 15 ,14 ,13 ,12 |
Quantile aggregation function | |||||
lower_quantile | lower_quantile |
lower_quantile_$v* |
PIGSTY | 1.0.0 | FUNC |
BSD-2 | 15 ,14 ,13 ,12 |
Lower quantile aggregate function | |||||
pg_idkit | pg_idkit |
pg_idkit_$v |
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 |
pg_uuidv7_$v* |
PGDG | 1.5 | FUNC |
MPLv2 | 16 ,15 ,14 ,13 ,12 |
pg_uuidv7: create UUIDv7 values in postgres | |||||
permuteseq | permuteseq |
permuteseq_$v* |
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 |
pg_hashids_$v* |
PIGSTY | 1.3 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Short unique id generator for PostgreSQL, using hashids | |||||
sequential_uuids | sequential_uuids |
sequential_uuids_$v* |
PGDG | 1.0.2 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
generator of sequential UUIDs | |||||
pg_math | pg_math |
pg_math_$v* |
PIGSTY | 1.0 | FUNC |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
GSL statistical functions for postgresql | |||||
random | pg_random |
pg_random_$v* |
PIGSTY | 2.0.0-dev | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
random data generator | |||||
base36 | pg_base36 |
pg_base36_$v* |
PIGSTY | 1.0.0 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Integer Base36 types | |||||
base62 | pg_base62 |
pg_base62_$v* |
PIGSTY | 0.0.1 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Base62 extension for PostgreSQL | |||||
floatvec | floatvec |
floatvec_$v* |
PIGSTY | 1.0.1 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
Math for vectors (arrays) of numbers | |||||
financial | pg_financial |
pg_financial_$v* |
PIGSTY | 1.0.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Financial aggregate functions | |||||
pgjwt | pgjwt |
pgjwt_$v* |
PIGSTY | 0.2.0 | FUNC |
MIT | 16 ,15 ,14 ,13 ,12 |
JSON Web Token API for Postgresql | |||||
pg_hashlib | pg_hashlib |
pg_hashlib_$v |
PIGSTY | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Stable hash functions for Postgres | |||||
shacrypt | shacrypt |
postgres_shacrypt_$v* |
PIGSTY | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes | |||||
cryptint | cryptint |
cryptint_$v* |
PIGSTY | 1.0.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Encryption functions for int and bigint values | |||||
pguecc | pg_ecdsa |
pg_ecdsa_$v* |
PIGSTY | 1.0 | FUNC |
BSD-2 | 16 ,15 ,14 ,13 ,12 |
uECC bindings for Postgres | |||||
pgpcre | pgpcre |
pgpcre_$v |
PIGSTY | 1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Perl Compatible Regular Expression functions | |||||
icu_ext | icu_ext |
icu_ext_$v* |
PIGSTY | 1.8 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Access ICU functions | |||||
pgqr | pgqr |
pgqr_$v* |
PIGSTY | 1.0 | FUNC |
BSD-3 | 15 ,14 ,13 ,12 |
QR Code generator from PostgreSQL | |||||
envvar | envvar |
pg_envvar_$v* |
PIGSTY | 1.0.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Fetch the value of an environment variable | |||||
pg_protobuf | pg_protobuf |
pg_protobuf_$v |
PIGSTY | 1.0 | FUNC |
MIT | 15 ,14 ,13 ,12 |
Protobuf support for PostgreSQL | |||||
url_encode | url_encode |
url_encode_$v* |
PIGSTY | 1.2.5 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
url_encode, url_decode functions | |||||
refint | refint |
postgresql$v-contrib |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for implementing referential integrity (obsolete) | |||||
autoinc | autoinc |
postgresql$v-contrib |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for autoincrementing fields | |||||
insert_username | insert_username |
postgresql$v-contrib |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for tracking who changed a table | |||||
moddatetime | moddatetime |
postgresql$v-contrib |
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 |
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 |
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 |
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 |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Triggered change notifications | |||||
uuid-ossp | uuid-ossp |
postgresql$v-contrib |
CONTRIB | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
generate universally unique identifiers (UUIDs) | |||||
btree_gist | btree_gist |
postgresql$v-contrib |
CONTRIB | 1.7 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
support for indexing common datatypes in GiST | |||||
btree_gin | btree_gin |
postgresql$v-contrib |
CONTRIB | 1.3 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
support for indexing common datatypes in GIN | |||||
intarray | intarray |
postgresql$v-contrib |
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 |
CONTRIB | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
integer aggregator and enumerator (obsolete) | |||||
dict_int | dict_int |
postgresql$v-contrib |
CONTRIB | 1.0 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text search dictionary template for integers | |||||
unaccent | unaccent |
postgresql$v-contrib |
CONTRIB | 1.1 | FUNC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
text search dictionary that removes accents | |||||
pg_repack | pg_repack |
pg_repack_$v* |
PGDG | 1.5.0 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Reorganize tables in PostgreSQL databases with minimal locks | |||||
pg_squeeze | pg_squeeze |
pg_squeeze_$v* |
PGDG | 1.6 | ADMIN |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
A tool to remove unused space from a relation. | |||||
pg_dirtyread | pg_dirtyread |
pg_dirtyread_$v* |
PIGSTY | 2 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Read dead but unvacuumed rows from table | |||||
pgfincore | pgfincore |
pgfincore_$v* |
PGDG | 1.3.1 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
examine and manage the os buffer cache | |||||
pgdd | pgdd |
pgdd_$v |
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 |
ddlx_$v* |
PGDG | 0.27 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
DDL eXtractor functions | |||||
prioritize | pg_prioritize |
pg_prioritize_$v* |
PGDG | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
get and set the priority of PostgreSQL backends | |||||
pg_checksums | pg_checksums |
pg_checksums_$v* |
PGDG | 1.1 | ADMIN |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
Activate/deactivate/verify checksums in offline Postgres clusters | |||||
pg_readonly | pg_readonly |
pg_readonly_$v* |
PGDG | 1.0.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
cluster database read only | |||||
safeupdate | safeupdate |
safeupdate_$v* |
PGDG | 1.4 | ADMIN |
ISC | 16 ,15 ,14 ,13 ,12 |
Require criteria for UPDATE and DELETE | |||||
pg_permissions | pg_permissions |
pg_permissions_$v* |
PGDG | 1.3 | ADMIN |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
view object permissions and compare them with the desired state | |||||
pgautofailover | pgautofailover |
pg_auto_failover_$v* |
PGDG | 2.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
pg_auto_failover | |||||
pg_catcheck | pg_catcheck |
pg_catcheck_$v* |
PGDG | 1.4.0 | ADMIN |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Diagnosing system catalog corruption | |||||
pre_prepare | preprepare |
preprepare_$v* |
PIGSTY | 0.4 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Pre Prepare your Statement server side | |||||
pgcozy | pgcozy |
pgcozy_$v |
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 |
pg_orphaned_$v* |
PIGSTY | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Deal with orphaned files | |||||
pg_crash | pg_crash |
pg_crash_$v* |
PIGSTY | 1.0 | ADMIN |
BSD-3 | 16 ,15 ,14 ,13 ,12 |
Send random signals to random processes | |||||
pg_cheat_funcs | pg_cheat_funcs |
pg_cheat_funcs_$v* |
PIGSTY | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Provides cheat (but useful) functions | |||||
pg_savior | pg_savior |
pg_savior_$v* |
PIGSTY | 0.0.1 | ADMIN |
Apache-2.0 | 16 ,15 ,14 ,13 |
Postgres extension to save OOPS mistakes | |||||
table_log | table_log |
table_log_$v |
PIGSTY | 0.6.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
record table modification logs and PITR for table/row | |||||
pg_fio | pg_fio |
pg_fio_$v |
PIGSTY | 1.0 | ADMIN |
BSD-3 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL File I/O Functions | |||||
pgpool_adm | pgpool |
pgpool-II-pg$v-extensions |
PGDG | 1.5 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Administrative functions for pgPool | |||||
pgpool_recovery | pgpool |
pgpool-II-pg$v-extensions |
PGDG | 1.4 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
recovery functions for pgpool-II for V4.3 | |||||
pgpool_regclass | pgpool |
pgpool-II-pg$v-extensions |
PGDG | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
replacement for regclass | |||||
pgagent | pgagent |
pgagent_$v* |
PGDG | 4.2 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
A PostgreSQL job scheduler | |||||
vacuumlo | vacuumlo |
postgresql$v-contrib |
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 |
CONTRIB | 1.2 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
prewarm relation data | |||||
oid2name | oid2name |
postgresql$v-contrib |
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 |
CONTRIB | 1.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Large Object maintenance | |||||
basic_archive | basic_archive |
postgresql$v-contrib |
CONTRIB | 16.3 | ADMIN |
PostgreSQL | 16 ,15 |
an example of an archive module | |||||
basebackup_to_shell | basebackup_to_shell |
postgresql$v-contrib |
CONTRIB | 16.3 | ADMIN |
PostgreSQL | 16 ,15 |
adds a custom basebackup target called shell | |||||
old_snapshot | old_snapshot |
postgresql$v-contrib |
CONTRIB | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 |
utilities in support of old_snapshot_threshold | |||||
adminpack | adminpack |
postgresql$v-contrib |
CONTRIB | 2.1 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
administrative functions for PostgreSQL | |||||
amcheck | amcheck |
postgresql$v-contrib |
CONTRIB | 1.3 | ADMIN |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
functions for verifying relation integrity | |||||
pg_surgery | pg_surgery |
postgresql$v-contrib |
CONTRIB | 1.0 | ADMIN |
PostgreSQL | 16 ,15 ,14 |
extension to perform surgery on a damaged relation | |||||
pg_profile | pg_profile |
pg_profile_$v* |
PGDG | 4.6 | STAT |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
PostgreSQL load profile repository and report builder | |||||
pg_show_plans | pg_show_plans |
pg_show_plans_$v* |
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 |
pg_stat_kcache_$v* |
PGDG | 2.2.3 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Kernel statistics gathering | |||||
pg_stat_monitor | pg_stat_monitor |
pg_stat_monitor_$v* |
PGDG | 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 |
pg_qualstats_$v* |
PGDG | 2.1.0 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
An extension collecting statistics about quals | |||||
pg_store_plans | pg_store_plans |
pg_store_plans_$v* |
PGDG | 1.8 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
track plan statistics of all SQL statements executed | |||||
pg_track_settings | pg_track_settings |
pg_track_settings_$v* |
PGDG | 2.1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Track settings changes | |||||
pg_wait_sampling | pg_wait_sampling |
pg_wait_sampling_$v* |
PGDG | 1.1 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
sampling based statistics of wait events | |||||
system_stats | system_stats |
system_stats_$v* |
PGDG | 2.0 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
EnterpriseDB system statistics for PostgreSQL | |||||
meta | pg_meta |
pg_meta_$v |
PIGSTY | 0.4.0 | STAT |
BSD-2 | 16 ,15 ,14 ,13 ,12 |
Normalized, friendlier system catalog for PostgreSQL | |||||
pgnodemx | pgnodemx |
pgnodemx_$v |
PIGSTY | 1.6 | STAT |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Capture node OS metrics via SQL queries | |||||
pg_proctab | pgnodemx |
pgnodemx_$v |
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 |
pg_sqlog_$v* |
PIGSTY | 1.6 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Provide SQL interface to logs | |||||
bgw_replstatus | bgw_replstatus |
bgw_replstatus_$v* |
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 |
pgmeminfo_$v* |
PGDG | 1.0 | STAT |
MIT | 16 ,15 ,14 ,13 ,12 |
show memory usage | |||||
toastinfo | toastinfo |
toastinfo_$v* |
PIGSTY | 1 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show details on toasted datums | |||||
pg_mon | pg_mon |
pg_mon_$v* |
PIGSTY | 1.0 | STAT |
MIT | 15 ,14 ,13 ,12 |
PostgreSQL extension to enhance query monitoring | |||||
pg_statviz | pg_statviz |
pg_statviz_extension_$v |
PGDG | 0.6 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
stats visualization and time series analysis | |||||
pgexporter_ext | pgexporter_ext |
pgexporter_ext_$v |
PGDG | 0.2.3 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
pgexporter extension for extra metrics | |||||
pg_top | pg_top |
pg_top_$v* |
PGDG | 3.7.0 | STAT |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Monitor PostgreSQL processes similar to unix top | |||||
pagevis | pagevis |
pagevis_$v |
PIGSTY | 0.1 | STAT |
MIT | 16 ,15 ,14 ,13 ,12 |
Visualise database pages in ascii code | |||||
powa | powa |
powa_$v* |
PGDG | 4.2.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL Workload Analyser-core | |||||
pageinspect | pageinspect |
postgresql$v-contrib |
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 |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show row-level locking information | |||||
sslinfo | sslinfo |
postgresql$v-contrib |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
information about SSL certificates | |||||
pg_buffercache | pg_buffercache |
postgresql$v-contrib |
CONTRIB | 1.4 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
examine the shared buffer cache | |||||
pg_walinspect | pg_walinspect |
postgresql$v-contrib |
CONTRIB | 1.1 | STAT |
PostgreSQL | 16 ,15 |
functions to inspect contents of PostgreSQL Write-Ahead Log | |||||
pg_freespacemap | pg_freespacemap |
postgresql$v-contrib |
CONTRIB | 1.2 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
examine the free space map (FSM) | |||||
pg_visibility | pg_visibility |
postgresql$v-contrib |
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 |
CONTRIB | 1.5 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
show tuple-level statistics | |||||
auto_explain | auto_explain |
postgresql$v-contrib |
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 |
CONTRIB | 1.10 | STAT |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
track planning and execution statistics of all SQL statements executed | |||||
passwordcheck_cracklib | passwordcheck |
passwordcheck_cracklib_$v* |
PGDG | 3.0.0 | SEC |
LGPLv2 | 16 ,15 ,14 ,13 ,12 |
Strengthen PostgreSQL user password checks with cracklib | |||||
supautils | supautils |
supautils_$v* |
PIGSTY | 3.1.9 | SEC |
Apache-2.0 | 16 ,15 ,14 ,13 |
Extension that secures a cluster on a cloud environment | |||||
pgsodium | pgsodium |
pgsodium_$v* |
PGDG | 3.1.9 | SEC |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Postgres extension for libsodium functions | |||||
supabase_vault | pg_vault |
vault_$v* |
PIGSTY | 0.2.8 | SEC |
Apache-2.0 | 16 ,15 ,14 ,13 ,12 |
Supabase Vault Extension | |||||
anon | anonymizer |
postgresql_anonymizer_$v* |
PGDG | 1.3.2 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Data anonymization tools | |||||
pg_tde | pg_tde |
pg_tde_$v* |
PIGSTY | 1.0 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
pg_tde access method | |||||
pgsmcrypto | pgsmcrypto |
pgsmcrypto_$v |
PIGSTY | 0.1.0 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
PostgreSQL SM Algorithm Extension | |||||
pgaudit | pgaudit |
pgaudit_$v* |
PGDG | 16.0 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
provides auditing functionality | |||||
pgauditlogtofile | pgauditlogtofile |
pgauditlogtofile_$v* |
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 |
pg_auth_mon_$v* |
PGDG | 1.1 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
monitor connection attempts per user | |||||
credcheck | credcheck |
credcheck_$v* |
PGDG | 2.7.0 | SEC |
MIT | 16 ,15 ,14 ,13 ,12 |
credcheck - postgresql plain text credential checker | |||||
pgcryptokey | pgcryptokey |
pgcryptokey_$v* |
PGDG | 1.0 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
cryptographic key management | |||||
pg_jobmon | pg_jobmon |
pg_jobmon_$v* |
PGDG | 1.4.1 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension for logging and monitoring functions in PostgreSQL | |||||
logerrors | logerrors |
logerrors_$v* |
PGDG | 2.1 | SEC |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Function for collecting statistics about messages in logfile | |||||
login_hook | login_hook |
login_hook_$v* |
PGDG | 1.5 | SEC |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
login_hook - hook to execute login_hook.login() at login time | |||||
set_user | set_user |
set_user_$v* |
PGDG | 4.0.1 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
similar to SET ROLE but with added logging | |||||
pg_snakeoil | pg_snakeoil |
pg_snakeoil_$v* |
PIGSTY | 1 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
The PostgreSQL Antivirus | |||||
pgextwlist | pgextwlist |
pgextwlist_$v* |
PIGSTY | 1.17 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL Extension Whitelisting | |||||
pg_auditor | pg_auditor |
pg_auditor_$v |
PIGSTY | 0.2 | SEC |
BSD-3 | 16 ,15 ,14 ,13 ,12 |
Audit data changes and provide flashback ability | |||||
sslutils | sslutils |
sslutils_$v* |
PIGSTY | 1.3 | SEC |
PostgreSQL | 15 ,14 ,13 ,12 |
A Postgres extension for managing SSL certificates through SQL | |||||
noset | noset |
noset_$v* |
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 |
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 |
CONTRIB | 16.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
pause briefly before reporting authentication failure | |||||
pgcrypto | pgcrypto |
postgresql$v-contrib |
CONTRIB | 1.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
cryptographic functions | |||||
passwordcheck | passwordcheck |
postgresql$v-contrib |
CONTRIB | 16.3 | SEC |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
checks user passwords and reject weak password | |||||
wrappers | wrappers |
wrappers_$v |
PIGSTY | 0.4.1 | FDW |
Apache-2.0 | 16 ,15 ,14 |
Foreign data wrappers developed by Supabase | |||||
multicorn | multicorn |
multicorn2_$v* |
PGDG | 3.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Fetch foreign data in Python in your PostgreSQL server. | |||||
odbc_fdw | odbc_fdw |
odbc_fdw_$v* |
PGDG | 0.5.1 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 |
Foreign data wrapper for accessing remote databases using ODBC | |||||
jdbc_fdw | jdbc_fdw |
jdbc_fdw_$v* |
PGDG | 1.2 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 |
foreign-data wrapper for remote servers available over JDBC | |||||
mysql_fdw | mysql_fdw |
mysql_fdw_$v* |
PGDG | 1.2 | FDW |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for querying a MySQL server | |||||
oracle_fdw | oracle_fdw |
oracle_fdw_$v* |
PGDG | 1.2 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign data wrapper for Oracle access | |||||
tds_fdw | tds_fdw |
tds_fdw_$v* |
PGDG | 2.0.3 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) | |||||
db2_fdw | db2_fdw |
db2_fdw_$v* |
PGDG | 6.0.1 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign data wrapper for DB2 access | |||||
sqlite_fdw | sqlite_fdw |
sqlite_fdw_$v* |
PGDG | 1.1 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
SQLite Foreign Data Wrapper | |||||
pgbouncer_fdw | pgbouncer_fdw |
pgbouncer_fdw_$v* |
PGDG | 1.1.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions | |||||
mongo_fdw | mongo_fdw |
mongo_fdw_$v* |
PGDG | 1.1 | FDW |
LGPLv3 | 16 ,15 ,14 ,13 ,12 |
foreign data wrapper for MongoDB access | |||||
redis_fdw | redis_fdw |
redis_fdw_$v* |
PIGSTY | 1.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for querying a Redis server | |||||
redis | pg_redis_pubsub |
pg_redis_pubsub_$v* |
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 |
kafka_fdw_$v |
PIGSTY | 0.0.3 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
kafka Foreign Data Wrapper for CSV formated messages | |||||
hdfs_fdw | hdfs_fdw |
hdfs_fdw_$v* |
PGDG | 2.0.5 | FDW |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for remote hdfs servers | |||||
firebird_fdw | firebird_fdw |
firebird_fdw_$v |
PIGSTY | 1.4.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Foreign data wrapper for Firebird | |||||
aws_s3 | aws_s3 |
aws_s3_$v |
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 |
log_fdw_$v* |
PIGSTY | 1.4 | FDW |
Apache-2.0 | 16 ,15 ,14 |
foreign-data wrapper for Postgres log file access | |||||
dblink | dblink |
postgresql$v-contrib |
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 |
CONTRIB | 1.0 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for flat file access | |||||
postgres_fdw | postgres_fdw |
postgresql$v-contrib |
CONTRIB | 1.1 | FDW |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
foreign-data wrapper for remote PostgreSQL servers | |||||
orafce | orafce |
orafce_$v* |
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 |
pgtt_$v* |
PGDG | 4.0.0 | SIM |
ISC | 16 ,15 ,14 ,13 ,12 |
Extension to add Global Temporary Tables feature to PostgreSQL | |||||
session_variable | session_variable |
session_variable_$v* |
PIGSTY | 3.3 | SIM |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
Registration and manipulation of session variables and constants | |||||
pg_statement_rollback | pg_statement_rollback |
pg_statement_rollback_$v* |
PGDG | 1.4 | SIM |
ISC | 16 ,15 ,14 ,13 ,12 |
Server side rollback at statement level for PostgreSQL like Oracle or DB2 | |||||
pg_dbms_metadata | pg_dbms_metadata |
pg_dbms_metadata_$v* |
PGDG | 1.0.0 | SIM |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL | |||||
pg_dbms_lock | pg_dbms_lock |
pg_dbms_lock_$v* |
PGDG | 1.0.0 | SIM |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL | |||||
pg_dbms_job | pg_dbms_job |
pg_dbms_job_$v* |
PGDG | 1.5.0 | SIM |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL | |||||
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 |
pgmemcache_$v* |
PGDG | 2.3.0 | SIM |
MIT | 16 ,15 ,14 ,13 ,12 |
memcached interface | |||||
pglogical | pglogical |
pglogical_$v* |
PGDG | 2.4.4 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PostgreSQL Logical Replication | |||||
pglogical_origin | pglogical |
pglogical_$v* |
PGDG | 1.0.0 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Dummy extension for compatibility when upgrading from Postgres 9.4 | |||||
pgl_ddl_deploy | pgl_ddl_deploy |
pgl_ddl_deploy_$v* |
PGDG | 2.2 | ETL |
MIT | 16 ,15 ,14 ,13 ,12 |
automated ddl deployment using pglogical | |||||
pg_failover_slots | pg_failover_slots |
pg_failover_slots_$v* |
PIGSTY | 1.0.1 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
PG Failover Slots extension | |||||
wal2json | wal2json |
wal2json_$v* |
PGDG | 2.5.3 | ETL |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Changing data capture in JSON format | |||||
wal2mongo | wal2mongo |
wal2mongo_$v* |
PIGSTY | 1.0.7 | ETL |
Apache-2.0 | 16 ,15 ,14 ,13 |
PostgreSQL logical decoding output plugin for MongoDB | |||||
decoderbufs | decoderbufs |
postgres-decoderbufs_$v* |
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 |
decoder_raw_$v* |
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 |
CONTRIB | 16.3 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
SQL-based test/example module for WAL logical decoding | |||||
mimeo | mimeo |
mimeo_$v |
PIGSTY | 1.5.1 | ETL |
PostgreSQL | 16 ,15 ,14 ,13 ,12 |
Extension for specialized, per-table replication between PostgreSQL instances | |||||
repmgr | repmgr |
repmgr_$v* |
PGDG | 5.4 | ETL |
GPLv3 | 16 ,15 ,14 ,13 ,12 |
Replication manager for PostgreSQL | |||||
pgcopydb | pgcopydb |
pgcopydb |
PGDG | 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 |
pg_fact_loader_$v* |
PGDG | 2.0 | ETL |
MIT | 16 ,15 ,14 ,13 ,12 |
build fact tables with Postgres | |||||
pg_bulkload | pg_bulkload |
pg_bulkload_$v* |
PGDG | 3.1.21 | ETL |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
pg_bulkload is a high speed data loading utility for PostgreSQL | |||||
pg_comparator | pg_comparator |
pg_comparator_$v* |
PGDG | 2.2.5 | ETL |
BSD 3 | 16 ,15 ,14 ,13 ,12 |
Comparation of testing and production services PostgreSQL databases. | |||||
pgimportdoc | pgimportdoc |
pgimportdoc_$v* |
PGDG | 0.1.4 | ETL |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
command line utility for importing XML, JSON, BYTEA document to PostgreSQL | |||||
pgexportdoc | pgexportdoc |
pgexportdoc_$v* |
PGDG | 0.1.4 | ETL |
BSD 2 | 16 ,15 ,14 ,13 ,12 |
export XML, JSON and BYTEA documents from 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.