Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 21E069FBA0D for ; Tue, 1 May 2007 18:58:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 63639-01 for ; Tue, 1 May 2007 18:58:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241]) by postgresql.org (Postfix) with ESMTP id 50BB59FB9F3 for ; Tue, 1 May 2007 18:58:50 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so1825339ana for ; Tue, 01 May 2007 14:58:49 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=YGa5D7yIiIpnEWO/K39DO+4gOKaPo+eKq9wT3wfr6XnucZScyi9Cad/c/EFqb9/UzE1V+AetSUNAUJpD5BbjAeSsLlF1jjOAiMDJXBYGU9qahMhBsTIwiVfmR6lHa4gSlhKrzgm8UFZoytdvzzyIboLRDMBK5Bv1Ro0Gpb3Y9h0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=YLgcHNY5NgNl9k44uH+fEISJ9h5IywYtyhjK5g4TbZkRrE7Uz/yZPbqXPRPMzfCj3eyrEMNnhHzb0LNRggBLk2ytA8I1+oV5firN0Ib/XK5JC0xp7BqUuSBhvpAPIooXR4nHHheir0scBFatpcpy2myV7g8MbkjbDNg7lR45O0w= Received: by 10.100.130.8 with SMTP id c8mr1323248and.1178056729172; Tue, 01 May 2007 14:58:49 -0700 (PDT) Received: by 10.100.144.18 with HTTP; Tue, 1 May 2007 14:58:49 -0700 (PDT) Message-ID: Date: Tue, 1 May 2007 16:58:49 -0500 From: "Aaron Bono" To: ksrinivas@coriendo.com Subject: Re: Intermittent Postgres Connection refused Errors (JDBC) Cc: pgsql-admin@postgresql.org In-Reply-To: <01a101c78c37$6da02450$800101df@srinilaptop> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_335324_24443350.1178056729116" References: <01a101c78c37$6da02450$800101df@srinilaptop> X-Google-Sender-Auth: c194dc633d5bb3e1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/5 X-Sequence-Number: 25325 ------=_Part_335324_24443350.1178056729116 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 5/1/07, Srinivas Kotapally wrote: > > Hi > > I am managing an application that uses the Postgres backend. Of late we > have started getting connection refused errors every now and then. We have > not been able to identify the cause of this. Any hints or known bugs that I > should be aware of? Thanks for any help extended! > > Regards > > Srinivas > > Here is the environment I work in: > Application is a Java app residing on a web server and is running on > Tomcat. > Versions: > jdk: 1.5.0_02 > Tomcat 5.5.23 > Web server: httpd-2.0.52-28.ent.centos4 > Kernel: Linux version 2.6.9-42.0.10.ELsmp (mockbuild@builder5.centos.org) > (gcc version 3.4.6 20060404 (Red Hat 3.4.6-3)) #1 SMP Tue Feb 27 09:40:21 > EST 2007 > Postgres: 8.1.8 (64 bit version) - > postgresql-libs-8.1.8-1PGDG > postgresql-8.1.8-1PGDG > postgresql-server-8.1.8-1PGDG > postgresql-contrib-8.1.8-1PGDG > > We use the JDBC2 driver that comes with Postgres. > > The specific error we get is: > > CDBConnectionPool.newConnection() : SQLException= > org.postgresql.util.PSQLException: Connection refused. Check that the > hostname and port are correct and that the postmaster is accepting TCP/IP > connections. > Are you exceeding the maximum allowed connections in PostgreSQL? I would start by checking the PostgreSQL logs. If nothing shows up, it may be a network or application configuration issue. -Aaron -- ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_335324_24443350.1178056729116 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 5/1/07, Srinivas Kotapally <ksrinivas@bisil.com> wrote:
Hi
 
I am managing an application that uses the Postgres backend.  Of late we have started getting connection refused errors every now and then.  We have not been able to identify the cause of this.  Any hints or known bugs that I should be aware of?  Thanks for any help extended!
 
Regards

Srinivas
 
Here is the environment I work in:
Application is a Java app residing on a web server and is running on Tomcat. 
Versions:
jdk: 1.5.0_02
Tomcat 5.5.23
Web server: httpd-2.0.52-28.ent.centos4
Kernel: Linux version 2.6.9-42.0.10.ELsmp (mockbuild@builder5.centos.org ) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-3)) #1 SMP Tue Feb 27 09:40:21 EST 2007
Postgres: 8.1.8 (64 bit version) -
postgresql-libs-8.1.8-1PGDG
postgresql-8.1.8-1PGDG
postgresql-server-8.1.8-1PGDG
postgresql-contrib-8.1.8-1PGDG
 
We use the JDBC2 driver that comes with Postgres.
 
The specific error we get is:
 
CDBConnectionPool.newConnection() : SQLException= org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Are you exceeding the maximum allowed connections in PostgreSQL?  I would start by checking the PostgreSQL logs.  If nothing shows up, it may be a network or application configuration issue.

-Aaron

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_335324_24443350.1178056729116--