Re: [NOVICE] Trouble with pg_hba.conf and Access. - Mailing list pgsql-odbc

From Neal Lindsay
Subject Re: [NOVICE] Trouble with pg_hba.conf and Access.
Date
Msg-id 5.1.0.14.0.20010709155701.00a0b3d0@mail.peaofohio.com
Whole thread Raw
List pgsql-odbc
At 03:43 PM 7/9/01 -0400, you wrote:
>Neal Lindsay <neal.lindsay@peaofohio.com> writes:
> > I am currently getting the following error when trying to connect to my
> > PostgreSQL server on my LAN via Microsoft Access and ODBC.
>
> > No pg_hba.conf entry for host 192.168.0.100, user neal, database mydb
> (#210)
>
> > The confusing thing is that I have set up my pg_hba.conf file in my data
> > directory.  The actual text follows:
>
> > local all     trust
> > host  all     192.168.0.0     255.255.255.0   trust
> > host  all     127.0.0.1       255.255.255.255 trust
>
>It sure looks like the second line should match that connection request.
>I'd suggest double-checking for silly errors --- like, is the ODBC
>driver really connecting to the machine you think it is?  Is the $PGDATA
>directory you are putting the conf file into actually the same one the
>postmaster is running in?
>
>Also, look in the postmaster's stderr log to see if any extra info is
>recorded there.  (If you are starting the postmaster in a way that
>discards stderr, like using -S or redirecting stderr to /dev/null,
>now's a good time to stop.)
>
>                         regards, tom lane


I know that I am connecting to the right machine - it's the only one
running postgresql on this network.  I double-checked the $PGDATA directory
- that's OK.  The log file just has the same error as the one that pops up
in a box on my Windows machine.  I'm really confused by this whole
problem.  I even tried connecting from an other computer here in the office
- same problem.



pgsql-odbc by date:

Previous
From: Neal Lindsay
Date:
Subject: Access97 problem with pg_hba.conf?
Next
From: Hiroshi Inoue
Date:
Subject: Re: [INTERFACES] Getting info on "Max LongVarChar" under ODBC