Re: Thousands of errors...what happened?

Jerry Levan wrote:
> The other day I attempted to connect to my 9.3.2 postgresql data base and my connection
> attempts kept failing.
>
> I found about 100000 lines in the log file that looked like:
>
> ERROR:  could not seek to end of file "global/12292": Too many open files
> LOG:  out of file descriptors: Too many open files; release and retry

I think this means there is a file descriptor leak somewhere; maybe a
third-party module by Apple.  It might be useful to see what files are
open by the offending process; in Linux you would just see
ls -l /proc/{pid}/fd
but I don't know if this works on Mac OS X.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services