RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
От | The Hermit Hacker |
---|---|
Тема | RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ... |
Дата | |
Msg-id | Pine.BSF.4.21.0009261737390.4209-100000@thelab.hub.org обсуждение исходный текст |
Ответ на | RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ... ("Hiroshi Inoue" <Inoue@tpf.co.jp>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: