How Do I Enable Extensions in a Vultr Managed PostgreSQL Database?

Vultr Managed Databases for PostgreSQL allow you to enable and manage supported extensions to extend database functionality. To work with extensions, connect to your cluster using the vultradmin user or another role with sufficient privileges.

1. To see all extensions available in your current database, run:

   SQL

   Copy

   defaultdb=> SELECT * FROM pg_available_extensions;

   Explain Code

   Powered by Vultr AgentBeta

2. To enable a specific extension, use:

   SQL

   Copy

   defaultdb=> CREATE EXTENSION <extension_name>;

   Explain Code

   Powered by Vultr AgentBeta

   Replace extension_name with the name of the extension you want to enable, such as vector for pgvector functionality.

3. To remove an extension no longer needed, run:

   SQL

   Copy

   defaultdb=> DROP EXTENSION <extension_name>;

   Explain Code

   Powered by Vultr AgentBeta

This ensures that extension management is restricted to authorized users, keeping your Vultr Managed PostgreSQL cluster secure and consistent.