Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Question on Postgresql Database Cluster connection Question Question
Duplicate Website Question Question

Question

no pg_hba.conf entry for host \"IP-ADDRESS", user \"username\", database \"database\", SSL off

Posted August 6, 2020 4.2k views
Node.jsDatabasesDigitalOcean Managed PostgreSQL Database

I am trying to access my managed postgreSQL database from my node.js app which is hosted in Google Cloud. I am getting the above error. I am using pg-promise in my node.js app. How to go about it? Please advise.

Add a comment
kathirva
By:
kathirva

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Question on Postgresql Database Cluster connection Question Question
Duplicate Website Question Question

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
2 answers
coreramiro August 7, 2020

You need to whitelist the IP you are making the request from in /etc/postgresql/9.5/main/pg_hba.conf (be 9.5 the version of you postgresql installation). An example:

host all all 1.2.3.4/32 md5

Where md5 is the trust method, 32 the network mask and 1.2.3.4 the request IP

Reply Report
pistle2020 September 17, 2020

Hello, I believe that you are getting a deny on the connection as the client is not in the pg-hba-conf file, there should be a way to authorize networks/ or a similar thing on from your database provider.

Reply Report

Related

Looking for something else?

Ask a new question Search for more help