Thread: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

From
"Mikheev, Vadim"
Date:
> I've tried:
> 
> bin/postgres -O -P -D `pwd`/data horde
> 
> POSTGRES backend interactive interface
> $Revision: 1.155.2.1 $ $Date: 2000/08/30 21:19:32 $
> 
> backend> reindex database horde;
> backend> 
> 
> still get it ...
> 
> I'm either doing something wrong with REINDEXng the system 
> tables, or this isn't what hte problem is :(

I'm not sure how REINDEX works... to restore after some crashes
REINDEX should 1. drop indices; 2. vacuum table(s); 3. create indices
(note - create index *after* table itself is vacuumed).

Vadim