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
>
