Problem with dropping a tablespace

From: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with dropping a tablespace
Date: 2005-08-01 19:28:07
Message-ID: 200508012128.07431.o.siegmar@vitrado.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm unable to drop a recently created tablespace (the partition on which the
tablespace relies on, run out of space - postgresql seems to have a problem,
now):

template1=# drop tablespace disk1;
ERROR: tablespace "disk1" is not empty

Huh? Okay...lets dig into...

template1=# select oid from pg_tablespace where spcname = 'disk1';
oid
-----------
594611987
(1 row)

template1=# select * from pg_tablespace_databases(594611987);
pg_tablespace_databases
-------------------------
595675173
(1 row)

Aha...so there seems to be a database associated to this tablespace - lets see
which one -

template1=# select * from pg_database where oid = 595675173;
datname | datdba | encoding | datistemplate | datallowconn | datlastsysoid |
datvacuumxid | datfrozenxid | dattablespace | datconfig | datacl
---------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------------+-----------+--------
(0 rows)

Mhh. Nothing.

How may I delete the tablespace manually?

Best regards

Oliver

Responses

Browse pgsql-general by date

  From Date Subject
Next Message littlebutty 2005-08-01 19:38:40 Re: Tool for database design documentation?
Previous Message Wang, Mary Y 2005-08-01 18:51:12 Re: Unable to Update a Record