Re: Errors: Too many open files

I believe the original value of /proc/sys/fs/file-max
was 1024, but I may very well be mistaken.
I have increased that value now to 65536 in hopes
that it makes the difference. Thank you Andrew, Frank
and Tom for your kind advice.
_Ken

At 07:29 AM 12/7/01, you wrote:
>Ken <mailinglists(at)creason(dot)com> writes:
>> During busy hours, Postgres and Apache are reporting
>> errors that there are too many open files, and sometimes
>> Postgres will crash.
>
>You need to raise the kernel's file table size (most Unixen call
>this kernel parameter NFILE; also NINODE might be interesting).
>It's a system-wide limit, not a per-process limit.
>
>> echo "8192" > /proc/sys/fs/file-max
>> (did not seem to make a difference)
>
>This *looks* plausible, but I'm not familiar enough with Linux to know
>if that's the right incantation or not. Also, did you check to see
>what the original value is? I'm not sure that 8k is more than the
>default ...
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster