Digital Ocean

Managed Databases

Connection

Copy the Connection string…

_images/digital-ocean-db-connection-string.png

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):

_images/digital-ocean-db-trusted-sources.png

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.