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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
