Re: jdbc pg_hba.conf error

On Wed, 2007-05-30 at 18:35 +0200, Martijn van Oosterhout wrote:
> On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote:
> > Oliver,
> >
> > When I do a :
> > psql -p 5000 testing123
> > I can make a connection. However, when I do a
> >
> > psql -U brakesh -h 127.0.0.1 -d testing123
> >
> > I get the followign error:
> >
> > psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "brakesh",
> > database "testing123", SSL off
>
> Ofcourse, the first connection is a local connection, which you
> obviously have configured. The latter connects to localhost, which you
> havn't configured.

His original message (which I snipped) said he had:

# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
host testing123 brakesh 127.0.0.1 255.255.255.255 trust

So it seems to me he did have it configured.

In fact the first host line should be used and the second one for user
brakesh is redundant, since it comes later in the file. The only thing
I can see is that it might be related to SSL.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html