doctl databases pool list
Generated on 9 Apr 2025
from doctl version
v1.124.0
Usage
doctl databases pool list <database-cluster-id> [flags]Aliases
lsDescription
Lists the existing connection pools for the specified database. The command returns the following details about each connection pool:
- The database user that the connection pool uses. When excluded, all connections to the database use the inbound user.
- The connection pool’s name
- The connection pool’s size
- The database within the cluster that the connection pool connects to
- The pool mode for the connection pool. Possible values:
session,transaction, orstatement - A connection string for the connection pool
Example
The following example lists the connection pools for a database cluster with the ID ca9f591d-f38h-5555-a0ef-1c02d1d1e35 and uses the --format flag to return only each pool’s name and connection string:
doctl databases pool list ca9f591d-f38h-5555-a0ef-1c02d1d1e35 --format Name,URIFlags
| Option | Description |
|---|---|
--format |
Columns for output in a comma-separated list. Possible values: User, Name, Size, Database, Mode, URI. |
--help, -h |
Help for this command |
--no-header |
Return raw data with no headers Default: false |
Related Commands
| Command | Description |
|---|---|
| doctl databases pool | Display commands for managing connection pools |
Global Flags
| Option | Description |
|---|---|
--access-token, -t |
API V2 access token |
--api-url, -u |
Override default API endpoint |
--config, -c |
Specify a custom config file Default: |
--context |
Specify a custom authentication context name |
--http-retry-max |
Set maximum number of retries for requests that fail with a 429 or 500-level error
Default: 5 |
--http-retry-wait-max |
Set the minimum number of seconds to wait before retrying a failed request
Default: 30 |
--http-retry-wait-min |
Set the maximum number of seconds to wait before retrying a failed request
Default: 1 |
--interactive |
Enable interactive behavior. Defaults to true if the terminal supports it (default false)
Default: false |
--output, -o |
Desired output format [text|json] Default: text |
--trace |
Show a log of network activity while performing a command Default: false |
--verbose, -v |
Enable verbose output Default: false |