Jump to content


[Solved] Remote access for postgres please

  • Please log in to reply
2 replies to this topic

#1 brettelliot



  • Members
  • 2 posts

Posted 22 March 2020 - 11:56 PM



Im writing a flask app that connects to postgres. My script errors with a 500 and after reading the forums I'm wondering if it's because i need to request remote access. (But i don't know why my script which is running locally would need remote access).


Here's the error:


psycopg2.OperationalError: FATAL: no pg_hba.conf entry for host "::1", user "brettell_user", database "brettell_test", SSL off


Even if remote access is not the cause of my error, I'd like to enable it from any IP because I will want to query it using datagrip anyway. Here are the details:


Host: johnny.heliohost.org

Database: brettell_test

User: brettell_user


If remote access isn't the problem, perhaps you can take a quick look and let me know what's wrong.


Thanks everyone!





#2 Krydos


    Rank X Member

  • Root Admin
  • 19,663 posts
  • Gender:Male

Posted 23 March 2020 - 01:09 AM

Remote access enabled.

#3 brettelliot



  • Members
  • 2 posts

Posted 24 March 2020 - 11:53 AM

Thank you! It's working now.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users