Vultr Managed Databases for PostgreSQL is a highly available and scalable relational database solution that supports modern features like vectors, JSON, and geometric data types. PostgreSQL integrates with modern programming languages like PHP, Python, and Go, making it an ideal choice for developing web applications and application programming interfaces (APIs). PostgreSQL databases are available in major global Vultr locations and you can choose from CPU-optimized, memory-optimized, and general-purpose server types.
Follow this guide to provision Vultr Managed Databases for PostgreSQL using the Vultr Customer Portal, API, or CLI.
Send a GET
request to the List Regions endpoint and note your target Vultr region ID.
$ curl "https://api.vultr.com/v2/regions" \
-X GET \
-H "Authorization: Bearer ${VULTR_API_KEY}"
Send a GET
request to the List Managed Database Plans endpoint to view all available database engines and plans in your target Vultr region.
$ curl "https://api.vultr.com/v2/databases/plans?region=<region-id>" \
-X GET \
-H "Authorization: Bearer ${VULTR_API_KEY}"
Send a POST
request to the Create Database endpoint to provision a Vultr Managed Databases for PostgreSQL cluster with your database engine, version, plan and target Vultr region.
$ curl "https://api.vultr.com/v2/databases" \
-X POST \
-H "Authorization: Bearer ${VULTR_API_KEY}" \
-H "Content-Type: application/json" \
--data '{
"database_engine" : "pg",
"database_engine_version" : "<version>",
"plan" : "<server-plan>",
"region" : "<region-id>",
"label" : "<label>"
}'
Visit the Create Database endpoint to view additional attributes to apply to your request Vultr Managed Databases for PostgreSQL provisioning request.
Send a GET
request to the List Managed Databases endpoint to list all Vultr Managed Databases in your account.
$ curl "https://api.vultr.com/v2/databases" \
-X GET \
-H "Authorization: Bearer ${VULTR_API_KEY}" \
-H "Content-Type: application/json"
List all Vultr regions and note your target region ID.
$ vultr-cli regions list
List all available database plans and note your target plan.
$ vultr-cli database plan list
Provision a Vultr Managed Databases for PostgreSQL cluster with your target plan and region.
$ vultr-cli database create \
--database-engine pg \
--database-engine-version <version> \
--plan <server-plan> \
--region <region-id> \
--label <label>
Run vultr-cli database create --help
to view all available options to apply to your Vultr Managed Databases for PostgreSQL provisioning request.
List all Vultr Managed Databases in your account.
$ vultr-cli database list