| 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: | Whole Thread | Raw Message | 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
| 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 |