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 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 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 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 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 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 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 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 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 ERROR: could not seek to end of file "global/12292": Too many open files LOG: database system was interrupted; last known up at 2014-03-01 07:49:58 CST LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/1BD6680 LOG: redo is not required LOG: database system is ready to accept connections LOG: autovacuum launcher started LOG: database system was interrupted; last known up at 2014-03-15 07:35:29 CDT LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/1BE41F4 LOG: redo is not required LOG: database system is ready to accept connections LOG: autovacuum launcher started I could not stop the postgresql server so I had to reboot the system (: I am the only user of the db and I use the rascal spareinly. Any idea what the problem could have been? Jerry -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
