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

2. To enable a specific extension, use:

   sql Copy

   defaultdb=> CREATE EXTENSION <extension_name>;
   

   Explain Code

   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

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