Re: BUG #2782: Too Many open files in system

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alaa El Gohary" <alaaelgohary(at)bftech(dot)com(dot)eg>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2782: Too Many open files in system
Date: 2006-11-28 03:01:06
Message-ID: 27634.1164682866@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alaa El Gohary" <alaaelgohary(at)bftech(dot)com(dot)eg> writes:
> this message appears when trying to open an application
> Fatal:could not open file"/usr/local/pgsql/data/global/1262":too many open
> files in system

Try reducing max_files_per_process. Your kernel is evidently promising
more than it can deliver about how many files each process can open.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-11-28 03:05:04 Re: BUG #2785: Exception Issue
Previous Message Tom Lane 2006-11-28 02:59:06 Re: BUG #2784: Performance serious degrades over a period of a month