How to Destroy PostgreSQL Database Clusters

1. Install doctl, the official DigitalOcean CLI.
2. Create a personal access token and save it for use with doctl.
3. Use the token to grant doctl access to your DigitalOcean account.

   doctl auth init

4. Finally, run doctl databases delete. Basic usage looks like this, but you can read the usage docs for more details:

   doctl databases delete <database-cluster-id> [flags]

   The following example deletes the database cluster with the ID f81d4fae-7dec-11d0-a765-00a0c91e6bf6:

   doctl databases delete f81d4fae-7dec-11d0-a765-00a0c91e6bf6

1. Create a personal access token and save it for use with the API.
2. Send a DELETE request to https://api.digitalocean.com/v2/databases/{database_cluster_uuid}.

cURL

Using cURL:

curl -X DELETE \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
"https://api.digitalocean.com/v2/databases/9cc10173-e9ea-4176-9dbc-a4cee4c4ff30" 

Go

Using Godo, the official DigitalOcean API client for Go:

import (
    "context"
    "github.com/digitalocean/godo"
)

func main() {
    pat := "mytoken"

    client := godo.NewFromToken(pat)
    ctx := context.TODO()

    _, err := client.Databases.Delete(ctx, "9cc10173-e9ea-4176-9dbc-a4cee4c4ff30")
}

Python

Using PyDo, the official DigitalOcean API client for Python:

import os
from pydo import Client

client = Client(token=os.environ.get("DIGITALOCEAN_TOKEN"))

delete_resp = client.databases.destroy_cluster(database_cluster_uuid="a7abba8")