Digital Ocean

Managed Databases


Copy the Connection string


Use the Connection string in psql as follows:

psql "postgresql://"


You can Download the CA certificate, but we didn’t need to use it…


Make sure you click on the Public network and show-password (in the Connection string). I forgot both of these things…!


Security is managed by adding a Trusted source. A Trusted source is the IP address of your laptop (or workstation):



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.


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.