Re: Problem with dropping a tablespace
От | Oliver Siegmar |
---|---|
Тема | Re: Problem with dropping a tablespace |
Дата | |
Msg-id | 200508021714.57184.o.siegmar@vitrado.de обсуждение исходный текст |
Ответ на | Re: Problem with dropping a tablespace (Michael Fuhr <mike@fuhr.org>) |
Ответы |
Re: Problem with dropping a tablespace
|
Список | pgsql-general |
On Tuesday 02 August 2005 17:01, Michael Fuhr wrote: > Hmmm...based on the file names, it looks like the directory contains > only system tables. Do you know what database this was? Yes, a business database - not a system one. The database were created using template0. > Did you > explicitly drop it, or is its disappearance (or appearance) a > mystery? I dropped the database with 'DROP DATABASE xxx;' without any problems (after the tablespace run out of space). BTW: The 'default' tablespace (pg_default and pg_global) where all the system stuff relies on, didn't ran out of space - only a temporarily created tablespace on another partition. > Didn't you say that the tablespace's filesystem ran out > of space? When did that happen in relation to this database's > existence (during create, during drop, etc.)? It happened while performing a 'pg_dump -F p business_db | pg_restore -d disk1'. > Are there any unusual > messages in the PostgreSQL logs? Well, the only unusual messages were when the space ran out - tons of entries like this: ERROR: could not write block 13632 of relation 594611987/597873915/736358396: No space left on device Thanks Oliver
В списке pgsql-general по дате отправления: