Re: DB Crash, recoverable?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Guerin <guerin(at)rentec(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: DB Crash, recoverable?
Date: 2005-01-26 20:10:02
Message-ID: 19205.1106770202@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Michael Guerin <guerin(at)rentec(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Guerin 2005-01-26 21:32:30 Re: DB Crash, recoverable?
Previous Message Michael Guerin 2005-01-26 20:08:28 Re: DB Crash, recoverable?