Search Postgresql Archives

DROP TABLESPACE fails

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux