Re: Out of file-descriptors message - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Out of file-descriptors message
Date
Msg-id 20061129222523.GI7001@alvh.no-ip.org
Whole thread Raw
In response to Re: Out of file-descriptors message  (John Allgood <jallgood@the-allgoods.net>)
Responses Re: Out of file-descriptors message  (John Allgood <jallgood@the-allgoods.net>)
Re: Out of file-descriptors message  (Geoffrey <esoteric@3times25.net>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: John Allgood
Date:
Subject: Re: Out of file-descriptors message
Next
From: Shane Ambler
Date:
Subject: Re: dump from 8.x restore to 7.3.x