Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CF5249FA1A1 for ; Thu, 30 Nov 2006 10:54:13 -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 03526-09 for ; Thu, 30 Nov 2006 10:54:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from www.3times25.net (duck.3times25.net [66.23.211.34]) by postgresql.org (Postfix) with ESMTP id 7B4B99FA18B for ; Thu, 30 Nov 2006 10:54:08 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by www.3times25.net (Postfix) with ESMTP id 28F9354020; Thu, 30 Nov 2006 09:54:05 -0500 (EST) Message-ID: <456EF08C.3000302@3times25.net> Date: Thu, 30 Nov 2006 09:54:04 -0500 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: Geoffrey , John Allgood , pgsql-admin@postgresql.org, Terry Lee Tucker , "J. D. Pearson" Subject: Re: Out of file-descriptors message 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> <20061130142758.GI15105@alvh.no-ip.org> <456EEECC.1000701@3times25.net> <20061130145143.GJ15105@alvh.no-ip.org> In-Reply-To: <20061130145143.GJ15105@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/257 X-Sequence-Number: 23784 Alvaro Herrera wrote: > Geoffrey wrote: > >> Okay, I'm just not getting it. Postgres complains that it is out of >> file descriptors. The kernel is not complaining about any such issues. >> >> >> So I should lower the max_files_per_process >> value and this will rid us of the 'out of file descriptors' error? >> >> Is it because the max_files_per_process is greater then the number of >> file descriptors that are alloted to Postgres by the kernel? > > Yes. Which is kinda weird, because Postgres actually tests the number > when it starts, so that if you set the number too high, it will decrease > it according to what the kernel allows. > > Maybe the test is newer than the version you are running -- what was it, > again? > 7.4.13 -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin