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

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