Michael Fuhr <mike@xxxxxxxx> writes: > On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote: >> 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? > I'd recommend investigating what the files are before deleting them. Indeed. > The large files are probably within a database's subdirectory and > their names are probably numbers. Yeah, most likely they belong to a different database. We should try harder to give a helpful error message in this case ... we can't really identify the files but we could tell you which database they belong to. regards, tom lane
