Re: Problem with dropping a tablespace

On Mon, Aug 01, 2005 at 09:28:07PM +0200, Oliver Siegmar wrote:
>
> 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?

Perhaps a better question to ask is: why does pg_tablespace_databases()
think that database 595675173 has objects in the tablespace? What
platform are you using? If some flavor of Unix, what's the output
of the following command?

ls -alR /path/to/tablespace/directory

(Replace the path with the tablespace's directory; you'll probably
need to be the directory owner or root to run "ls" without getting
a "Permission denied" error).

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/