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