Error Postgres connection

_AnonymousUser — Sat, 16 Nov 2024 14:09:11 GMT

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

Re: Error Postgres connection

_AnonymousUser — Thu, 20 Nov 2008 16:46:54 GMT

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 ^^

topic Error Postgres connection in Talend Studio

Error Postgres connection

Re: Error Postgres connection