Re: jdbc pg_hba.conf error

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/