pg_hba.config problems

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
kintela
Posts: 5
Joined: Wed 26 Feb 2014 23:09

pg_hba.config problems

Post by 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

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: pg_hba.config problems

Post by 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/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.

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

Re: pg_hba.config problems

Post by kintela » Fri 28 Feb 2014 16:46

yes that was the problem

Thanks

Post Reply