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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954