Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0B5439FA285 for ; Wed, 29 Nov 2006 17:33:06 -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 88139-05 for ; Wed, 29 Nov 2006 17:32:52 -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 202069FA19A for ; Wed, 29 Nov 2006 17:33:00 -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 kATLWslA004728; Wed, 29 Nov 2006 16:32:54 -0500 (EST) To: John Allgood cc: pgsql-admin@postgresql.org, Terry Lee Tucker , "J. D. Pearson" , Geoffrey Subject: Re: Out of file-descriptors message In-reply-to: <456DF2DE.3060002@turbocorp.com> References: <456DF2DE.3060002@turbocorp.com> Comments: In-reply-to John Allgood message dated "Wed, 29 Nov 2006 15:51:42 -0500" Date: Wed, 29 Nov 2006 16:32:54 -0500 Message-ID: <4727.1164835974@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/245 X-Sequence-Number: 23772 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