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