To show information about an existing connection pool for a PostgreSQL database cluster, send a GET request to /v2/databases/$DATABASE_ID/pools/$POOL_NAME.
The response will be a JSON object with a pool key.
643 matches
60 actions
DigitalOcean
60 actions
- Create a New DomainPOSTv1.0.0
- Create a New Domain RecordPOSTv1.0.0
- Get Customer BalanceGETv1.0.0
- Get NamespaceGETv1.0.0
- Get TriggerGETv1.0.0
- Get User InformationGETv1.0.0
- List All ActionsGETv1.0.0
- List All Actions for a Floating IPGETv1.0.0
- List All Actions for an ImageGETv1.0.0
- List all app alertsGETv1.0.0
- List All CDN EndpointsGETv1.0.0
- List All CertificatesGETv1.0.0
- List All Database ClustersGETv1.0.0
- List all Database UsersGETv1.0.0
- List All DatabasesGETv1.0.0
- List All Domain RecordsGETv1.0.0
- List All DomainsGETv1.0.0
- List All Droplet NeighborsGETv1.0.0
- List All FirewallsGETv1.0.0
- List All Floating IPsGETv1.0.0
- List All Read-only ReplicasGETv1.0.0
- List App RegionsGETv1.0.0
- List App TiersGETv1.0.0
- List Associated Resources for a DropletGETv1.0.0
- List Backups for a Database ClusterGETv1.0.0
- List Billing HistoryGETv1.0.0
- List Connection Pools (PostgreSQL)GETv1.0.0
- List Database OptionsGETv1.0.0
- List Default Project ResourcesGETv1.0.0
- List Firewall Rules (Trusted Sources) for a Database ClusterGETv1.0.0
- List Instance SizesGETv1.0.0
- List NamespacesGETv1.0.0
- List Neighbors for a DropletGETv1.0.0
- List TriggersGETv1.0.0
- Retrieve a Droplet ActionGETv1.0.0
- Retrieve an App DeploymentGETv1.0.0
- Retrieve an App TierGETv1.0.0
- Retrieve an Existing ActionGETv1.0.0
- Retrieve an Existing ActionGETv1.0.0
- Retrieve an Existing AppGETv1.0.0
- Retrieve an Existing CDN EndpointGETv1.0.0
- Retrieve an Existing CertificateGETv1.0.0
- Retrieve an Existing DatabaseGETv1.0.0
- Retrieve an Existing Database ClusterGETv1.0.0
- Retrieve an Existing Database Cluster ConfigurationGETv1.0.0
- Retrieve an Existing Database UserGETv1.0.0
- Retrieve an Existing DomainGETv1.0.0
- Retrieve an Existing Domain RecordGETv1.0.0
- Retrieve an Existing DropletGETv1.0.0
- Retrieve an Existing FirewallGETv1.0.0
- Retrieve an Existing Floating IPGETv1.0.0
- Retrieve an Existing Floating IP ActionGETv1.0.0
- Retrieve an Existing Read-only ReplicaGETv1.0.0
- Retrieve an Instance SizeGETv1.0.0
- Retrieve App Daily Bandwidth MetricsGETv1.0.0
- Retrieve Existing Connection Pool (PostgreSQL)GETv1.0.0
- Retrieve the Eviction Policy for a Redis ClusterGETv1.0.0
- Retrieve the Public CertificateGETv1.0.0
- Retrieve the SQL Modes for a MySQL ClusterGETv1.0.0
- Retrieve the Status of an Online MigrationGETv1.0.0
Infrastructure/DigitalOcean
Retrieve Existing Connection Pool (PostgreSQL)
v1.0.0Input
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
{
"type": "object",
"properties": {
"database_cluster_uuid": {
"type": "string",
"format": "uuid"
},
"pool_name": {
"type": "string"
}
},
"required": [
"database_cluster_uuid",
"pool_name"
],
"additionalProperties": false
}Output
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
{
"type": "object",
"required": [
"pool"
],
"properties": {
"pool": {
"type": "object",
"required": [
"db",
"mode",
"name",
"size"
],
"properties": {
"connection": {
"type": "object"
},
"db": {
"type": "string",
"description": "The database for use with the connection pool."
},
"mode": {
"type": "string",
"description": "The PGBouncer transaction mode for the connection pool. The allowed values are session, transaction, and statement."
},
"name": {
"type": "string",
"description": "A unique name for the connection pool. Must be between 3 and 60 characters."
},
"private_connection": {
"type": "object"
},
"size": {
"type": "integer",
"format": "int32",
"description": "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."
},
"user": {
"type": "string",
"description": "The name of the user for use with the connection pool. When excluded, all sessions connect to the database as the inbound user."
}
}
}
}
}