Re: jdbc pg_hba.conf error

Did you grant access to your user?


On Wed, 30 May 2007, Oliver Elphick wrote:

> 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.
>
>
>

--
Louis Gonzales
louis.gonzales@linuxlouis.net
http://www.linuxlouis.net