pg_hba.config problems

pg_hba.config problems

Postby kintela » Wed 26 Feb 2014 23:16

Hi

I'm trying to connect to my postgreSQL database from Visual Studio 2013 but alway get the same error message: "There is not a line in pg_hba.config to "192.168.100.8", user postgres...

But in that file i have this line:
host all all 127.0.0.1/32 trust

Any idea???

Regards
kintela
 
Posts: 5
Joined: Wed 26 Feb 2014 23:09

Re: pg_hba.config problems

Postby Pinturiccio » Fri 28 Feb 2014 15:05

This means there is no record in pg_hba.conf that permits you to connect to the server from 192.168.100.8 computer. You cannot connect to this server with any tool, so the issue is not related to dotConnect for PostgreSQL, it is caused by the configuration of the PostgreSQL server. For more information, please refer to http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html

You need to contact your administrator and ask him to tweak the pg_hba.conf config file so that your computer address was added to the list of addresses allowed to connect to the server.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: pg_hba.config problems

Postby kintela » Fri 28 Feb 2014 16:46

yes that was the problem

Thanks
kintela
 
Posts: 5
Joined: Wed 26 Feb 2014 23:09


Return to dotConnect for PostgreSQL