Re: jdbc pg_hba.conf error

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