Re: jdbc pg_hba.conf error

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

[brakesh@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.Rakesh@noaa.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@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@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
>