Re: Linux / PostgreSQL question

"Mitch Vincent" <mitch@venux.net> writes:

> I was just doing some huge operations with PostgreSQL and it all crashed out
> with a "too many files open" message plastered all over the place..
> 
> Now in /proc/sys/fs/file-max there is only 4096, that limit could have
> easily been reached. Does changing the value in the file effectively change
> the limit system-wide? I changed it and rebooted but it was set right back
> to 4096.. 

A reboot would reset values in proc...

For Red Hat Linux 6.2 and up, you would add a line to
/etc/sysctl.conf:

# Max open files:
fs.file-max = 8192

-- 
Trond Eivind Glomsrød
Red Hat, Inc.