Deleting Vultr Managed Databases for PostgreSQL removes the instance from your account and stops further charges. Only perform this operation after backing up the database because the operation deletes all logical databases, tables, and objects associated with the managed database.
Follow this guide to delete Vultr Managed Databases for PostgreSQL using the Vultr Customer Portal, API, CLI, or Terraform.
List all the database instances by sending a GET
request to the List Managed Databases endpoint and note the database ID. For example, 43b4c774-5dff-4ac0-a01f-78a23c2205b5
.
$ curl "https://api.vultr.com/v2/databases" \
-X GET \
-H "Authorization: Bearer ${VULTR_API_KEY}"
Send a DELETE
request to the Delete Managed Database endpoint and specify the database ID to delete the instance.
$ curl "https://api.vultr.com/v2/databases/database_id" \
-X DELETE \
-H "Authorization: Bearer ${VULTR_API_KEY}"
Visit the Delete Managed Database endpoint to view additional attributes to add to your request.
List all database instances and note the database ID. For instance, d6ac2a3c-92ea-43ef-8185-71a23e58ad8c
.
$ vultr-cli database list --summarize
Delete the database by specifying a database ID.
$ vultr-cli database delete database_id
Run vultr-cli database delete --help
to view all options.
Open your Terraform configuration and locate the Managed Database for PostgreSQL resource.
Remove the resource block or destroy it with Terraform.
resource "vultr_database" "pg" {
label = "pg-cluster-1"
database_engine = "pg"
database_engine_version = "16"
region = "ewr"
plan = "vultr-dbaas-startup-cc-1-55-2"
}
# To delete, either remove this block from configuration
# or run: terraform destroy -target vultr_database.pg
Apply and observe the following output:
Apply complete! Resources: 0 added, 0 changed, 1 destroyed.
No comments yet.