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

The following bug has been logged online:

Bug reference:      2782
Logged by:          Alaa El Gohary
Email address:      alaaelgohary@bftech.com.eg
PostgreSQL version: 7.4.12
Operating system:   FreeBSD 6.0
Description:        Too Many open files in system
Details:

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

"Alaa El Gohary" <alaaelgohary@bftech.com.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