Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8A0D82E30EF for ; Fri, 25 Jan 2008 12:19:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 44368-08 for ; Fri, 25 Jan 2008 12:19:12 -0400 (AST) Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.182]) by postgresql.org (Postfix) with ESMTP id 753552E30F8 for ; Fri, 25 Jan 2008 12:19:11 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so105954ele.5 for ; Fri, 25 Jan 2008 08:19:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=K4MrgqnpqA5nVIqJ+n5sCk4gCpjjY5eCEyI8zSLbCfE=; b=vml2FvXj9CCt0YRq0fkZPgKFbnXxoGav3VegjXhEm3XdzPauDJCM/7sk/X/VIM7PyZ6gAvTj09xtjm5D30ZY0p4TkLWw7j9w/T2G1G8L+6CvT96oHlozATGp3ToidvaByON2r46ZBpUwmwz6AkhdAbb+zzJztQ/uZmFDXSYeP6A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=n0AbHuNIaE2SNQT82cXnDUKIDI7HOkqylYFfKS0ZmdV8bOwx6T5eodkG4RtxrbvY9ro5UBNV3XETQ/VDtcD0psjI/7acAfv10gF23793y4SwDTSnMHz3yPaTdAIwdENggljacJo6gLSb89wLZg64OCKXBDeGIvA5TVcPiDe6eLI= Received: by 10.142.77.11 with SMTP id z11mr1329831wfa.98.1201277949730; Fri, 25 Jan 2008 08:19:09 -0800 (PST) Received: by 10.142.165.8 with HTTP; Fri, 25 Jan 2008 08:19:09 -0800 (PST) Message-ID: Date: Fri, 25 Jan 2008 10:19:09 -0600 From: "Scott Marlowe" To: "PostgreSQL Admin" Subject: Re: [SQL] Unclosed connections Cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <479A081A.9020204@productivitymedia.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4788056B.2020809@rakkar.org> <47881810.7030303@Sheeky.Biz> <47882EAC.4030203@rakkar.org> <478896D4.8090405@Sheeky.Biz> <479A081A.9020204@productivitymedia.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/245 X-Sequence-Number: 28019 On Jan 25, 2008 10:02 AM, PostgreSQL Admin wrote: > We are using this bad piece of the software that does not close > connections to the postgres server. Is there some setting for closing > dead connections? And not TCP/IP keep alive does not work. If the TCP keepalive can't detect them as dead, how is something else supposed to? I.e. if a keepalive packet gets answered, then the connection isn't dead, something is still connected to it.