For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

Usage

client.databases.update_connection_pool(
    database_cluster_uuid="9cc10173-e9ea-4176-9dbc-a4cee4c4ff30",
    pool_name="backend-pool",
    body={
        "mode": "transaction",
        "size": 10,
        "db": "defaultdb",
        ...,
    },
)

Description

To update a connection pool for a PostgreSQL database cluster, send a PUT request to /v2/databases/{database_cluster_uuid}/pools/{pool_name}.

Parameters

database_cluster_uuid string required

A unique identifier for a database cluster.

pool_name string required

The name used to identify the connection pool.

mode string required

Example: transaction

The PGBouncer transaction mode for the connection pool. The allowed values are session, transaction, and statement.

size integer required

Example: 10

The desired size of the PGBouncer connection pool. The maximum allowed size is determined by the size of the cluster's primary node. 25 backend server connections are allowed for every 1GB of RAM. Three are reserved for maintenance. For example, a primary node with 1 GB of RAM allows for a maximum of 22 backend server connections while one with 4 GB would allow for 97. Note that these are shared across all connection pools in a cluster.

db string required

Example: defaultdb

The database for use with the connection pool.

user string optional

Example: doadmin

The name of the user for use with the connection pool. When excluded, all sessions connect to the database as the inbound user.

Request Sample

import os
from pydo import Client

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

req = {
    "mode": "transaction",
    "size": 10,
    "db": "defaultdb",
    "user": "doadmin"
}

update_resp = client.databases.update_connection_pool(database_cluster_uuid="a7a8bas", pool_name="conn_pool", body=req)

More Information

See /v2/databases/{database_cluster_uuid}/pools/{pool_name} in the API reference for additional detail on responses, headers, parameters, and more.