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

Tom is looking around the server right now, as he wants to try and see
what caused it before we go any further at trying to fix it, but I hadn't
thought to try FORCE ... thanks :)



On Wed, 27 Sep 2000, Hiroshi Inoue wrote:

> > -----Original Message-----
> > From: pgsql-hackers-owner@hub.org
> > The Hermit Hacker
> >
> > Can someone add something to the docs that gives an example of what should
> > be used from the command line to reindex a database's system tables?
> >
> > All the man page says is use th e-O an d-P options :(
> >
> > I'm getting:
> >
> > psql -h pgsql horde
> > ERROR:  cannot read block 6 of pg_attribute_relid_attnam_index
> > Welcome to psql, the PostgreSQL interactive terminal.
> >
> > Type:  \copyright for distribution terms
> >        \h for help with SQL commands
> >        \? for help on internal slash commands
> >        \g or terminate with semicolon to execute query
> >        \q to quit
> >
> > horde=> \d
> > ERROR:  SearchSysCache: recursive use of cache 4
> > horde=> \q
> >
> > 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;
> 
> Maybe you have to add FORCE option i.e.
>     reindex database horde force;
> 
> Regards.
> 
> Hiroshi Inoue
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org