ok, done with thesse xxx, yyy I'm on a private network so here is the real content of hba.conf host all all 127.0.0.1/32 md5 host all dbaInspq 10.2.192.247 255.255.255.0 md5 host all dbaInspq 10.2.195.37 255.255.254.0 md5
10.2.192.247 is the server running postgres/postgis 10.2.195.37 is my computer
Also, please find attached the screenshot of the odbc config of the client.
In this ODBC config of the client, if I change the User Name to test instead of dbaInspq, I get this error FATAL: no pg_hba.conf entry for host "10.2.195.53", user "test", database "geo", SSL off
10.2.195.53 is the ipaddress of the client, and it is not in pg_hba.conf
The client has winXP and he's using the ODBC driver to access postgres with SAS. Another information, the database geo is a postgis database.
> the first line is host all all 127.0.0.1/32 md5 > > So the full hba.conf is > > host all all 127.0.0.1/32 md5 > host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5 > host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5 > > > > xxx.xxx.xxx.xxx is the ip address of the server running postgres > > > >
> > > > Thanks for your help, > > steve > >
In addition to what Richard said, what is the network that the client is running on?