Postgres Pro
Downloads
Home   >   mailing lists

pg_sorttemp#####.## - Mailing list pgsql-admin

From Michel BELLON
Subject pg_sorttemp#####.##
Date
Msg-id 200502251235.33975.michel.bellon@free.fr
Whole thread Raw
Responses Re: pg_sorttemp#####.##  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_sorttemp#####.##  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hello all

My system use version 7.1.2 (OK ! I know it's time to upgrade do 8.0.1
version. But, I'am happy to use yet postgresql)
I had a problem with a hard drive 100% full.
The system is OK now, but I discovered 10 files approximately 1 GB each in a
directory /var/lib/pgsql/data/base/###### named pg_sorttemp#####.##.
The date of this files is 2004-03-18 (I suppose the exact date dosn't matter)

Question : Is it possible to delete this file without precaution ?

Thanks a lot for the quality of PostgreSQL and for your answer

Michel BELLON
LCIE SA

pgsql-admin by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users
Next
From: Sabio - PSQL
Date:
Subject: Cross tablespaces query