Re: odbc access and pg_hba.conf

On 19/11/2009 18:25, Steve.Toutant@inspq.qc.ca wrote:

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

No, not at all - ODBC is client-side, while the pg_hba.conf file is
server-side.

> 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

Are you sure that (a) the client machine's IP address doesn't match
these rules, and (b) there isn't another rule elsewhere in the file that
grants it access? Check also that the user as which you're connecting is
what you expect.

I know these are obvious things, but without further details it's hard
to tell what the problem is.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie