Re: jdbc pg_hba.conf error

["Bhavana.Rakesh" <Bhavana(dot)Rakesh(at)noaa(dot)gov>]

Hi,
Here's what happens when I specify the port number

[brakesh(at)lnx383 ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
       Is the server running on host "127.0.0.1" and accepting
       TCP/IP connections on port 5000?

I  have the listen_address in

postgresql.conf

file set as follows:

#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '*'          # what IP address(es) to listen on;
                               # comma-separated list of addresses;
                               # defaults to 'localhost', '*' = all
                               # (change requires restart)
#port = 5432                            # (change requires restart)
max_connections = 100                   # (change requires restart)

-Bhavana


chris smith wrote:
> 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