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.htmlData type for auto-encrypted passwords. PG10 only
citext
- https://www.postgresql.org/docs/current/citext.htmlData type for case-insensitive character strings.
cube
- https://www.postgresql.org/docs/current/cube.htmlData type for multidimensional cubes.
hll
- https://github.com/citusdata/postgresql-hllType for storing
hyperloglog
data. PG11 and newerhstore
- https://www.postgresql.org/docs/current/hstore.htmlData type for storing sets of (key, value) pairs.
isn
- https://www.postgresql.org/docs/current/isn.htmlData types for international product numbering standards.
ltree
- https://www.postgresql.org/docs/current/ltree.htmlData type for hierarchical tree-like structures.
pgvector
- https://github.com/pgvector/pgvectorType for vector similarity search. PG13 and newer
seg
- https://www.postgresql.org/docs/current/seg.htmlData type for representing line segments or floating-point intervals.
timescaledb
- https://github.com/timescale/timescaledbEnables scalable inserts and complex queries for time-series data.
unit
- https://github.com/df7cb/postgresql-unitSI units extension.
uuid-ossp
- https://www.postgresql.org/docs/current/uuid-ossp.htmlGenerate universally unique identifiers (UUIDs).
Search and text handling#
bloom
- https://www.postgresql.org/docs/current/bloom.htmlBloom access method - signature file based index.
btree_gin
- https://www.postgresql.org/docs/current/btree-gin.htmlSupport for indexing common data types in GIN.
btree_gist
- https://www.postgresql.org/docs/current/btree-gist.htmlSupport for indexing common data types in GiST.
dict_int
- https://www.postgresql.org/docs/current/dict-int.htmlText search dictionary template for integers.
fuzzystrmatch
- https://www.postgresql.org/docs/current/fuzzystrmatch.htmlDetermine similarities and distance between strings.
pg_similarity
- https://github.com/eulerto/pg_similaritySupport similarity queries. PG13 and newer
pg_trgm
- https://www.postgresql.org/docs/current/pgtrgm.htmlText similarity measurement and index searching based on trigrams.
pgcrypto
- https://www.postgresql.org/docs/current/pgcrypto.htmlCryptographic functions.
rum
- https://github.com/postgrespro/rumRUM index access method.
unaccent
- https://www.postgresql.org/docs/current/unaccent.htmlText search dictionary that removes accents.
Auditing#
tcn
- https://www.postgresql.org/docs/current/tcn.htmlTriggered change notifications.
Geographical features#
address_standardizer
- https://postgis.net/docs/standardize_address.htmlUsed 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.htmlAddress standardizer
US dataset example.earthdistance
- https://www.postgresql.org/docs/current/earthdistance.htmlCalculate great-circle distances on the surface of the Earth.
pgrouting
- https://github.com/pgRouting/pgroutingExtends 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.htmlPostGIS raster types and functions.
postgis_sfcgal
- http://postgis.net/docs/reference.html#reference_sfcgalPostGIS SFCGAL functions.
postgis_tiger_geocoder
- https://postgis.net/docs/Extras.html#Tiger_GeocoderPostGIS tiger geocoder and reverse geocoder.
postgis_topology
- https://postgis.net/docs/Topology.htmlPostGIS topology spatial types and functions.
Procedural language#
plcoffee
- https://github.com/plv8/plv8PL/CoffeeScript (v8) trusted procedural language. PG10 only
plls
- https://github.com/plv8/plv8PL/LiveScript (v8) trusted procedural language. PG10 only
plperl
- https://www.postgresql.org/docs/current/plperl.htmlPL/Perl procedural language.
plpgsql
- https://www.postgresql.org/docs/current/plpgsql.htmlPL/pgSQL procedural language.
plv8
- https://github.com/plv8/plv8PL/JavaScript (v8) trusted procedural language. PG10 only
Connectivity#
dblink
- https://www.postgresql.org/docs/current/contrib-dblink-function.htmlConnect to other PostgreSQL databases from within a database.
postgres_fdw
- https://www.postgresql.org/docs/current/postgres-fdw.htmlForeign-data wrapper for remote PostgreSQL servers.
Utilities#
aiven_extras
- https://github.com/aiven/aiven-extrasThis 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.htmlTransform between
bool
andplperl
. PG13 and newerintagg
- https://www.postgresql.org/docs/current/intagg.htmlInteger aggregator and enumerator (obsolete).
intarray
- https://www.postgresql.org/docs/current/intarray.htmlFunctions, operators, and index support for 1-D arrays of integers.
jsonb_plperl
- https://www.postgresql.org/docs/current/datatype-json.htmlTransform between
jsonb
andplperl
.lo
- https://www.postgresql.org/docs/current/lo.htmlLarge Object maintenance.
pageinspect
- https://www.postgresql.org/docs/current/pageinspect.htmlInspect the contents of database pages at a low level.
pg_buffercache
- https://www.postgresql.org/docs/current/pgbuffercache.htmlExamine the shared buffer cache.
pg_cron
- https://github.com/citusdata/pg_cronJob scheduler for PostgreSQL.
pg_partman
- https://github.com/pgpartman/pg_partmanExtension to manage partitioned tables by time or ID.
pg_prewarm
- https://www.postgresql.org/docs/current/pgprewarm.htmlPrewarm relation data. PG11 and newer
pg_prometheus
- https://github.com/timescale/pg_prometheusPrometheus 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.htmlTrack planning and execution statistics of all SQL statements executed.
pgrowlocks
- https://www.postgresql.org/docs/current/pgrowlocks.htmlShow row-level locking information.
pgstattuple
- https://www.postgresql.org/docs/current/pgstattuple.htmlShow tuple-level statistics.
sslinfo
- https://www.postgresql.org/docs/current/sslinfo.htmlInformation about SSL certificates.
tablefunc
- https://www.postgresql.org/docs/current/tablefunc.htmlFunctions that manipulate whole tables, including
crosstab
.timetravel
- https://www.postgresql.org/docs/6.3/c0503.htmFunctions for implementing time travel. PG11 and earlier
tsm_system_rows
- https://www.postgresql.org/docs/current/tsm-system-rows.htmlTABLESAMPLE method which accepts number of rows as a limit.
tsm_system_time
- https://www.postgresql.org/docs/current/tsm-system-time.htmlTABLESAMPLE 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.htmlFunctions for verifying relation integrity.
autoinc
- https://www.postgresql.org/docs/current/contrib-spi.htmlFunctions for auto-incrementing fields.
bool_plperlu
- https://www.postgresql.org/docs/current/plperl-funcs.htmlTransform between
bool
andplperlu
. PG13 and newerdict_xsyn
- https://www.postgresql.org/docs/current/dict-xsyn.htmlText search dictionary template for extended synonym processing.
file_fdw
- https://www.postgresql.org/docs/current/file-fdw.htmlForeign-data wrapper for flat file access.
hstore_plperl
- https://www.postgresql.org/docs/current/hstore.htmlTransform between
hstore
andplperl
.hstore_plperlu
- https://www.postgresql.org/docs/current/hstore.htmlTransform between
hstore
andplperlu
.insert_username
- https://www.postgresql.org/docs/current/contrib-spi.htmlFunctions for tracking who changed a table.
jsonb_plperlu
- https://www.postgresql.org/docs/current/datatype-json.htmlTransform between
jsonb
andplperlu
.moddatetime
- https://www.postgresql.org/docs/10/contrib-spi.htmlFunctions for tracking last modification time.
old_snapshot
- https://www.postgresql.org/docs/current/oldsnapshot.htmlUtilities in support of old_snapshot_threshold. PG14 only
pageinspect
- https://www.postgresql.org/docs/current/pageinspect.htmlInspect the contents of database pages at a low level.
pg_freespacemap
- https://www.postgresql.org/docs/current/pgfreespacemap.htmlExamine the free space map (FSM).
pg_surgery
- https://www.postgresql.org/docs/current/pgsurgery.htmlExtension to perform surgery on a damaged relation. PG14 only
pg_visibility
- https://www.postgresql.org/docs/current/pgvisibility.htmlExamine the visibility map (VM) and page-level visibility info.
plperlu
- https://www.postgresql.org/docs/current/plperl-trusted.htmlPL/PerlU untrusted procedural language.
refint
- https://www.postgresql.org/docs/current/contrib-spi.htmlFunctions for implementing referential integrity (obsolete).