Re: odbc access and pg_hba.conf

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.

thanks for helping me!
Steve

Adrian Klaver <aklaver(at)comcast(dot)net>
19/11/2009 02:00 PM

A
Steve Toutant <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca>
cc
pgsql-odbc(at)postgresql(dot)org, pgsql-odbc-owner(at)postgresql(dot)org
Objet
Re: [ODBC] odbc access and pg_hba.conf

----- "Steve Toutant" <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca> wrote:

> 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?

Adrian Klaver
aklaver(at)comcast(dot)net