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