Error Postgres connection

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now