Frequently Asked Questions (FAQs) About Vultr Managed Databases for PostgreSQL
-
- 23
Frequently Asked Questions (FAQs) About Vultr Managed Databases for PostgreSQL
Frequently asked questions and answers about Vultr Managed Databases for PostgreSQL service features and functionality.
These are the frequently asked questions for Vultr Managed Databases for PostgreSQL.
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
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.
What type of Replica nodes are attached to a Vultr managed Database 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.
Can I create Replica nodes in Vultr locations that’s different from 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.
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.
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 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.
Can I deploy managed databases for Vultr API, or Vultr API?
Yes you can deploy managed databases for PostgreSQL using the Vultr Customer Portal, Vultr API, or Vultr API.
How do I scale my Database cluster?
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.
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.
Can I use multiple (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.
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.
What PostgreSQL versions are available?
Vultr Managed Databases for PostgreSQL support multiple PostgreSQL versions from 13 to the latest version.
How do I enable extentions for PostgreSQL database?
Connect to your Vultr Managed Databases cluster using psql and follow the steps below to enable extensions.
- View the available extensions.
sql
SELECT * FROM pg_available_extensions;
- Enable a new extension.
sql
CREATE EXTENSION extension_name;
- Remove an extension.
sql
DROP EXTENSION extension_name;
Frequently Asked Questions (FAQs) About Vultr Managed Databases for PostgreSQL Frequently asked questions and answers about Vultr Managed Databases for PostgreSQL service features and functionality. These are the frequently asked questions for Vultr Managed Databases for PostgreSQL. Is the Vultr Managed Databases for PostgreSQL cluster backed up? Yes, Vultr Managed…
Frequently Asked Questions (FAQs) About Vultr Managed Databases for PostgreSQL Frequently asked questions and answers about Vultr Managed Databases for PostgreSQL service features and functionality. These are the frequently asked questions for Vultr Managed Databases for PostgreSQL. Is the Vultr Managed Databases for PostgreSQL cluster backed up? Yes, Vultr Managed…