0

Update Connection Pools (PostgreSQL)

by
Published Dec 20, 2024

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

Script digitalocean Verified

The script

Submitted by hugo697 Bun
Verified 536 days ago
1
//native
2
type Digitalocean = {
3
  token: string;
4
};
5
/**
6
 * Update Connection Pools (PostgreSQL)
7
 * To update a connection pool for a PostgreSQL database cluster, send a PUT request to  `/v2/databases/$DATABASE_ID/pools/$POOL_NAME`.
8
 */
9
export async function main(
10
  auth: Digitalocean,
11
  database_cluster_uuid: string,
12
  pool_name: string,
13
  body: { mode: string; size: number; db: string; user?: string },
14
) {
15
  const url = new URL(
16
    `https://api.digitalocean.com/v2/databases/${database_cluster_uuid}/pools/${pool_name}`,
17
  );
18

19
  const response = await fetch(url, {
20
    method: "PUT",
21
    headers: {
22
      "Content-Type": "application/json",
23
      Authorization: "Bearer " + auth.token,
24
    },
25
    body: JSON.stringify(body),
26
  });
27
  if (!response.ok) {
28
    const text = await response.text();
29
    throw new Error(`${response.status} ${text}`);
30
  }
31
  return await response.json();
32
}
33