Re: Problem with dropping a tablespace

On Tuesday 02 August 2005 18:42, Tom Lane wrote:
> > I dropped the database with 'DROP DATABASE xxx;' without any problems
> > (after the tablespace run out of space).
>
> How exactly do you know that OID 595675173 is the database you dropped,
> and not that of some other DB?

I don't know that for sure, but I can't remember having created and dropped an
other database within this tablespace.

> I'm theorizing that the scenario went like this:
>
> CREATE DATABASE starts to create a database, for which it
> assigns the OID 595675173.
>
> Copying the template database goes fine. (If we'd run out of
> space in this step, we'd have removed the partially copied
> directories before reporting failure.)
>
> While trying to make the pg_database entry for the new database,
> we run out of space and fail.

At which stage this pg_database entry gets created? I'm very sure, that there
was plenty of free disk space at the time of 'CREATE TABLE' statement. The
space ran out gigabytes after starting pg_restore.

I did a hexdump on the files within the tabelspace directory...no business
data at all, only postgres internals (I saw a lot of function names and
datatypes).

Let me know if I shall dig more information...otherwise I'm happy if I can
safely remove the directory.

Best

Oliver