Search Postgresql Archives

Re: Thousands of errors...what happened?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux