Skip site navigation (1) Skip section navigation (2)

Re: core and temp files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tom(dot)Bakken" <Tom(dot)Bakken(at)tx(dot)usda(dot)gov>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: core and temp files
Date: 2001-05-07 20:55:41
Message-ID: 22870.989268941@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
"Tom.Bakken" <Tom(dot)Bakken(at)tx(dot)usda(dot)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

In response to

pgsql-odbc by date

Next:From: Tom.BakkenDate: 2001-05-07 21:26:58
Subject: Re: MS Access97 Postgres ODBC problems
Previous:From: Bruce MomjianDate: 2001-05-07 20:28:39
Subject: ODBC cleanup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group