Skip site navigation (1) Skip section navigation (2)

Re: jdbc pg_hba.conf error

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Bhavana(dot)Rakesh" <Bhavana(dot)Rakesh(at)noaa(dot)gov>
Cc: jdbc <pgsql-odbc-owner(at)postgresql(dot)org>,pgsql_general <pgsql-general(at)postgresql(dot)org>
Subject: Re: jdbc pg_hba.conf error
Date: 2007-05-30 11:42:59
Message-ID: 465D6343.60000@archonet.com (view raw or flat)
Thread:
Lists: pgsql-general
Bhavana.Rakesh wrote:
> Hi,
> 
> I'm a newbee to postgreSQL.  Does anyone know what this error means.  

> Couldn't connect: print out a stack trace and exit.
> org.postgresql.util.PSQLException: A connection error has occurred: 
> org.postgres                                   ql.util.PSQLException: 
> FATAL: no pg_hba.conf entry for host "127.0.0.1", user 
> "b                                   rakesh", database "testing123", SSL 
> off

It means exactly what it says - you have no entry in your pg_hba.conf 
for host "127.0.0.1"

> Here is my pg_.conf file
[snip lots of commented-out lines]
> # Using sockets credentials for improved security. Not available 
> everywhere,
> # but works on Linux, *BSD (and probably some others)
> 
> local  all    all             ident   sameuser

This is the only uncommented line. Try uncommenting the line for 
127.0.0.1 or adding your own if you don't want "trust" security.
-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-general by date

Next:From: Devrim GÜNDÜZDate: 2007-05-30 11:48:16
Subject: Re: jdbc pg_hba.conf error
Previous:From: Bhavana.RakeshDate: 2007-05-30 11:36:11
Subject: jdbc pg_hba.conf error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group