From: | "Bhavana(dot)Rakesh" <Bhavana(dot)Rakesh(at)noaa(dot)gov> |
---|---|
To: | chris smith <dmagick(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: jdbc pg_hba.conf error |
Date: | 2007-05-31 13:38:51 |
Message-ID: | 465ECFEB.3020009@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Reece Hart | 2007-05-31 13:43:55 | Re: Make for PgSQL? |
Previous Message | Ray Stell | 2007-05-31 13:27:00 | Re: jdbc pg_hba.conf error |