Jump to content


Photo

Acces to postgresql Database


  • Please log in to reply
1 reply to this topic

#1 aut0wash

aut0wash

    Newbie

  • Members
  • 2 posts

Posted 01 September 2019 - 12:25 PM

Hey !
First time I use a postgresql database, I'm trying to connect to the database with a python script I running on my computer.
I followed this good tutorial to connect to database ; http://www.postgresq...python/connect/
So my database.ini file looks like this :

[postgresql]
host=65.19.141.xx
database=databasename
user=aut0wash_user1
password=mypassword

The host adress correpond to the Johnny server, and others informations to my exemple setup.

While running the script I got an error : "FATAL:  no pg_hba.conf entry for host "xx.xxx.xxx.xx", user "aut0wash_user", database "aut0wash_travian", SSL off"
xx.xxx.xxx.xx is my IP, not the host one.
Do I need to ask for a remote access ?
I tried to use Mysql and it's worked good (I used Remote Mysql) but I wanted to try Postgre this time !

Thx for answer, if I missed some informations tell me ! :)


Edited by aut0wash, 01 September 2019 - 12:26 PM.


#2 flazepe

flazepe

    Rank VIII Member

  • Moderators
  • 718 posts
  • Gender:Male

Posted 01 September 2019 - 12:30 PM

Yes. You need to request for remote access. Escalating...

Moved to Customer Service.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users