Problem with dropping a tablespace

Поиск
Список
Период
Сортировка
Искать
От
Oliver Siegmar
Тема
Problem with dropping a tablespace
Дата
Msg-id
200508012128.07431.o.siegmar@vitrado.de
Список
Дерево обсуждения
Problem with dropping a tablespace Oliver Siegmar <o.siegmar@vitrado.de>
Re: Problem with dropping a tablespace Michael Fuhr <mike@fuhr.org>
Re: Problem with dropping a tablespace Oliver Siegmar <o.siegmar@vitrado.de>
Re: Problem with dropping a tablespace Michael Fuhr <mike@fuhr.org>
Re: Problem with dropping a tablespace Oliver Siegmar <o.siegmar@vitrado.de>
Re: Problem with dropping a tablespace Michael Fuhr <mike@fuhr.org>
Re: Problem with dropping a tablespace Tom Lane <tgl@sss.pgh.pa.us>
Re: Problem with dropping a tablespace Oliver Siegmar <o.siegmar@vitrado.de>
Re: Problem with dropping a tablespace Tom Lane <tgl@sss.pgh.pa.us>
Re: Problem with dropping a tablespace Oliver Siegmar <o.siegmar@vitrado.de>
Re: Problem with dropping a tablespace Tom Lane <tgl@sss.pgh.pa.us>
Re: Problem with dropping a tablespace Oliver Siegmar <o.siegmar@vitrado.de>
Re: Problem with dropping a tablespace Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-general по дате отправления
От: Wang, Mary Y
Дата:
Сообщение: Re: Unable to Update a Record
От: Michael Fuhr
Дата:
FAQ