PostgreSQL - Available extensions – Support Guides

List of available extensions

OVHcloud 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, and 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 Name	Reference	Notes
`pgaudit`	Link	Provides session and object audit logging, often required for compliance with government, financial, or ISO certifications
`tcn`	Link	Triggered change notifications.

Connectivity

Extension Name	Reference	Notes
`dblink`	Link	Connect to other PostgreSQL databases from within a database.
`postgres_fdw`	Link	Foreign-data wrapper for remote PostgreSQL servers.

Data types

Extension Name	Reference	Notes
`citext`	Link	Data type for case-insensitive character strings.
`cube`	Link	Data type for multidimensional cubes.
`hll`	Link	Type for storing `hyperloglog` data. `PG11 and newer`
`hstore`	Link	Data type for storing sets of (key, value) pairs.
`isn`	Link	Data types for international product numbering standards.
`ltree`	Link	Data type for hierarchical tree-like structures.
`seg`	Link	Data type for representing line segments or floating-point intervals.
`timescaledb`	Link	Enables scalable inserts and complex queries for time-series data.
`unit`	Link	SI units extension.
`uuid-ossp`	Link	Generate universally unique identifiers (UUIDs).

Geographical features

Extension Name	Reference	Notes
`address_standardizer`	Link	Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
`address_standardizer_data_us`	Link	Address standardizer US dataset example.
`earthdistance`	Link	Calculate great-circle distances on the surface of the Earth.
`h3`	Link	PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system.
`h3_postgis`	Link	H3 PostGIS integration.
`pgrouting`	Link	Extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.
`postgis`	Link	PostGIS geometry and geography spatial types and functions.
`postgis_legacy`	Link	Legacy functions for PostGIS.
`postgis_raster`	Link	PostGIS raster types and functions.
`postgis_sfcgal`	Link	PostGIS SFCGAL functions.
`postgis_tiger_geocoder`	Link	PostGIS tiger geocoder and reverse geocoder.
`postgis_topology`	Link	PostGIS topology spatial types and functions.

Machine learning (ML) and artificial intelligence (AI)

Extension Name	Reference	Notes
`pgvector`	Link	Designed for vector similarity search for PostgreSQL. `PG13 and newer`
`pgvectorscale`	Link	Complements `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 Name	Reference	Notes
`plperl`	Link	PL/Perl procedural language.
`plpgsql`	Link	PL/pgSQL procedural language.

Search and text handling

Extension Name	Reference	Notes
`bloom`	Link	Bloom access method - signature file-based index.
`btree_gin`	Link	Support for indexing common data types in GIN.
`btree_gist`	Link	Support for indexing common data types in GiST.
`dict_int`	Link	Text search dictionary template for integers.
`fuzzystrmatch`	Link	Determine similarities and distance between strings.
`pg_similarity`	Link	Support similarity queries. `PG13 and newer`
`pg_trgm`	Link	Text similarity measurement and index searching based on trigrams.
`pgcrypto`	Link	Cryptographic functions.
`rum`	Link	RUM index access method.
`unaccent`	Link	Text search dictionary that removes accents.

Utilities

Extension Name	Reference	Notes
`aiven_extras`	Link	This extension is meant for use in environments where you want non-superusers to be able to use certain database features.
`bool_plperl`	Link	Transform between `bool` and `plperl`. `PG13 and newer`
`intagg`	Link	Integer aggregator and enumerator (obsolete).
`intarray`	Link	Functions, operators, and index support for 1-D arrays of integers.
`jsonb_plperl`	Link	Transform between `jsonb` and `plperl`.
`lo`	Link	Large Object maintenance.
`pageinspect`	Link	Inspect the contents of database pages at a low level.
`pg_buffercache`	Link	Examine the shared buffer cache.
`pg_cron`	Link	Job scheduler for PostgreSQL.
`pg_partman`	Link	Extension to manage partitioned tables by time or ID.
`pg_prewarm`	Link	Prewarm relation data. PG11 and newer
`pg_prometheus`	Link	Prometheus metrics for PostgreSQL. `PG12 and earlier`
`pg_repack`	Link	Reorganize tables in PostgreSQL databases with minimal locks.
`pg_stat_statements`	Link	Track planning and execution statistics of all SQL statements executed.
`pgrowlocks`	Link	Show row-level locking information.
`pgstattuple`	Link	Show tuple-level statistics.
`sslinfo`	Link	Information about SSL certificates.
`tablefunc`	Link	Functions that manipulate whole tables, including `crosstab`.
`timetravel`	Link	Functions for implementing time travel. `PG11 and earlier`
`tsm_system_rows`	Link	TABLESAMPLE method, which accepts number of rows as a limit.
`tsm_system_time`	Link	TABLESAMPLE 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.

Go further

For more information and tutorials, please see our other Managed Databases & Analytics or Platform as a Service guides. You can also explore the guides for other OVHcloud products and services.