Skip to content
Install

Install Postgres extensions

Extensions add features to Postgres, such as vector search with pgvector or geospatial types with PostGIS. When you install one, Orchard runs CREATE EXTENSION against the database for you. Only extensions on an allowlist are available, because some extensions can run code or reach the network from the database pod.

  1. Open the database.
  2. Go to Settings > Extensions.
  3. Find the extension.
  4. Turn on its switch.

An extension that loads at startup shows Loads at startup, restarts the database. Installing one of these restarts the database and drops open connections.

  1. Open the database.
  2. Go to Settings > Extensions.
  3. Turn off the extension’s switch.
  4. Select Drop extension, or Drop and restart for an extension that loads at startup.

Orchard allows the following extensions. It refuses others, because untrusted languages and foreign data wrappers can run code or reach the network from the database pod.

PurposeExtensions
UUIDs and hashinguuid-ossp, pgcrypto
Vectorsvector, pgvector
Geospatialpostgis, postgis_topology, postgis_raster, cube, earthdistance
Text searchpg_trgm, unaccent, fuzzystrmatch, citext
Data typeshstore, ltree, isn, intarray
Indexesbtree_gin, btree_gist
Query statisticspg_stat_statements
Othertablefunc, plpgsql, timescaledb

An extension must also exist in the Postgres image. If you need one that is missing, an operator must change the image.