Frequently Asked Questions (FAQs)

You can deploy managed databases in several node plans, which are a shorthand way of identifying the available size and number of nodes. We offer Hobbyist, Startup, Business, and Premium node plans.

After you deploy a managed database, look in the General Information section of your cluster's information page. The Node Plan appears below the Monthly Price. The plan name format is Vultr-Dbaas-[plan type]-[other internal information].

The node plan determines what backup and recovery options are available.

Yes you can deploy managed databases for PostgreSQL using the Vultr Customer Portal, Vultr API, or Vultr API.

Use the Change Plan menu on the Settings tab to scale your cluster up. To scale a cluster down, migrate or fork it to a new, smaller cluster.

You cannot create superuser accounts for managed databases. To create a standard user account, use the Vultr Customer Portal.

A cluster can only have one primary node, but you can have multiple replica (read-only) nodes.

Yes, you must use primary keys for all database tables, which is enforced through the database configuration.

Vultr Managed Databases for PostgreSQL supports PostgreSQL versions 13 through 16.

To enable or remove PostgreSQL extensions, connect to the database server with psql and follow the steps below:

1. Check the available extensions.

   sql Copy

   SELECT * FROM pg_available_extensions;
   

2. Enable an extension.

   sql Copy

   CREATE EXTENSION extension_name;
   

3. Remove an extension.

   sql Copy

   DROP EXTENSION extension_name;