Re: odbc access and pg_hba.conf
| От | Steve.Toutant@inspq.qc.ca |
|---|---|
| Тема | Re: odbc access and pg_hba.conf |
| Дата | |
| Msg-id | OF3C873F9F.379019B0-ON85257673.0069A7F6-85257673.006ACCC8@ssss.gouv.qc.ca обсуждение исходный текст |
| Ответ на | Re: odbc access and pg_hba.conf (Adrian Klaver <aklaver@comcast.net>) |
| Ответы |
Re: odbc access and pg_hba.conf
|
| Список | pgsql-odbc |
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@comcast.net> 19/11/2009 02:00 PM |
|
----- "Steve Toutant" <Steve.Toutant@inspq.qc.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@comcast.net
Вложения
В списке pgsql-odbc по дате отправления: