Re: Out of file-descriptors message

Поиск
Список
Период
Сортировка
От Geoffrey
Тема Re: Out of file-descriptors message
Дата
Msg-id 456EF08C.3000302@3times25.net
обсуждение исходный текст
Ответ на Re: Out of file-descriptors message  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Out of file-descriptors message  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: John Allgood
Дата:
Сообщение: Re: Out of file-descriptors message
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Out of file-descriptors message