Re: DB Crash, recoverable? - Mailing list pgsql-novice

From Tom Lane
Subject Re: DB Crash, recoverable?
Date
Msg-id 19205.1106770202@sss.pgh.pa.us
Whole thread Raw
In response to Re: DB Crash, recoverable?  (Michael Guerin <guerin@rentec.com>)
Responses Re: DB Crash, recoverable?  (Michael Guerin <guerin@rentec.com>)
List pgsql-novice
Michael Guerin <guerin@rentec.com> writes:
>> Does it help if you REINDEX pg_type?
>>
> I will try.  The last time this happened I re-indexed all the system &
> user tables, clustered the users tables as well as re-created all the
> user defined types & functions.  These steps didn't resolve the problem.

In that case REINDEX probably won't help.  You could manually delete the
conflicting pg_type row I suppose.

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Guerin
Date:
Subject: Re: DB Crash, recoverable?
Next
From: Michael Guerin
Date:
Subject: Re: DB Crash, recoverable?