doctl Verified current stable Not installed? Cloud Infrastructure

Doctl / Delete Connection Pool For Database

Delete Connection Pool For Database

Delete a connection pool from the specified database.

$
Terminal
doctl d p rm <database_id> <pool_name>

When To Use

When decommissioning unused or underperforming connection pools for optimization.

Pro Tip

Drop connected clients gracefully before deletion to prevent disruptions in traffic.

Warning

Destructive operation. Confirm the target path and keep a backup before executing.

Command Builder

Tune the command before you copy it

Back to syntax
$
Generated Command
doctl d p rm <database_id> <pool_name>

Anatomy of Output

Understanding the result

Deleting pool: old-connection-pool from Database ID: 678901 Deletion Status

Indicates the pool deletion process.

Pool Name: old-connection-pool Deleted Pool Name

Confirms the specific pool that was deleted.

Confirmation: Success Operation Result

Confirms successful completion of the deletion.

Power User Variants

Optimized versions

doctl databases pool delete 678901 old-connection-pool --force

Force deletion without confirmation.

doctl databases pool delete 678901 old-connection-pool --skip-checks

Skip pre-deletion checks for rapid deletion.

Troubleshooting

Common pitfalls

Error: Pool not found.

Solution: Verify the pool name; ensure it corresponds to an existing pool.

Error: Database ID required to delete a pool.

Solution: Provide a valid database ID for deletion.

Error: Deletion failed - network issue.

Solution: Check your network and retry the deletion.

Command Breakdown

What each part is doing

doctl
Base Command
The executable that performs this operation. Here it runs Doctl before the shell applies any redirect operators.
d
d|databases
The value supplied for d|databases.
p
p|pool
The value supplied for p|pool.
rm
rm|delete
The value supplied for rm|delete.
<database_id>
database id
The value supplied for database id.
<pool_name>
pool name
The value supplied for pool name.

Alternative Approaches

Comparable commands in other tools

Alternative cloud infrastructure tools for the same job.