Re: jdbc pg_hba.conf error

["chris smith" <dmagick(at)gmail(dot)com>]

On 5/31/07, Bhavana.Rakesh <Bhavana(dot)Rakesh(at)noaa(dot)gov> wrote:
>  Ok,
>  I confirmed that I'm editing the right pg_hba.conf file.  I made sure that
> there are no other postmasters running.  I made sure that there is a user
> called 'brakesh'.  I restart the postmaster everytime I make any changes to
> pg_hba.conf file.  But still same results!
>
>  [brakesh(at)lnx383 ~/db_connect]$ psql -U brakesh -h 127.0.0.1 -d testing123
>  psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "brakesh",
> database "testing123", SSL off
>
>
>  [brakesh(at)lnx383 ~/db_connect]$ psql -p 5000 testing123
>  Welcome to psql 7.4.17, the PostgreSQL interactive terminal.

Why are you specifying the port number when you don't include the host?

What happens if you do include the port:

psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123

--
Postgresql & php tutorials
http://www.designmagick.com/