How to Resize PostgreSQL Database Clusters

To resize a Database Cluster via the command-line, follow these steps:

1. Install doctl, the DigitalOcean command-line tool.

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, resize a Database Cluster with doctl databases resize. The basic usage looks like this, but you'll want to read the usage docs for more details:

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

   The following example resizes a PostgreSQL or MySQL database to have two nodes, 16 vCPUs, 64 GB of memory, and 2048 GiB of storage space

                      doctl databases resize ca9f591d-9999-5555-a0ef-1c02d1d1e352 --num-nodes 2 --size db-s-16vcpu-64gb --storage-size-mib 2048000
                   

To resize a Database Cluster using the DigitalOcean API, follow these steps:

1. Create a personal access token, and save it for use with the API.

2. Send a PUT request to https://api.digitalocean.com/v2/databases/{database_cluster_uuid}/resize

   cURL

   To resize a Database Cluster with cURL, call:

   
                   curl -X PUT \
   -H "Content-Type: application/json" \
   -H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
   -d '{"size":"db-s-4vcpu-8gb", "num_nodes":3, "storage_size_mib":163840}' \
   "https://api.digitalocean.com/v2/databases/9cc10173-e9ea-4176-9dbc-a4cee4c4ff30/resize" 

   Go

   Go developers can use Godo, the official DigitalOcean V2 API client for Go. To resize a Database Cluster with Godo, use the following code:

   
                   import (
       "context"
       "github.com/digitalocean/godo"
   )
   
   func main() {
       pat := "mytoken"
   
       client := godo.NewFromToken(pat)
       ctx := context.TODO()
   
       resizeRequest := &godo.DatabaseResizeRequest{
           SizeSlug: "db-s-4vcpu-8gb",
           NumNodes: 3,
           StorageSizeMib: 163840,
       }
   }

   Python

   
                   import os
   from pydo import Client
   
   client = Client(token=os.environ.get("DIGITALOCEAN_TOKEN"))
   
   req = {
     "size": "db-s-4vcpu-8gb",
     "num_nodes": 3,
     "storage_size_mib": 163840
   }
   
   update_resp = client.databases.update_cluster_size(database_cluster_uuid="a7a8bas", body=req)