Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group