Frequently Asked Questions (FAQs)

Replica nodes are copies of the primary node in a Vultr Managed Databases for PostgreSQL cluster. You can create replica nodes during provisioning, or click Add Read Only Replica Node in the Actions section within the Overview tab in your cluster's management page.

The attached replica nodes are failover nodes used to ensure high availability and recovery of your database cluster in case the primary node fails. Failover replicas are read-only while the primary node performs the write operations in your cluster to ensure data consistency across all replicas.

Yes, you can create read-only replica nodes in other Vultr locations, different from your Vultr Managed Databases for PostgreSQL cluster location. Click Add Read-Only Replica Node to create a new replica node and specify the target Vultr location.

You can attach up-to 3 replica nodes to a Vultr Managed Databases for PostgreSQL cluster.

Click Overview within your Vultr Managed Databases for PostgreSQL cluster's management page

Find the General Information section within the Overview tab of your cluster's management page and node the Node Plan value. The Vultr Managed Databases for PostgreSQL node plan uses a Vultr-Dbaas-[plan type]-[other internal information] format. For example, vultr-dbaas-premium-cc-1-55-2.

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

Click Change Plan menu on the Settings tab to scale your cluster up.

Navigate to the Settings tab and click *Change Plan** to upgrade your cluster. Verify the Current Plan information and select your target plan within the Change Plan section, then, click Save to scale your cluster.

You cannot create superuser accounts for managed databases. You can only create standard user accounts in your cluster. Navigate to the Users & Databases tab to create a new user.

No, you can only use one primary node at a time. However, you can use multiple replica-nodes in a cluster. A replica node may be elected incase the primary node fails.

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

Vultr Managed Databases for PostgreSQL support multiple PostgreSQL versions from 13 to the latest version.

Connect to your Vultr Managed Databases cluster using psql and follow the steps below to enable extensions.

1. View the available extensions.

   sql Copy

   SELECT * FROM pg_available_extensions;
   

2. Enable a new extension.

   sql Copy

   CREATE EXTENSION extension_name;
   

3. Remove an extension.

   sql Copy

   DROP EXTENSION extension_name;