---
title: "Update a connection pool"
method: PUT
path: "/project/{project}/service/{service_name}/connection_pool/{pool_name}"
tags: ["Service:_PostgreSQL"]
---

# Update a connection pool

`PUT /project/{project}/service/{service_name}/connection_pool/{pool_name}`

## Path parameters

- `project` string, required
- `service_name` string, required
- `pool_name` string, required

## Request body

- ServicePGBouncerUpdateRequestBody — ServicePGBouncerUpdateRequestBody
  - `database` string — Service database name
  - `pool_mode` 'session' | 'transaction' | 'statement' — PGBouncer pool mode
  - `pool_size` integer — Size of PGBouncer's PostgreSQL side connection pool
  - `username` string — Service username

## Response `200`

Response

- ServicePGBouncerUpdateResponse — ServicePGBouncerUpdateResponse
  - `errors` object[] — List of errors occurred during request processing
    - `message` string, required — Printable error message
    - `more_info` string — URL to the documentation of the error
    - `status` integer, required — HTTP error status code
  - `message` string — Printable result of the request

---

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