Re: DB Crash, recoverable?

Michael Guerin <guerin@rentec.com> writes:
>    Our database just reset and now I'm getting Errors in the log and I
> would like to know if this is recoverable.  Here's the segment of the
> log right before and after it reset.

> ERROR:  duplicate key violates unique constraint "pg_type_typname_nsp_index"
> ERROR:  duplicate key violates unique constraint "pg_type_typname_nsp_index"
> ERROR:  duplicate key violates unique constraint "pg_type_typname_nsp_index"
> CONTEXT:  SQL statement "create temp table tmp_children ( uniqid bigint, memberid bigint, membertype varchar(50),
owneridsmallint, tag varchar(50), level int4 )" 
>     PL/pgSQL function "fngetcompositeids2" line 14 at SQL statement

Hmm, looks like a previous incarnation of this table was not completely
deleted.  Does it help if you REINDEX pg_type?

> => select version();
>                                    version
> -----------------------------------------------------------------------------
>  PostgreSQL 8.0.0beta5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2

You really shouldn't be still using such an old beta version.  There are
a heck of a lot of bug fixes since beta5 ...

            regards, tom lane