Jump to content


Photo

[Solved] Remote access for postgres please


  • Please log in to reply
2 replies to this topic

#1 brettelliot

brettelliot

    Newbie

  • Members
  • 2 posts

Posted 22 March 2020 - 11:56 PM

Hi,

 

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

Krydos

    Rank X Member

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

Posted 23 March 2020 - 01:09 AM

Remote access enabled.



#3 brettelliot

brettelliot

    Newbie

  • 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