Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Out of file-descriptors message
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: John Allgood <jallgood(at)the-allgoods(dot)net>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org, Terry Lee Tucker <terry(at)leetuckert(dot)net>, "J. D. Pearson" <jpearson(at)turbocorp(dot)com>, Geoffrey <esoteric(at)3times25(dot)net>
- Subject: Re: Out of file-descriptors message
- Date: Wed, 29 Nov 2006 19:25:23 -0300
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.
- Follow-Ups:
- Re: Out of file-descriptors message
- From: Geoffrey
- Re: Out of file-descriptors message
- From: John Allgood
- Re: Out of file-descriptors message
- References:
- Out of file-descriptors message
- From: John Allgood
- Re: Out of file-descriptors message
- From: Tom Lane
- Re: Out of file-descriptors message
- From: John Allgood
- Out of file-descriptors message
- Prev by Date: Re: Out of file-descriptors message
- Next by Date: Re: dump from 8.x restore to 7.3.x
- Previous by thread: Re: Out of file-descriptors message
- Next by thread: Re: Out of file-descriptors message
- Indexes: