Re: Out of file-descriptors message

John Allgood wrote:
> Hey Tom
>
>     I assume that if it is the kernel running out of descriptors that I
> would get the messages in dmesg. This message only appears in the log
> file for that database.

Yeah, the point is that you have the max_files_per_process setting
higher than what the kernel likes.  So decrease it, and Postgres will
adjust itself to use less file descriptors by closing and reopening
files as needed.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.