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,
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2006-11-30 15:10:25|
|Subject: Re: Out of file-descriptors message |
|Previous:||From: John Allgood||Date: 2006-11-30 14:52:07|
|Subject: Re: Out of file-descriptors message|