Re: Warning: Don't delete those /tmp/.PGSQL.* files

GH <grasshacker(at)over-yonder(dot)net> writes:
> FATAL 1: ReleaseLruFile: No open files available to be closed
> ............................................................pg_ctl:
> postmaster does not start up

> After that, all postgres processes die and the cycle begins again on
> subsequent attempts to start postgres.
> At one point I would receive some "Too many open files" (or similar)
> error with postgres holding more than 750 file descriptors -- almost
> entirely consisting of socket streams.
> What is the significance of "ReleaseLruFile" and how can I repair this?

> This is using FreeBSD 4.1-RELEASE and Postgres 7.0.2.

7.0.3 will probably help --- the message is coming out of some
inappropriate error recovery code that we fixed in 7.0.3.

The underlying problem, however, is that you are running out of kernel
file table slots (ENFILE or EMFILE error return from open()). Not
enough info here to tell why that's happening.

regards, tom lane