Available extensions for Public Cloud Databases for PostgreSQL

Knowledge Base

KB0069556

Available extensions for Public Cloud Databases for PostgreSQL


Icons/System/eye-open Created with Sketch. 67 Views 08.01.2026 PostgreSQL

List of available extensions

Public Cloud Databases for PostgreSQL come with a set of supported extensions.

You cannot install unsupported ones, since they are managed and industrialized services. Contact us if an extension is missing for your project, we may consider the implementation.

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

Auditing

Extension NameLinkNotes
pgaudithttps://github.com/pgaudit/pgauditProvides session and object audit logging often required for compliance with government, financial, or ISO certifications
tcnhttps://www.postgresql.org/docs/current/tcn.htmlTriggered change notifications.

Connectivity

Extension NameLinkNotes
dblinkhttps://www.postgresql.org/docs/current/contrib-dblink-function.htmlConnect to other PostgreSQL databases from within a database.
postgres_fdwhttps://www.postgresql.org/docs/current/postgres-fdw.htmlForeign-data wrapper for remote PostgreSQL servers.

Data types

Extension NameLinkNotes
citexthttps://www.postgresql.org/docs/current/citext.htmlData type for case-insensitive character strings.
cubehttps://www.postgresql.org/docs/current/cube.htmlData type for multidimensional cubes.
hllhttps://github.com/citusdata/postgresql-hllType for storing hyperloglog data. PG11 and newer
hstorehttps://www.postgresql.org/docs/current/hstore.htmlData type for storing sets of (key, value) pairs.
isnhttps://www.postgresql.org/docs/current/isn.htmlData types for international product numbering standards.
ltreehttps://www.postgresql.org/docs/current/ltree.htmlData type for hierarchical tree-like structures.
seghttps://www.postgresql.org/docs/current/seg.htmlData type for representing line segments or floating-point intervals.
timescaledbhttps://github.com/timescale/timescaledbEnables scalable inserts and complex queries for time-series data. Not yet available on PG18
unithttps://github.com/df7cb/postgresql-unitSI units extension.
uuid-ossphttps://www.postgresql.org/docs/current/uuid-ossp.htmlGenerate universally unique identifiers (UUIDs).

Geographical features

Extension NameLinkNotes
address_standardizerhttps://postgis.net/docs/standardize_address.htmlUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_ushttps://postgis.net/docs/standardize_address.htmlAddress standardizer US dataset example.
earthdistancehttps://www.postgresql.org/docs/current/earthdistance.htmlCalculate great-circle distances on the surface of the Earth.
h3https://github.com/zachasme/h3-pgPostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system.
h3_postgishttps://github.com/zachasme/h3-pgH3 PostGIS integration.
pgroutinghttps://github.com/pgRouting/pgroutingExtends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.
postgishttps://postgis.net/PostGIS geometry and geography spatial types and functions.
postgis_legacyhttps://postgis.net/Legacy functions for PostGIS.
postgis_rasterhttps://postgis.net/docs/RT_reference.htmlPostGIS raster types and functions.
postgis_sfcgalhttps://postgis.net/docs/reference_sfcgal.htmlPostGIS SFCGAL functions.
postgis_tiger_geocoderhttps://postgis.net/docs/Extras.html#Tiger_GeocoderPostGIS tiger geocoder and reverse geocoder.
postgis_topologyhttps://postgis.net/docs/Topology.htmlPostGIS topology spatial types and functions.

Machine learning (ML) and artificial intelligence (AI)

Extension NameLinkNotes
pgvectorhttps://github.com/pgvector/pgvectorDesigned for vector similarity search for PostgreSQL. PG13 and newer
pgvectorscalehttps://github.com/timescale/pgvectorscaleComplements pgvector as a vector data extension for PostgreSQL. PG16 and newer

Supported pgvectorscale versions:

  • PG16: pgvectorscale-0.6.0
  • PG17: pgvectorscale-0.6.0

Procedural language

Extension NameLinkNotes
plperlhttps://www.postgresql.org/docs/current/plperl.htmlPL/Perl procedural language.
plpgsqlhttps://www.postgresql.org/docs/current/plpgsql.htmlPL/pgSQL procedural language.

Search and text handling

