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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
