Skip site navigation (1) Skip section navigation (2)

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

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "The Hermit Hacker" <scrappy(at)hub(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Date: 2000-09-26 20:13:48
Message-ID: EKEJJICOHDIEMGPNIFIJIEIMCGAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
> -----Original Message-----
> From: pgsql-hackers-owner(at)hub(dot)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


In response to

Responses

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-09-26 20:38:17
Subject: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Previous:From: Mikheev, VadimDate: 2000-09-26 19:21:53
Subject: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group