Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 00EF59F9DAD for ; Thu, 30 Nov 2006 11:10:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 38300-04 for ; Thu, 30 Nov 2006 11:10:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0066E9FA0CC for ; Thu, 30 Nov 2006 11:10:31 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kAUFAPHK013196; Thu, 30 Nov 2006 10:10:25 -0500 (EST) To: Geoffrey cc: John Allgood , pgsql-admin@postgresql.org, Terry Lee Tucker , "J. D. Pearson" Subject: Re: Out of file-descriptors message In-reply-to: <456EE6CE.2030106@3times25.net> References: <456DF2DE.3060002@turbocorp.com> <4727.1164835974@sss.pgh.pa.us> <456E03C9.6070204@the-allgoods.net> <20061129222523.GI7001@alvh.no-ip.org> <456EE6CE.2030106@3times25.net> Comments: In-reply-to Geoffrey message dated "Thu, 30 Nov 2006 09:12:30 -0500" Date: Thu, 30 Nov 2006 10:10:25 -0500 Message-ID: <13195.1164899425@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/258 X-Sequence-Number: 23785 Geoffrey writes: > I work with the original poster and wanted to make sure the problem here > is clear. The 'out of file descriptors' message is coming from > Postgresql, not the kernel. Thus, it doesn't make sense to me that the > max_files_per_process setting is too high. I would think we need to > increase it so that Postgresql will stop generating these errors. These are not "errors", they are only log messages. It would be perfectly safe to ignore them. However, as Alvaro says, if you want to get rid of them then the way to do that is to *decrease* max_files_per_process to something less than whatever per-process file limit the kernel is enforcing. regards, tom lane