X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3EE8C9FA5CD for ; Thu, 20 Jul 2006 04:46:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 20181-03 for ; Thu, 20 Jul 2006 07:46:12 +0000 (UTC) X-Greylist: delayed 00:27:24.732208 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 853B29FA6B0 for ; Thu, 20 Jul 2006 04:46:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.internode.com.au (mail.internode.com.au [192.83.231.27]) by svr4.postgresql.org (Postfix) with ESMTP id 24DA15AF041 for ; Thu, 20 Jul 2006 07:18:45 +0000 (GMT) Received: from [172.20.0.93] (staffnet.internode.com.au [203.26.95.33]) by mail.internode.com.au (8.13.7/8.12.1) with ESMTP id k6K7IdWE005190 for ; Thu, 20 Jul 2006 16:48:40 +0930 (CST) Message-ID: <44BF2E4F.7090200@internode.com.au> Date: Thu, 20 Jul 2006 16:48:39 +0930 From: Omer Mustafa User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Connection refused. Check that the hostname and port are correct Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/227 X-Sequence-Number: 22473 Hi, I am new to PostgreSQL. I am trying to connect to my PostgreSQL database installed on Unix. I am getting the following error message, *************************************************************************** An error occured while establishing the connection. Type: org.postgresql.util.PSQLException Error Code: 0 SQL State: 08004 Message: 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. ******************************* postgres 25398 25344 0 11:57:51 pts/2 0:00 psql syslog postgres 25548 25546 0 16:01:35 pts/3 0:00 /usr/local/pgsql/bin/postmaster postgres 25613 25580 0 16:43:01 pts/3 0:00 grep post postgres 25344 25301 0 10:57:05 pts/2 0:00 -tcsh postgres 25546 1 0 16:01:35 pts/3 0:00 /usr/local/pgsql/bin/postmaster postgres 25550 25549 0 16:01:35 pts/3 0:00 /usr/local/pgsql/bin/postmaster postgres 25549 25546 0 16:01:35 pts/3 0:00 /usr/local/pgsql/bin/postmaster postgres 25580 25443 0 16:34:17 pts/3 0:00 -tcsh ******************************* I have the following settings in my configuration file ****************** host syslog sysloguser 10.10.10.10/32 trust host syslog sysloguser 192.168.0.0/32 trust ***************** Please advice what am I doing wrong -- Thanks and Regards Omer Mustafa Oracle Application DBA omustafa@internode.com.au Internode, Level 1, 132 Grenfell Street ADELAIDE SA 5000 Ph: 08 8228 2379 Mobile # 0421 038839