Re: odbc access and pg_hba.conf

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: odbc access and pg_hba.conf
Date: 2009-11-19 18:50:12
Message-ID: 4B059364.7040806@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 19/11/2009 18:25, Steve(dot)Toutant(at)inspq(dot)qc(dot)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(at)iol(dot)ie

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Steve.Toutant 2009-11-19 18:51:54 Re: odbc access and pg_hba.conf
Previous Message Adrian Klaver 2009-11-19 18:48:30 Re: odbc access and pg_hba.conf