Re: Out of file-descriptors message - Mailing list pgsql-admin

From Geoffrey
Subject Re: Out of file-descriptors message
Date
Msg-id 456EF08C.3000302@3times25.net
Whole thread Raw
In response to Re: Out of file-descriptors message  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Out of file-descriptors message  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: John Allgood
Date:
Subject: Re: Out of file-descriptors message
Next
From: Tom Lane
Date:
Subject: Re: Out of file-descriptors message