Related

How much database space remains available? Question Question
Is it possible to set trusted sources for managed databases from the API or doctl? Question Question

Question

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

Posted June 8, 2020 1.6k views
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.

Add a comment
elvisron
By:
elvisron
Add a comment

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.

×
1 answer
bobbyiliev 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

Reply Report
  • elvisron June 9, 2020

    Hi bobbyiliev,

    Thanks for the feedback.

    The postgres connection does not require any port. It looks like this"

    DATABASE_URL: postgresql://username:password@connection_url

    Thank you.

    Regards,

    Elvis

    Reply Report
    • bobbyiliev June 9, 2020

      Hi there @elvisron,

      Have you tried appending the port to the database hostname:

      DATABASE_URL: postgresql://username:password@connection_url:port_here

      Also if you have a firewall on your Droplet, make sure that the Managed Database port is allowed for outgoing TCP connections.

      Let me know how it goes!
      Regards,
      Bobby

      Reply Report
      • elvisron June 10, 2020

        Hi Bobby,

        I just tried adding the port and running again, but it doesn’t work. It does not recognize it as a correct path.

        I have no firewall running. Thank you

        Regards,

        Elvis

        Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help