Re: Connection refused. Check that the hostname and port

Please do not remove the list from the Cc when replying.

On Thu, 27 Jul 2006, Omer Mustafa wrote:

> FATAL: no pg_hba.conf entry for host "203.26.95.33", user "sysloguser",
> database "syslog"
>
> but i have this entry in my pg_hba file.

Most likely it is because you didn't reload the postgresql service after
making the changes or because it is matching another entry first.  The
pg_hba.conf is parsed in a top down manner with the first match winning.
Post your pg_hba.conf and we can likely help you.  Remember that you must
reload the postgresql service after making changes.


>
> Jeff Frost wrote:
>> On Thu, 20 Jul 2006, Omer Mustafa wrote:
>>
>>>   Connection refused. Check that the hostname and port are correct and
>>> that the postmaster is accepting TCP/IP connections.
>>> Exception: java.net.ConnectException: Connection refused: connect
>>> ***************************************************************************
>>>
>>> I have checked port number, user name, password and they are all correct.
>>> I have also checked that the postmaster is also running.
>>
>> Most likely the postgresql server is set to listen for unix socket
>> connections and/or connections from localhost only.  Look for the following
>> in your postgresql.conf file:
>>
>> #listen_addresses = 'localhost' # what IP interface(s) to listen on;
>>                                 # defaults to localhost, '*' = any
>>
>> You most likely want to change that to:
>>
>> listen_addresses = '*'
>>
>> That's from an 8.x config file.  If you have an older version the
>> terminology is likely different, but the effect is similar.
>>
>
>

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954