Re: [HACKERS] Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

2000-09-26 Thread Tom Lane
It looks like you are suffering from actual hardware failures: %cd /pgsql/data/base/horde %ls -l pg_attribute_relid_attnam_index -rw--- 1 pgsql pgsql 65536 Aug 21 12:27 pg_attribute_relid_attnam_index %wc pg_attribute_relid_attnam_index wc: pg_attribute_relid_attnam_index: read: Input/outp

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

2000-09-26 Thread Hiroshi Inoue
> -Original Message- > From: [EMAIL PROTECTED] > 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

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

2000-09-26 Thread Mikheev, Vadim
> 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 > tab

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

2000-09-26 Thread 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