Re: Connection refused. Check that the hostname and port

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