Re: Problem with dropping a tablespace

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