Extensions on Aiven for PostgreSQL®#

The following PostgreSQL® extensions are available. Please note that some of the extensions have dependencies and they need to be created in the proper order. Some extensions may require disconnecting the client connection and reconnecting before they are fully available.

To check the details, including the version number of the extension, run select * from pg_available_extensions in your Aiven for PostgreSQL server.

Note

Not all extensions listed in pg_available_extensions are able to be installed. See Superuser-only Extensions for more.

Data types#

chkpass - https://www.postgresql.org/docs/10/chkpass.html

Data type for auto-encrypted passwords. PG10 only

citext - https://www.postgresql.org/docs/current/citext.html

Data type for case-insensitive character strings.

cube - https://www.postgresql.org/docs/current/cube.html

Data type for multidimensional cubes.

hll - https://github.com/citusdata/postgresql-hll

Type for storing hyperloglog data. PG11 and newer

hstore - https://www.postgresql.org/docs/current/hstore.html

Data type for storing sets of (key, value) pairs.

isn - https://www.postgresql.org/docs/current/isn.html

Data types for international product numbering standards.

ltree - https://www.postgresql.org/docs/current/ltree.html

Data type for hierarchical tree-like structures.

seg - https://www.postgresql.org/docs/current/seg.html

Data type for representing line segments or floating-point intervals.

timescaledb - https://github.com/timescale/timescaledb

Enables scalable inserts and complex queries for time-series data.

unit - https://github.com/df7cb/postgresql-unit

SI units extension.

uuid-ossp - https://www.postgresql.org/docs/current/uuid-ossp.html

Generate universally unique identifiers (UUIDs).

Search and text handling#

bloom - https://www.postgresql.org/docs/current/bloom.html

Bloom access method - signature file based index.

btree_gin - https://www.postgresql.org/docs/current/btree-gin.html

Support for indexing common data types in GIN.

btree_gist - https://www.postgresql.org/docs/current/btree-gist.html

Support for indexing common data types in GiST.

dict_int - https://www.postgresql.org/docs/current/dict-int.html

Text search dictionary template for integers.

fuzzystrmatch - https://www.postgresql.org/docs/current/fuzzystrmatch.html

Determine similarities and distance between strings.

pg_similarity - https://github.com/eulerto/pg_similarity

Support similarity queries. PG13 and newer

pg_trgm - https://www.postgresql.org/docs/current/pgtrgm.html

Text similarity measurement and index searching based on trigrams.

pgcrypto - https://www.postgresql.org/docs/current/pgcrypto.html

Cryptographic functions.

rum - https://github.com/postgrespro/rum

RUM index access method.

unaccent - https://www.postgresql.org/docs/current/unaccent.html

Text search dictionary that removes accents.

Auditing#

tcn - https://www.postgresql.org/docs/current/tcn.html

Triggered change notifications.

Geographical features#

address_standardizer - https://postgis.net/docs/standardize_address.html

Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.

address_standardizer_data_us - https://postgis.net/docs/standardize_address.html

Address standardizer US dataset example.

earthdistance - https://www.postgresql.org/docs/current/earthdistance.html

Calculate great-circle distances on the surface of the Earth.

pgrouting - https://github.com/pgRouting/pgrouting

Extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.

postgis - https://postgis.net/

PostGIS geometry and geography spatial types and functions.

postgis_legacy - https://postgis.net/

Legacy functions for PostGIS.

postgis_raster - https://postgis.net/docs/RT_reference.html

PostGIS raster types and functions.

postgis_sfcgal - http://postgis.net/docs/reference.html#reference_sfcgal

PostGIS SFCGAL functions.

postgis_tiger_geocoder - https://postgis.net/docs/Extras.html#Tiger_Geocoder

PostGIS tiger geocoder and reverse geocoder.

postgis_topology - https://postgis.net/docs/Topology.html

PostGIS topology spatial types and functions.

Procedural language#

plcoffee - https://github.com/plv8/plv8

PL/CoffeeScript (v8) trusted procedural language. PG10 only

plls - https://github.com/plv8/plv8

PL/LiveScript (v8) trusted procedural language. PG10 only

plperl - https://www.postgresql.org/docs/current/plperl.html

PL/Perl procedural language.

plpgsql - https://www.postgresql.org/docs/current/plpgsql.html

PL/pgSQL procedural language.

plv8 - https://github.com/plv8/plv8

PL/JavaScript (v8) trusted procedural language. PG10 only

Connectivity#

dblink - https://www.postgresql.org/docs/current/contrib-dblink-function.html

Connect to other PostgreSQL databases from within a database.

postgres_fdw - https://www.postgresql.org/docs/current/postgres-fdw.html

