Add ability to change connection pool size for connection pools

TL;DR

Change the conneciton pool size via doctl Describe the solution you'd like doctl databases pool update database123id poolname123id --size 2 In the WebUI you can change the pool size, so i dont understand why this is not working via doctl itself?

Steps

1. How to add ability to change connection pool size for connection pools.
2. Issue digitalocean/doctl#1553 (closed, 5 comments): What is the problem this feature would solve? Please describe. Change the conneciton pool size via doctl Describe the solution you'd like doctl databases pool update database123id poolname123id --size 2 In the WebUI you can change the pool size, so i dont understand why this is not working via doctl itself?
3. When updating a managed database connection pool, leaving out --user resets the pool to the connecting user's privileges. Pass --user explicitly with the new size: doctl databases pool update [database-uuid] [pool-name] --size [size] --user [username].

When to use

You are seeing this: Issue digitalocean/doctl#1553 (closed, 5 comments): What is the problem this feature would solve? Use this skill when you run into "Add ability to change connection pool size for connection pools".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• https://github.com/digitalocean/doctl/issues/1553

In gh:digitalocean/doctl#1553, the reporter ran into: Issue digitalocean/doctl#1553 (closed, 5 comments): What is the problem this feature would solve? Please describe. Change the conneciton pool size via doctl Describe the solution you'd like doctl databases pool update database123id poolname123id --size 2 In the WebUI you can change the pool size, so i dont understand why this is not working via doctl itself? The verified answer was: When updating a managed database connection pool, leaving out --user resets the pool to the connecting user's privileges. Pass --user explicitly with the new size: doctl databases pool update [database-uuid] [pool-name] --size [size] --user [username]. Source issue: https://github.com/digitalocean/doctl/issues/1553