Did you grant access to your user?
On Wed, 30 May 2007, Oliver Elphick wrote:
On Wed, 2007-05-30 at 18:35 +0200, Martijn van Oosterhout wrote:
On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote:
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
Ofcourse, the first connection is a local connection, which you
obviously have configured. The latter connects to localhost, which you
havn't configured.
His original message (which I snipped) said he had:
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
host testing123 brakesh 127.0.0.1 255.255.255.255 trust
So it seems to me he did have it configured.
In fact the first host line should be used and the second one for user
brakesh is redundant, since it comes later in the file. The only thing
I can see is that it might be related to SSL.
--
Louis Gonzales
[EMAIL PROTECTED]
http://www.linuxlouis.net
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
