# Install Postgres extensions > Install and remove Postgres extensions on an Orchard managed database from the dashboard or the CLI. Source: https://docs.orchard.hackclub.com/data/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. ## Install an extension **Dashboard** 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. **CLI** ```sh orchard db extension list orchard db extension install vector ``` For an extension that loads at startup, add `--preload`. This option restarts the database. ## Remove an extension **Dashboard** 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. **CLI** ```sh orchard db extension uninstall vector ``` For an extension that loads at startup, add `--remove-preload`. This option restarts the database. > **Caution** > > Orchard runs `DROP EXTENSION ... CASCADE`, so columns, indexes, and functions that use the extension are dropped with it. When backup storage is set, Orchard tries to take a [checkpoint](/data/backups/#take-a-checkpoint) first. Restore that checkpoint to bring the dropped objects back. ## Allowed extensions 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. | Purpose | Extensions | | ----------------- | ------------------------------------------------------------------------ | | UUIDs and hashing | `uuid-ossp`, `pgcrypto` | | Vectors | `vector`, `pgvector` | | Geospatial | `postgis`, `postgis_topology`, `postgis_raster`, `cube`, `earthdistance` | | Text search | `pg_trgm`, `unaccent`, `fuzzystrmatch`, `citext` | | Data types | `hstore`, `ltree`, `isn`, `intarray` | | Indexes | `btree_gin`, `btree_gist` | | Query statistics | `pg_stat_statements` | | Other | `tablefunc`, `plpgsql`, `timescaledb` | An extension must also exist in the Postgres image. If you need one that is missing, an operator must change the image. ## Related resources - [Monitor a database](/data/monitoring/) - Turn on `pg_stat_statements` from the **Queries** view to find slow queries. - [`orchard db extension` reference](/reference/cli/#db) - Review the extension commands and their flags.