Re: odbc access and pg_hba.conf

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

Adrian Klaver <aklaver(at)comcast(dot)net>@postgresql.org
Envoyé par : pgsql-odbc-owner(at)postgresql(dot)org
19/11/2009 01:48 PM

A
Steve Toutant <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca>
cc
pgsql-odbc(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:

> Hi,
> I installed the odbc driver (psqlodbc v08_03_0400) on a computer. I
> configured the odbc connection and the connection test was succesfull.
> That surprised me since this computer is not yet in my pg_hba.conf
>
> Is the odbc driver supposed to "bypass" the pg_hba.conf?
>
> I don't know much about the admin side of postgres. I don't know which
> information could be useful to you.
> Please ask for any information that would help
>
> Here is the content of my pg_hba.conf
> host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5
> host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5

Is this your entire pg_hba.conf? Remember the first match wins, so if
there is a more permissive line above these it will take precendence.

>
>
>
>
> Thanks for your help,
> steve

Adrian Klaver
aklaver(at)comcast(dot)net