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

GH <grasshacker(at)over-yonder(dot)net> writes:
> running this script with "start" causes the postgres server to start,
> run out of files, and then shutdown. Postgres is useable until it runs
> out of files and shuts down.

Continuing on that line of thought --- it seems like this must be an
indication of a file-descriptor leak somewhere. That is, some bit of
code forgets to close a file it opened. Cycle through that bit of code
enough times, and the kernel stops being willing to give you more file
descriptors.

If this is correct, we could probably identify the leak by knowing what
file is being opened multiple times. Can you run 'lsof' or some similar
tool to check for duplicate descriptors being held open by the
postmaster?

I recall that we have fixed one or two leaks of this kind in the past,
but I don't recall details, nor which versions the fixes first appeared
in.

regards, tom lane