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

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'The Hermit Hacker'" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Date: 2000-09-26 19:21:53
Message-ID: 8F4C99C66D04D4118F580090272A7A23018D11@SECTORBASE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2000-09-26 20:13:48 RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Previous Message Mikheev, Vadim 2000-09-26 19:14:54 RE: pgsql is 75 times faster with my new index scan