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