Thread: RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!

RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!

From
Matthew
Date:
> > 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 cmspsql: FATAL 1:  cannot find attribute 1 of relation pg_trigger




RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world!

From
"Hiroshi Inoue"
Date:
> -----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