On Wed, 2007-05-30 at 12:30 -0400, Bhavana.Rakesh wrote: > Oliver, > > When I do a : > psql -p 5000 testing123 > I can make a connection.
Since you aren't specifying a host (with -h), that command uses a Unix socket connection and only looks at lines in pg_hba.conf that begin with "local". (If you want to do the same in JDBC, make the hostname value blank.) > 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 What happens if you change "host" to "hostnossl" in pg_hba.conf? (Seeing that that error message specifies that SSL is off.) Please remember to SIGHUP or restart the postmaster after changing it. Again, which version of PostgreSQL is this? > > Oliver Elphick wrote: > > On Wed, 2007-05-30 at 12:11 -0400, Bhavana.Rakesh wrote: > > > > > I used the example in the following URL > > > > > > http://www.postgresql.org/docs/7.3/static/client-authentication.html > > > > > > > That does have local rather than host, of course. > > > > Are you using PostgreSQL 7,3 as well? > > > > > > > Thanks for the catch on "host" instead of "local". I made that > > > change, and reloaded pgsql.. But I still get the same error. I can > > > connect to the database using psql client, but my java connection > > > seems to be failing. > > > > > > > Were you using the exact same parameters for psql? > > > > psql -U brakesh -h 127.0.0.1 -d testing123 > > > > -- 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
