Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Error Postgres connection

Hi,

We installed a PostgreSQL server 8.2.6 on our OS Windows Server 2003 and TOS ETL 3.0.0. And we tried to connect to our database. But we've the following error:
Connection failure. You must change the Database Settings.
FATAL: no pg_hba.conf entry for host "10.51.250.222", user "postgres", database "ENTREPOT", SSL off
We have the following hba.conf :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
#host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5
We have the following postgresql.conf :
listen_adresses = '*'
ssl= off
Any body have an idea of this problem ? Please help us.

Thanks Julien
Labels (2)
1 Reply
_AnonymousUser
Specialist III
Specialist III
Author

Hi,

We've found a solution with adding in the hba.conf the following line:
host all all myadressIP myadressIP trust

Finally, It was easy ^^