Error Postgres connection

One Star

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
One Star

Re: Error Postgres connection

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