---
title: "Update Connection Pools (PostgreSQL)"
method: PUT
path: "/v2/databases/{database_cluster_uuid}/pools/{pool_name}"
tags: ["DigitalOcean-public.v2-new_Databases"]
---

# Update Connection Pools (PostgreSQL)

`PUT /v2/databases/{database_cluster_uuid}/pools/{pool_name}`

To update a connection pool for a PostgreSQL database cluster, send a PUT request to  `/v2/databases/$DATABASE_ID/pools/$POOL_NAME`.

## Path parameters

- `database_cluster_uuid` string, uuid, required
- `pool_name` string, required

## Request body

- ConnectionPoolUpdate
  - `mode` string, required — The PGBouncer transaction mode for the connection pool. The allowed values are session, transaction, and statement.
  - `size` integer, required — 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 — The database for use with the connection pool.
  - `user` string — The name of the user for use with the connection pool. When excluded, all sessions connect to the database as the inbound user.

## Response `204`

The action was successful and the response body is empty.

## Other responses

- `401` — Authentication failed due to invalid credentials.
- `404` — The resource was not found.
- `429` — The API rate limit has been exceeded.
- `500` — There was a server error.
- `default` — There was an unexpected error.

## Changes

- **2025-10-16** `cb3bf9b21459` — 2 info
  - api tag `DigitalOcean-public.v2-new_Databases` added
  - api tag `Databases` removed
- **2025-07-18** `f8e8c290636c` — 1 info
  - endpoint added
- **2025-07-17** `5fc9af728e82` — 1 breaking
  - api path removed without deprecation
- **2025-07-17** `f8e8c290636c` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/digitalocean/apis/digitalocean-api/changes/v2/databases/:database_cluster_uuid/pools/:pool_name/put.md)

---

[API](https://skmtc.dev/digitalocean/apis/digitalocean-api.md) · [All operations](https://skmtc.dev/digitalocean/apis/digitalocean-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/digitalocean/digitalocean-api/revisions/cb3bf9b21459/schema)