RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ... - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018D11@SECTORBASE1
Whole thread Raw
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: pgsql is 75 times faster with my new index scan
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...