Web Cloud Databases - Enabling PostgreSQL extensions

View as Markdown

Find out how to enable the available extensions (PostGIS, hstore, unaccent, etc.) on a PostgreSQL database hosted on Web Cloud Databases

Objective

PostgreSQL extensions are modules that enrich your database with additional features: new data types, functions, operators or procedural languages. On a Web Cloud Databases solution, you can enable the compatible extensions directly from the OVHcloud Control Panel, without using the command line.

This guide explains how to enable the available extensions on a PostgreSQL database hosted on a Web Cloud Databases solution.

Requirements

OVHcloud Control Panel Access

  • Direct link:
  • Navigation path: Web Cloud > Web Cloud Databases > Select your database service

Instructions

Enabling an extension

Click on the tabs below to view each of the 3 steps.

Step 1
Step 2
Step 3

Go to the page, then select the relevant service.

Web Cloud Databases
Info

Enabling an extension applies to the selected database. To enable it on another database on the same server, repeat the operation by selecting the database concerned.

Available extensions

The list of extensions offered depends on the PostgreSQL version used by your server. The extensions available for your version are displayed in the activation window.

Here is the list of available extensions:

ExtensionDescription
address_standardizerUsed to parse an address into constituent elements. Generally used to support the geocoding address normalisation step.
autoincFunctions for autoincrementing fields.
bloomBloom access method - signature file based index.
btree_ginSupport for indexing common datatypes in GIN.
btree_gistSupport for indexing common datatypes in GiST.
citextData type for case-insensitive character strings.
cubeData type for multidimensional cubes.
earthdistanceCalculate great-circle distances on the surface of the Earth.
fuzzystrmatchDetermine similarities and distance between strings.
hstoreData type for storing sets of (key, value) pairs.
intarrayFunctions, operators, and index support for 1-D arrays of integers.
isnData types for international product numbering standards.
ltreeData type for hierarchical tree-like structures.
moddatetimeFunctions for tracking last modification time.
pg_trgmText similarity measurement and index searching based on trigrams.
pgcryptoCryptographic functions.
postgisPostGIS geometry, geography, and raster spatial types and functions.
postgis_rasterPostGIS raster types and functions.
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder.
postgis_topologyPostGIS topology spatial types and functions.
segData type for representing line segments or floating-point intervals.
unaccentText search dictionary that removes accents.
uuid-osspGenerate universally unique identifiers (UUIDs).
xml2XPath querying and XSLT.

Go further

Configuring your database server

Getting started with PostgreSQL

For specialised services (SEO, development, etc.), contact OVHcloud partners.

If you would like assistance using and configuring your OVHcloud solutions, please refer to our support offers.

Join our community of users.

Was this page helpful?