Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D88709FA1A1 for ; Wed, 29 Nov 2006 18:04:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 93431-09 for ; Wed, 29 Nov 2006 18:04:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by postgresql.org (Postfix) with ESMTP id D54D49FB228 for ; Wed, 29 Nov 2006 18:04:26 -0400 (AST) Received: from [198.212.166.61] (Voyager.turbocorp.com [198.212.166.61]) by Mercury.turbocorp.com (8.13.1/8.13.1) with ESMTP id kATLvxM6012355; Wed, 29 Nov 2006 16:57:59 -0500 Message-ID: <456E03C9.6070204@the-allgoods.net> Date: Wed, 29 Nov 2006 17:03:53 -0500 From: John Allgood User-Agent: Thunderbird 1.5.0.8 (X11/20060911) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org, Terry Lee Tucker , "J. D. Pearson" , Geoffrey Subject: Re: Out of file-descriptors message References: <456DF2DE.3060002@turbocorp.com> <4727.1164835974@sss.pgh.pa.us> In-Reply-To: <4727.1164835974@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/246 X-Sequence-Number: 23773 Hey Tom I assume that if it is the kernel running out of descriptors that I would get the messages in dmesg. This message only appears in the log file for that database. Thanks Tom Lane wrote: > John Allgood writes: > >> 2006-11-29 14:57:51 [3823] LOG: out of file descriptors: Too many open >> files; release and retry >> > > Consider reducing PG's max_files_per_process setting. Postgres itself > will usually not have a serious problem when you've run the kernel out > of file descriptors, but everything else on the machine will :-( > > regards, tom lane >