> -----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