DROP TABLESPACE fails

From: Steve Peterson <stevep-hv(at)zpfe(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DROP TABLESPACE fails
Date: 2006-08-07 22:36:49
Message-ID: 6.2.3.4.0.20060807173048.0611f608@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Winter 2006-08-07 22:51:05 Re: Disabling and enabling constraints and triggers to make pg_restore work
Previous Message Matt 2006-08-07 22:21:10 FATAL Error