Re: Trouble with pg_hba.conf and Access.

Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)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