doctl databases pool get

Go to Navigation

Usage

doctl databases pool get <database-id> <pool-name> [flags]

Aliases

g

Description

This command retrieves the following information about the specified connection pool for the specified database cluster:

  • The username of the database user account that the connection pool uses
  • The name of the connection pool
  • The size of the connection pool, i.e. the number of connections that will be allocated
  • The database within the cluster for which the connection pool is used
  • The pool mode for the connection pool, which can be ‘session’, ‘transaction’, or ‘statement’
  • A connection string for the connection pool

You can get a list of existing connection pools by calling:

doctl databases pool list

You can get a list of existing database clusters and their IDs by calling:

doctl databases list

Flags

OptionDescription
--formatColumns for output in a comma-separated list. Possible values: User, Name, Size, Database, Mode, URI
--help, -hHelp for this command
--no-headerReturn raw data with no headers
Default: false
CommandDescription
doctl databases poolDisplay commands for managing connection pools

Global Flags

OptionDescription
--access-token, -tAPI V2 access token
--api-url, -uOverride default API endpoint
--config, -cSpecify a custom config file
Default:
  • macOS: ${HOME}/Library/Application Support/doctl/config.yaml
  • Linux: ${XDG_CONFIG_HOME}/doctl/config.yaml
  • Windows: %APPDATA%\doctl\config.yaml
--contextSpecify a custom authentication context name
--output, -oDesired output format [text|json]
Default: text
--traceShow a log of network activity while performing a command
Default: false
--verbose, -vEnable verbose output
Default: false