Extension NameLinkNotes
bloomhttps://www.postgresql.org/docs/current/bloom.htmlBloom access method - signature file based index.
btree_ginhttps://www.postgresql.org/docs/current/btree-gin.htmlSupport for indexing common data types in GIN.
btree_gisthttps://www.postgresql.org/docs/current/btree-gist.htmlSupport for indexing common data types in GiST.
dict_inthttps://www.postgresql.org/docs/current/dict-int.htmlText search dictionary template for integers.
fuzzystrmatchhttps://www.postgresql.org/docs/current/fuzzystrmatch.htmlDetermine similarities and distance between strings.
pg_similarityhttps://github.com/eulerto/pg_similaritySupport similarity queries. PG13 and newer
pg_trgmhttps://www.postgresql.org/docs/current/pgtrgm.htmlText similarity measurement and index searching based on trigrams.
pgcryptohttps://www.postgresql.org/docs/current/pgcrypto.htmlCryptographic functions.
rumhttps://github.com/postgrespro/rumRUM index access method.
unaccenthttps://www.postgresql.org/docs/current/unaccent.htmlText search dictionary that removes accents.

Utilities

Extension NameLinkNotes
aiven_extrashttps://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_plperlhttps://www.postgresql.org/docs/current/plperl-funcs.htmlTransform between bool and plperl. PG13 and newer
intagghttps://www.postgresql.org/docs/current/intagg.htmlInteger aggregator and enumerator (obsolete).
intarrayhttps://www.postgresql.org/docs/current/intarray.htmlFunctions, operators, and index support for 1-D arrays of integers.
jsonb_plperlhttps://www.postgresql.org/docs/current/datatype-json.htmlTransform between jsonb and plperl.
lohttps://www.postgresql.org/docs/current/lo.htmlLarge Object maintenance.
pageinspecthttps://www.postgresql.org/docs/current/pageinspect.htmlInspect the contents of database pages at a low level.
pg_buffercachehttps://www.postgresql.org/docs/current/pgbuffercache.htmlExamine the shared buffer cache.
pg_cronhttps://github.com/citusdata/pg_cronJob scheduler for PostgreSQL.
pg_partmanhttps://github.com/pgpartman/pg_partmanExtension to manage partitioned tables by time or ID.
pg_prewarmhttps://www.postgresql.org/docs/current/pgprewarm.htmlPrewarm relation data. PG11 and newer
pg_prometheushttps://github.com/timescale/pg_prometheusPrometheus metrics for PostgreSQL. PG12 and earlier
pg_repackhttps://pgxn.org/dist/pg_repack/1.4.6/Reorganize tables in PostgreSQL databases with minimal locks.
pg_stat_statementshttps://www.postgresql.org/docs/current/pgstatstatements.htmlTrack planning and execution statistics of all SQL statements executed.
pgrowlockshttps://www.postgresql.org/docs/current/pgrowlocks.htmlShow row-level locking information.
pgstattuplehttps://www.postgresql.org/docs/current/pgstattuple.htmlShow tuple-level statistics.
sslinfohttps://www.postgresql.org/docs/current/sslinfo.htmlInformation about SSL certificates.
tablefunchttps://www.postgresql.org/docs/current/tablefunc.htmlFunctions that manipulate whole tables, including crosstab.
timetravelhttps://www.postgresql.org/docs/6.3/c0503.htmFunctions for implementing time travel. PG11 and earlier
tsm_system_rowshttps://www.postgresql.org/docs/current/tsm-system-rows.htmlTABLESAMPLE method which accepts number of rows as a limit.
tsm_system_timehttps://www.postgresql.org/docs/current/tsm-system-time.htmlTABLESAMPLE method which accepts time in milliseconds as a limit.

Installing an extension

You can list available extensions:

defaultdb=> SELECT * FROM pg_available_extensions;                                                                                                                                        
             name             | default_version | installed_version |                                                      comment
------------------------------+-----------------+-------------------+--------------------------------------------------------------------------------------------------------------------
 address_standardizer         | 3.2.4           |                   | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
 address_standardizer_data_us | 3.2.4           |                   | Address Standardizer US dataset example
 aiven_extras                 | 1.1.8           |                   | aiven_extras
 aiven_gatekeeper             | 1.0.0           |                   | Aiven standard security library
 [...]
(71 rows)

Install an available extension:

defaultdb=> CREATE EXTENSION IF NOT EXISTS "<extension_name>";
CREATE EXTENSION

Check installed extensions:

defaultdb=> \dx
                     List of installed extensions
     Name     | Version |    Schema    |         Description          
--------------+---------+--------------+------------------------------
 aiven_extras | 1.1.8   | aiven_extras | aiven_extras
 pg_cron      | 1.4-1   | public       | Job scheduler for PostgreSQL
 plpgsql      | 1.0     | pg_catalog   | PL/pgSQL procedural language

 -- In this example, aiven_extras and pg_cron are installed. plpgsql is installed by default.

We want your feedback!

We would love to help answer questions and appreciate any feedback you may have.

If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

Are you on Discord? Connect to our channel at https://discord.gg/ovhcloud and interact directly with the team that builds our databases service!

Related articles