Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E088F9FB7FD for ; Tue, 1 May 2007 23:12:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80296-03 for ; Tue, 1 May 2007 23:12:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 662569FA4AD for ; Tue, 1 May 2007 23:12:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mailout14.yourhostingaccount.com (mailout14.yourhostingaccount.com [65.254.253.118]) by svr4.postgresql.org (Postfix) with ESMTP id 661FF5AF0B2 for ; Wed, 2 May 2007 02:12:52 +0000 (GMT) Received: from mailscan10.yourhostingaccount.com ([10.1.15.10] helo=mailscan10.yourhostingaccount.com) by mailout14.yourhostingaccount.com with esmtp (Exim) id 1Hj4Ko-0002JY-FD for pgsql-admin@postgresql.org; Tue, 01 May 2007 22:12:50 -0400 Received: from authsmtp01.yourhostingaccount.com ([10.1.1.155] ident=exim) by mailscan10.yourhostingaccount.com with spamscanlookuphost (Exim) id 1Hj4Kn-0008W3-OP for pgsql-admin@postgresql.org; Tue, 01 May 2007 22:12:49 -0400 Received: from authsmtp01.yourhostingaccount.com ([10.1.1.155] helo=authsmtp01.yourhostingaccount.com) by mailscan10.yourhostingaccount.com with esmtp (Exim) id 1Hj4Kn-0008Vu-01; Tue, 01 May 2007 22:12:49 -0400 Received: from pool-71-175-17-63.phlapa.fios.verizon.net ([71.175.17.63] helo=srinilaptop) by authsmtp01.yourhostingaccount.com with esmtpa (Exim) id 1Hj4Km-0008Gc-5Y; Tue, 01 May 2007 22:12:48 -0400 Reply-To: From: "'Srinivas Kotapally'" To: "'Tom Lane'" Cc: References: <016601c78bf3$80819c00$800101df@srinilaptop> <1845.1178059892@sss.pgh.pa.us> Subject: Re: Intermittent Postgres Connection refused Errors (JDBC) Date: Tue, 1 May 2007 22:12:46 -0400 Organization: Coriendo LLC Message-ID: <01d101c78c5f$615b1790$800101df@srinilaptop> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AceMQ0RN9fD3hKTCT3u5xGhgpRf5eQAHBE9g In-Reply-To: <1845.1178059892@sss.pgh.pa.us> X-EN-UserInfo: 7b39549d18acd124e97783bb813c9bcc:e25d2d23f680f6c51a71cc9f7fe7a271 X-EN-AuthUser: ksrinivas X-EN-OrigIP: 71.175.17.63 X-EN-OrigHost: pool-71-175-17-63.phlapa.fios.verizon.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.448 tagged_above=0 required=5 tests=BAYES_50=0.001, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: * X-Archive-Number: 200705/10 X-Sequence-Number: 25330 Hi Tom I installed CentOS 4.4 final late last year. The kernel version was the latest about a year back. I have been running yum updates and applying patches regularly. Can you give me any ideas on how to troubleshoot (and establish that this issue is due to a kernel bug) the kernel packet drops? I am beginning to think it is a firewall related issue. But I have been unable to replicate the issue! I have been monitoring the firewall logs (could not find much there). Maybe I will also sifting through the messages log on the servers. Will post if I find anything! Thanks Srini -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, May 01, 2007 6:52 PM To: ksrinivas@coriendo.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Intermittent Postgres Connection refused Errors (JDBC) "Srinivas Kotapally" writes: > 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! "Connection refused" means it was refused at the kernel level; if the postmaster had rejected the connection the message would be different. So you need to be looking for OS-level issues. Given that you seem to be running a rather hoary kernel (2.6.9 is a ways back no?), maybe an update there is indicated. Firewall problems are a possibility too. regards, tom lane