> > The vacuum I tried in single user mode failed (froze on a
> > table, for over 20 minutes) so I killed it.
> 
> Did you destroy indices before vacuum?
> 
	Not all of them, it's a large database and I am trying to get it up
and running asap.

	FYI now when I try to use psql to connect to the database I get this
error:

	bash$ psql cms
	psql: FATAL 1:  cannot find attribute 1 of relation pg_trigger



Fri, 23 Mar 2001 12:38:38 -0600
Matthew <matt@ctlno.com>
RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!
Matthew <matt@ctlno.com> writes:
> 	FYI now when I try to use psql to connect to the database I get this
> error:
> 	bash$ psql cms
> 	psql: FATAL 1:  cannot find attribute 1 of relation pg_trigger

So the indexes on pg_attribute are hosed too.  I wonder whether that was
the original source of the problem, and the rest of this is
side-effects?

I am starting to think that you'd best initdb and reload, but there is
one more thing to try: run REINDEX on the whole database in standalone
mode.  See the documentation for the procedure; I'm not too clear on it
since I've never had to do it myself.

			regards, tom lane

Fri, 23 Mar 2001 13:51:35 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.0.3 _bt_restscan: my bits moved right off the end of the world!
> -----Original Message-----
> From: Matthew
>
> > > The vacuum I tried in single user mode failed (froze on a
> > > table, for over 20 minutes) so I killed it.
> >
> > Did you destroy indices before vacuum?
> >
> 	Not all of them, it's a large database and I am trying to get it up
> and running asap.
>
> 	FYI now when I try to use psql to connect to the database I get this
> error:
>
> 	bash$ psql cms
> 	psql: FATAL 1:  cannot find attribute 1 of relation pg_trigger
>

Please try the following query under standalone postgres(with -P and -O
options).

select * from pg_attribute where attrelid=1219 and attnum=1;

If you would get no result, your pg_attribute is corrupted unfortunately.

regards,
Hiroshi Inoue


Sat, 24 Mar 2001 07:56:17 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!