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

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;
backend> 

still get it ...

I'm either doing something wrong with REINDEXng the system tables, or this
isn't what hte problem is :(

v7.0.2+ database being run ...

Help? :(

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