| From: | "Bhavana(dot)Rakesh" <Bhavana(dot)Rakesh(at)noaa(dot)gov> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, pgsql_general <pgsql-general(at)postgresql(dot)org>, jdbc <pgsql-odbc-owner(at)postgresql(dot)org> |
| Subject: | Re: jdbc pg_hba.conf error |
| Date: | 2007-05-30 16:30:38 |
| Message-ID: | 465DA6AE.7030904@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
Oliver Elphick wrote:
> On Wed, 2007-05-30 at 12:11 -0400, Bhavana.Rakesh wrote:
>
>> I used the example in the following URL
>>
>> http://www.postgresql.org/docs/7.3/static/client-authentication.html
>>
>
> That does have local rather than host, of course.
>
> Are you using PostgreSQL 7,3 as well?
>
>
>> Thanks for the catch on "host" instead of "local". I made that
>> change, and reloaded pgsql.. But I still get the same error. I can
>> connect to the database using psql client, but my java connection
>> seems to be failing.
>>
>
> Were you using the exact same parameters for psql?
>
> psql -U brakesh -h 127.0.0.1 -d testing123
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-05-30 16:35:20 | Re: jdbc pg_hba.conf error |
| Previous Message | Bhavana.Rakesh | 2007-05-30 16:11:31 | Re: jdbc pg_hba.conf error |