| From: | Geoffrey <esoteric(at)3times25(dot)net> |
|---|---|
| To: | Geoffrey <esoteric(at)3times25(dot)net>, John Allgood <john(at)turbocorp(dot)com>, pgsql-admin(at)postgresql(dot)org, Terry Lee Tucker <terry(at)leetuckert(dot)net>, "J(dot) D(dot) Pearson" <jpearson(at)turbocorp(dot)com> |
| Subject: | Re: Out of file-descriptors message |
| Date: | 2006-11-30 14:54:04 |
| Message-ID: | 456EF08C.3000302@3times25.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-11-30 15:10:25 | Re: Out of file-descriptors message |
| Previous Message | John Allgood | 2006-11-30 14:52:07 | Re: Out of file-descriptors message |