Thread: core and temp files

I've got a sudden hard disk space problem that appears to be related to
core and pg_sorttemp2761.2  like files in the base/database directory.
Can these be deleted with no ill effects?  I removed one core file
higher in the directory structure with no ill effects.

What's causing this?  I could set up an automatic deletion program if
necessary.

--
Tom Bakken
Information Resource Manager
USDA, Rural Development
101 South Main, Suite 102
Temple, TX 76501

Phone: 254-742-9726 Fax: 254-742-9709
Email: tom.bakken@tx.usda.gov

"Tom.Bakken" <Tom.Bakken@tx.usda.gov> writes:
> I've got a sudden hard disk space problem that appears to be related to
> core and pg_sorttemp2761.2  like files in the base/database directory.
> Can these be deleted with no ill effects?  I removed one core file
> higher in the directory structure with no ill effects.

core files can be removed, and so can sorttemp files if the creating
process (PID 2761 in this example) is no longer around.

> What's causing this?  I could set up an automatic deletion program if
> necessary.

That strikes me as institutionalizing an expectation of failure :-(.
Better to chase down why you are suffering backend crashes.  Before
you zap those core files, why not try to get stack traces from them?

            regards, tom lane