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