Cannot remote connect to postgresql

Posted July 16, 2020 3.6k views
PostgreSQLDatabasesDigitalOcean Managed PostgreSQL Database

I’m having problems to remote connect to PostgreSQL.
I’m getting this error

I’m using right port, host, username, password and allowed my ip in TRUSTED SOURCES.

A week ago i tried in my old windows laptop and works fine, using DBeaver.

Now I’m on a macbook pro, tried using DBeaver, and psql but I couldn’t connect. I have firewall off.

I do not know what it could be.

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.

Submit an Answer
1 answer

Hello, @PalumboWeb

Could you please confirm if you can still access the database using DBeaver from your Windows machine? The thing is it’s good to know whether the issue with the client on your MAC or with the database in general.

Alternatively you can try to access the database using other clients from your Macbook like pgadmin and psql just to test if everything is okay:

Hope that helps!


  • Hi alex!

    I tried again in my mac, I update DBeaver before try and now it’s working!

    Yesterday, I tried connect with psql and give me the error too.

    I don’t know what could be but it’s working!

    • Hey, @PalumboWeb

      I’m glad this is now working! You can always check the logs for some more detailed information as this might help you understand what went wrong. Hopefully you wont need to use it!