Re: 8.1.3 and unused files

Rod Taylor <pg@rbt.ca> writes:
> On Fri, 2006-05-05 at 14:31 -0400, Tom Lane wrote:
>> Unless you had an actual backend crash, that's not an adequate
>> explanation.  Transaction abort does clean up created files.

> The only thing I can come up with is that perhaps someone forcefully
> gave it a kick. SIGTERM is a necessary action once in a while to unwedge
> a stuck db connection (killing the client script doesn't always get it
> immediately).

SIGTERM wouldn't cause that either.  I hope your people are not in the
habit of using "kill -9"?
        regards, tom lane