The following bug has been logged online:

Bug reference: 2782
Logged by: Alaa El Gohary
Email address: alaaelgohary (AT) bftech (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

"Alaa El Gohary" <alaaelgohary (AT) bftech (DOT) com.eg> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend