Page 1 of 1

pg_hba.config problems

Posted: Wed 26 Feb 2014 23:16
by kintela
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

Re: pg_hba.config problems

Posted: Fri 28 Feb 2014 15:05
by Pinturiccio
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/stat ... -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.

Re: pg_hba.config problems

Posted: Fri 28 Feb 2014 16:46
by kintela
yes that was the problem

Thanks