voroa Docs Go to dashboard
Guides

How to enable PostgreSQL extensions on Voroa

Enable standard PostgreSQL extensions — uuid-ossp, citext, pg_trgm, pgcrypto, hstore — on your Voroa managed Postgres database. No restart needed, applies within 5 minutes.

Voroa managed Postgres databases support a set of standard extensions that you can enable yourself without restarting your database or contacting support. Extensions apply within 5 minutes.

Supported extensions

Extension What it adds
UUID Generation (uuid-ossp) uuid_generate_v4() and related functions for generating UUIDs inside SQL.
Case-insensitive Text (citext) The CITEXT type for case-insensitive text comparisons without adding LOWER() to every query.
Trigram Search (pg_trgm) Trigram-based similarity search and fast ILIKE queries via GIN indexes. Useful for full-text search on short strings.
Cryptographic Functions (pgcrypto) digest(), crypt(), gen_random_bytes(), and other cryptographic helpers for hashing and encryption inside the database.
Key-Value Store (hstore) The hstore type for storing sets of key-value pairs in a single column.

These extensions are part of the standard Postgres distribution and do not require a database restart to enable.

Enable an extension

  1. Open your Postgres database from the dashboard.
  2. Go to the Settings tab.
  3. Find the Extensions section.
  4. Select Enable next to the extension you want.

The extension status changes to Pending. It is enabled within 5 minutes. Once enabled, the status shows Enabled and you can start using it immediately in your queries.

Use an extension

Once enabled, use the extension’s functions and types in your SQL queries directly. For example, after enabling UUID Generation:

SELECT uuid_generate_v4();

After enabling Trigram Search, create a GIN index for fast text search:

CREATE INDEX ON articles USING gin(title gin_trgm_ops);

Coming soon

The following extensions require either a database restart or additional server configuration and are not available for self-serve enable at this time:

  • TimescaleDB (time-series)
  • pgvector (vector similarity search)
  • pg_cron (scheduled jobs inside the database)
  • PostGIS (geographic data types)

If your application needs one of these, contact support.

Disable an extension

Extension disable is not available for self-serve at this time. Dropping an extension can break application code that depends on the types or functions it provides. Contact support if you need to remove an extension.

Last updated July 12, 2026