Reference > PyDo > Library Reference > databases > list_connection_pools()

Was this page helpful?

Give Feedback

pydo.databases.list_connection_pools()

Generated on 25 November 2024 from pydo version v0.6.0

Description

To list all of the connection pools available to a PostgreSQL database cluster, send a GET request to /v2/databases/$DATABASE_ID/pools. The result will be a JSON object with a pools key. This will be set to an array of connection pool objects.

Parameters

Name	Type	Required	Description	Default Value
`database_cluster_uuid`	string	True	A unique identifier for a database cluster.

Request Sample

import os
from pydo import Client

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

get_resp = client.databases.list_connection_pools(database_cluster_uuid="a7aab9a")

Responses

See the API spec for this endpoint to view additional detail on responses, headers, parameters, and more.

200
401
404
429
500
default

A JSON object with a key of pools.

Click to expand an example response.

{
  "pools": [
    {
      "user": "doadmin",
      "name": "reporting-pool",
      "size": 10,
      "db": "defaultdb",
      "mode": "session",
      "connection": {
        "uri": "postgres://doadmin:wv78n3zpz42xezdk@backend-do-user-19081923-0.db.ondigitalocean.com:25061/foo?sslmode=require",
        "database": "foo",
        "host": "backend-do-user-19081923-0.db.ondigitalocean.com",
        "port": 25061,
        "user": "doadmin",
        "password": "wv78n3zpz42xezdk",
        "ssl": true
      }
    },
    {
      "user": "doadmin",
      "name": "backend-pool",
      "size": 10,
      "db": "defaultdb",
      "mode": "transaction",
      "connection": {
        "uri": "postgres://doadmin:wv78n3zpz42xezdk@backend-do-user-19081923-0.db.ondigitalocean.com:25061/backend-pool?sslmode=require",
        "database": "backend-pool",
        "host": "backend-do-user-19081923-0.db.ondigitalocean.com",
        "port": 25061,
        "user": "doadmin",
        "password": "wv78n3zpz42xezdk",
        "ssl": true
      }
    }
  ]
}

Unauthorized

Click to expand an example response.

{
  "id": "unauthorized",
  "message": "Unable to authenticate you."
}

The resource was not found.

Click to expand an example response.

{
  "id": "not_found",
  "message": "The resource you requested could not be found."
}

API Rate limit exceeded

Click to expand an example response.

{
  "id": "too_many_requests",
  "message": "API Rate limit exceeded."
}

Server error.

Click to expand an example response.

{
  "id": "server_error",
  "message": "Unexpected server-side error"
}

Unexpected error

Click to expand an example response.

{
  "id": "example_error",
  "message": "some error message"
}