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@lfix.co.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