Skip site navigation (1) Skip section navigation (2)

Re: Trouble with pg_hba.conf and Access.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Trouble with pg_hba.conf and Access.
Date: 2001-07-09 19:43:25
Message-ID: 13204.994707805@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-odbc
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

In response to

Responses

pgsql-novice by date

Next:From: Neal LindsayDate: 2001-07-09 20:07:51
Subject: Re: [NOVICE] Trouble with pg_hba.conf and Access.
Previous:From: Neal LindsayDate: 2001-07-09 19:14:21
Subject: Trouble with pg_hba.conf and Access.

pgsql-odbc by date

Next:From: Neal LindsayDate: 2001-07-09 20:07:51
Subject: Re: [NOVICE] Trouble with pg_hba.conf and Access.
Previous:From: Neal LindsayDate: 2001-07-09 19:29:31
Subject: Access97 problem with pg_hba.conf?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group