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
