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
