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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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 ^^