can't drop an old tablespace

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: can't drop an old tablespace
Date: 2010-09-07 13:42:48
Message-ID: C4DAC901169B624F933534A26ED7DF31034BB7CB@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

(Postgres 8.3, Linux)

while trying to drop a tablespace, I get an error tablespace "xxx" is
not empty.

There are effectively a few files within the corresponding folder,

but all of them are empty and a few months old.

moreover, pg_class does not contain any references to this tablespace.

What should I do to safely get rid of this tablespace:

- Is there a way to obtains all dependent objects of a tablespace ?

- How is this error triggered ? comes it from a check of the folder
content, or from the catalog ?

many thanks,

Marc Mamin

Browse pgsql-admin by date

  From Date Subject
Next Message fel 2010-09-07 13:50:33 [NOVICE] - SAN\NAS\DAS - Need help
Previous Message fel 2010-09-07 13:03:44 [NOVICE] - SAN/NAS/DAS - Need advises