On Wed, 2007-05-30 at 13:00 -0400, [EMAIL PROTECTED] wrote: > Did you grant access to your user?
If you mean grant access by an SQL GRANT, he hasn't got far enough to check that. The error specifically says "no pg_hba.conf entry". As far as I can see, his pg_hba.conf is OK. > > 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. > > > > > > > -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
