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

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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Date: 2000-09-26 18:06:50
Message-ID: Pine.BSF.4.21.0009261456510.4209-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: 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(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


Responses

pgsql-hackers by date

Next:From: Lamar OwenDate: 2000-09-26 18:08:45
Subject: Re: [BUGS] 7.0.2 source rpm failed to compile
Previous:From: Lamar OwenDate: 2000-09-26 18:05:39
Subject: Re: 7.0.2 source rpm failed to compile

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