Re: [NOVICE] Trouble with pg_hba.conf and Access.

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.