Foreign-data wrapper for remote PostgreSQL servers.

Utilities#

aiven_extras - https://github.com/aiven/aiven-extras

This extension is meant for use in environments where you want non-superusers to be able to use certain database features.

bool_plperl - https://www.postgresql.org/docs/current/plperl-funcs.html

Transform between bool and plperl. PG13 and newer

intagg - https://www.postgresql.org/docs/current/intagg.html

Integer aggregator and enumerator (obsolete).

intarray - https://www.postgresql.org/docs/current/intarray.html

Functions, operators, and index support for 1-D arrays of integers.

jsonb_plperl - https://www.postgresql.org/docs/current/datatype-json.html

Transform between jsonb and plperl.

lo - https://www.postgresql.org/docs/current/lo.html

Large Object maintenance.

pageinspect - https://www.postgresql.org/docs/current/pageinspect.html

Inspect the contents of database pages at a low level.

pg_buffercache - https://www.postgresql.org/docs/current/pgbuffercache.html

Examine the shared buffer cache.

pg_cron - https://github.com/citusdata/pg_cron

Job scheduler for PostgreSQL.

pg_partman - https://github.com/pgpartman/pg_partman

Extension to manage partitioned tables by time or ID.

pg_prewarm - https://www.postgresql.org/docs/current/pgprewarm.html

Prewarm relation data. PG11 and newer

pg_prometheus - https://github.com/timescale/pg_prometheus

Prometheus metrics for PostgreSQL. PG12 and earlier

pg_repack - https://pgxn.org/dist/pg_repack/1.4.6/

Reorganize tables in PostgreSQL databases with minimal locks.

pg_stat_statements - https://www.postgresql.org/docs/current/pgstatstatements.html

Track planning and execution statistics of all SQL statements executed.

pgrowlocks - https://www.postgresql.org/docs/current/pgrowlocks.html

Show row-level locking information.

pgstattuple - https://www.postgresql.org/docs/current/pgstattuple.html

Show tuple-level statistics.

sslinfo - https://www.postgresql.org/docs/current/sslinfo.html

Information about SSL certificates.

tablefunc - https://www.postgresql.org/docs/current/tablefunc.html

Functions that manipulate whole tables, including crosstab.

timetravel - https://www.postgresql.org/docs/6.3/c0503.htm

Functions for implementing time travel. PG11 and earlier

tsm_system_rows - https://www.postgresql.org/docs/current/tsm-system-rows.html

TABLESAMPLE method which accepts number of rows as a limit.

tsm_system_time - https://www.postgresql.org/docs/current/tsm-system-time.html

TABLESAMPLE method which accepts time in milliseconds as a limit.

Superuser-only extensions#

The following extensions can only be installed by superusers, and are not generally available.

amcheck - https://www.postgresql.org/docs/current/amcheck.html

Functions for verifying relation integrity.

autoinc - https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.6

Functions for auto-incrementing fields.

bool_plperlu - https://www.postgresql.org/docs/current/plperl-funcs.html

Transform between bool and plperlu. PG13 and newer

dict_xsyn - https://www.postgresql.org/docs/current/dict-xsyn.html

Text search dictionary template for extended synonym processing.

file_fdw - https://www.postgresql.org/docs/current/file-fdw.html

Foreign-data wrapper for flat file access.

hstore_plperl - https://www.postgresql.org/docs/current/hstore.html

Transform between hstore and plperl.

hstore_plperlu - https://www.postgresql.org/docs/current/hstore.html

Transform between hstore and plperlu.

insert_username - https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.7

Functions for tracking who changed a table.

jsonb_plperlu - https://www.postgresql.org/docs/current/datatype-json.html

Transform between jsonb and plperlu.

moddatetime - https://www.postgresql.org/docs/10/contrib-spi.html#id-1.11.7.46.9

Functions for tracking last modification time.

old_snapshot - https://www.postgresql.org/docs/current/oldsnapshot.html

Utilities in support of old_snapshot_threshold. PG14 only

pageinspect - https://www.postgresql.org/docs/current/pageinspect.html

Inspect the contents of database pages at a low level.

pg_freespacemap - https://www.postgresql.org/docs/current/pgfreespacemap.html

Examine the free space map (FSM).

pg_surgery - https://www.postgresql.org/docs/current/pgsurgery.html

Extension to perform surgery on a damaged relation. PG14 only

pg_visibility - https://www.postgresql.org/docs/current/pgvisibility.html

Examine the visibility map (VM) and page-level visibility info.

plperlu - https://www.postgresql.org/docs/current/plperl-trusted.html

PL/PerlU untrusted procedural language.

refint - https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.5

Functions for implementing referential integrity (obsolete).