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

Re: DB Crash, recoverable?

From: Michael Guerin <guerin(at)rentec(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: DB Crash, recoverable?
Date: 2005-01-26 21:32:30
Message-ID: 41F80C6E.7030108@rentec.com (view raw or flat)
Thread:
Lists: pgsql-novice
Tom Lane wrote:

>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
>  
>
I can't see this row, could I select the contents of pg_type into a 
table, truncate pg_type and load the table back up?

Thanks for you help.
Michael

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-01-26 21:35:37
Subject: Re: DB Crash, recoverable?
Previous:From: Tom LaneDate: 2005-01-26 20:10:02
Subject: Re: DB Crash, recoverable?

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