---
title: FAQ
url: https://docs.vultr.com/products/storage/databases/postgresql/faq
description: Frequently asked questions and answers about Vultr Managed Databases for PostgreSQL service features and functionality.
publish_date: 2024-09-23T20:21:38.545314Z
last_updated: 2026-05-26T19:43:28.049821Z
---

# Frequently Asked Questions (FAQs) About Vultr Managed Databases for PostgreSQL

These are the frequently asked questions for Vultr Managed Databases for PostgreSQL.

???+ note "Is the Vultr Managed Databases for PostgreSQL cluster backed up?"

    Yes, Vultr Managed Databases for PostgreSQL are automatically backed up. In addition, all server plans other than `Hobbyist` offer user-initiated recovery, forking, and point-in-time backups to restore a cluster incase of any failures. Navigate to the **Actions** section within the **Overview** tab in your Vultr Managed Databases for PostgreSQL management page to fork a database cluster, and restore data from backups.

    Vultr Managed Databases for PostgreSQL offer point-in-time recovery history, and the duration available depends on your node plan.

    * Premium: `30 days`
    * Business: `14 days`
    * Startup: `2 days`
    * Hobbyist: `None`

??? note "What are Replica Nodes?"

    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.

??? note "What type of Replica Nodes are attached to a Vultr Managed Databases for PostgreSQL cluster?"

    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.

??? note "Can I create replica nodes in a Vultr location that's different from my cluster location?"

    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.

??? note "How many Replica Nodes can I attach to a Vultr Managed Databases for PostgreSQL cluster?"

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

??? note "How can I find my node plan?"

    * 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 note 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`.

??? note "Can I deploy managed databases using the Vultr API or Vultr CLI?"

    Yes, you can deploy managed databases for PostgreSQL using the Vultr Console, Vultr API, or Vultr CLI.

??? note "How do I scale my database cluster?"

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

??? note "Can I create admin (superuser) or root-level accounts?"

    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.

??? note "Can I use multiple primary (write) nodes?"

    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.

??? note "Do I need to use primary keys for my tables?"

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

??? note "What PostgreSQL versions are available?"

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

??? note "How do I enable extensions for a PostgreSQL database?"

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

    1. View the available extensions.

        ```sql
        SELECT * FROM pg_available_extensions;
        ```

    1. Enable a new extension.

        ```sql
        CREATE EXTENSION extension_name;
        ```

    1. Remove an extension.

        ```sql
        DROP EXTENSION extension_name;
        ```