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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to