How to connect to Postgres managed database accepting TCP/IP connections on port 5432?

Posted on June 8, 2020

DigitalOcean Managed PostgreSQL Database

I’ve have been trying setup a Scalelite load balancer. The load balancer connects to an external Postgres database. I have setup the managed database, made incoming traffic open to all. The server and the managed database are in the same VPC, N1. No matter what I do I get the error below when I run:

connection timed out is the server running running on host "0.0.0.0.0" and accepting 	TCP/IP connections on port 5432?

Help will be really appreciated.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby

June 9, 2020

Hi there @elvisron,

The Managed Postgresql databases run on non-standard ports, you should not use the 5432 port but instead use the port which is specified in your Managed database settings.

I believe that the port which you should use is 25060.

Hope that this helps! Regards, Bobby