Postgres Pro
Downloads
Home   >   mailing lists

DROP TABLESPACE fails - Mailing list pgsql-general

From Steve Peterson
Subject DROP TABLESPACE fails
Date
Msg-id 6.2.3.4.0.20060807173048.0611f608@localhost
Whole thread Raw
Responses Re: DROP TABLESPACE fails  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
I'm doing some tests with version 8.1.4 on Windows XP and am having
trouble recovering some disk space.

The tests involve loading some largeish CSV files in via COPY.  One
of the COPY commands failed and I'm trying to recover the disk space
without having to completely reinitialize things.

DROP TABLESPACE x returns 'tablespace "x" is not empty', but if I
examine the 'referenced by' tab in pgAdmin nothing is listed.  The
tablespace directory contains several very large files.

Can these files be deleted safely with the server shut down?

pgsql-general by date:

Previous
From: Matt
Date:
Subject: FATAL Error
Next
From: "Ken Winter"
Date:
Subject: Re: Disabling and enabling constraints and triggers to make pg_restore work