Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2D4D99FB5CC for ; Tue, 1 May 2007 22:59:58 -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 76978-04 for ; Tue, 1 May 2007 22:59:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.249]) by postgresql.org (Postfix) with ESMTP id 2D66C9FB840 for ; Tue, 1 May 2007 22:59:55 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so1872590ana for ; Tue, 01 May 2007 18:59:54 -0700 (PDT) Received: by 10.100.229.12 with SMTP id b12mr64595anh.1178071192896; Tue, 01 May 2007 18:59:52 -0700 (PDT) Received: from srinilaptop ( [71.175.17.63]) by mx.google.com with ESMTP id c16sm294033anc.2007.05.01.18.59.52; Tue, 01 May 2007 18:59:52 -0700 (PDT) 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 21:59:51 -0400 Organization: Coriendo LLC Message-ID: <01c801c78c5d$92ec10e0$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: AceMQ0RN9fD3hKTCT3u5xGhgpRf5eQAGIZvQ In-Reply-To: <1845.1178059892@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/15 X-Sequence-Number: 25335 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