API

Update a PostgreSQL connection pool

put
https://api.linode.com//databases/postgresql/instances//connection-pools/

Update PGBouncer connection pool settings for a PostgreSQL Managed Database, using our partner Aiven's specification.

🚧

This operation can cause sudden closure of an in-use connection pool.

Permissions and scopes

To call this operation, you need the following:

  • Identity and access permissions. Your user needs these roles assigned. Learn more.

    • Roles: database_admin

  • OAuth scopes. Your user needs these scopes assigned. Learn more.

    • Scopes: databases:read_write

CLI

linode-cli databases postgresql-conn-pool-update 123 \
  --database PostgreSQL-DB-video-streaming-data-legacy
  --mode session
  --label Connection-Pool-01 \
  --size 10 \
  --username john-doe

Learn more

Path Params
string
enum
required

Enum Call either the v4 URL, or v4beta for operations still in Beta.

Allowed:
integer
required

The unique identifier for a PostgreSQL Managed Database. Run the List PostgreSQL Managed Databases operation and store the id for the desired one.

string
required

The label set for a specific connection pool in a PostgreSQL Managed Database. Run the List PostgreSQL connection pools operation and store the label for the desired one.

Body Params

The PostgreSQL Managed Database connection pool request object.

string
Defaults to defaultdb

The name of the PostgreSQL Managed Database where the connection pool is assigned. Run the List PostgreSQL Managed Databases operation and store the label for the target database.

string
required

The name of the connection pool. These points apply:

  • A label needs to be unique in a database instance.

  • A label can contain alphanumeric characters, underscores, or hyphens, and it can't start with hyphen.

  • A label has a maximum length of 63 characters.

string
enum
required
Defaults to transaction

Set the connection pooling mode based on the specification set by our partner, Aiven. Select from transaction, session, or statement.

Allowed:
integer
required
Defaults to 10

The number of connections in the pool. This can't exceed the number of available connections for your service plan.

string | null
required
Defaults to null

The username of the client making the connection. The default of null reuses the inbound user.

Responses

Updated 3 months ago

Language
Credentials
LoadingLoading…
Response
Choose an example:
application/json

Updated 3 months ago