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: (view raw, whole thread or download thread mbox)
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 "", user 
> "b                                   rakesh", database "testing123", SSL 
> off

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

> 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 or adding your own if you don't want "trust" security.
   Richard Huxton
   Archonet Ltd

In response to


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-2017 The PostgreSQL Global Development Group