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

pg_sorttemp#####.##

From: Michel BELLON <michel(dot)bellon(at)free(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_sorttemp#####.##
Date: 2005-02-25 12:35:33
Message-ID: 200502251235.33975.michel.bellon@free.fr (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Sabio - PSQLDate: 2005-02-25 14:42:33
Subject: Cross tablespaces query
Previous:From: Thomas F.O'ConnellDate: 2005-02-25 08:43:05
Subject: Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users

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