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.
