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

[Hiroshi Inoue]

> -----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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html