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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
