Re: jdbc pg_hba.conf error

As super-user (postgres) you have to create the user in Postgres, then
Grant access. In other words, if the pg_hba.conf file specifies a user
who does not exist, "user brakesh does not exist" will cause a failure to
connect as well.

Every connection to a database, has to have a user associated with the
session.

So the fact that he has connected to at least one database, means he's
gotten far enough to connect and create the proper ID/Authentication.

Actually, I wonder if 'after' he's changed the pg_hba.conf file if he's
been restarting the postgres process? Which is 'session' associated.

Everytime you change the pg_hba.conf file, you have to restart postgres,
don't you?

On Wed, 30 May 2007, Oliver Elphick wrote:

> On Wed, 2007-05-30 at 13:00 -0400, gonzales(at)linuxlouis(dot)net wrote:
>> Did you grant access to your user?
>
> If you mean grant access by an SQL GRANT, he hasn't got far enough to
> check that. The error specifically says "no pg_hba.conf entry". As far
> as I can see, his pg_hba.conf is OK.
>
>>
>> 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(dot)gonzales(at)linuxlouis(dot)net
http://www.linuxlouis.net