Digital Ocean
Managed Databases
Connection
Copy the Connection string…

Use the Connection string in psql
as follows:
psql "postgresql://doadmin:k01@kb-user-17.db.ondigitalocean.com:25060/defaultdb?sslmode=require"
Note
You can Download the CA certificate, but we didn’t need to use it…
Tip
Make sure you click on the Public network and show-password
(in the Connection string).
I forgot both of these things…!
Security
Security is managed by adding a Trusted source. A Trusted source is the IP address of your laptop (or workstation):

Project
One of our servers was in the wrong project. We could not see a way to remove it, so created another project added it to the new project.
Note
The Digital Ocean API does not include the project name in the
droplets
API call, so we use the tags
to identify the
owner of the droplet.