Re: from 6.5 > 7.1, cannot pg_dumpall.

Patrick Coulombe <pcoulombe(at)mediacces(dot)com> writes:
> what about if i drop it, and then vacuum or look into this table for null
> value and other bad data. and after recreate it ?

Sorry, I guess I wasn't clear: that's what I meant you to do. I'd
actually not bother with recreating the index at all, at least not
till you've gotten your data moved over to 7.1.

> it's safe to vacuum my bd after dropping an index ?

Sure. The data in the table is all you should care about at this point.

However, I think you should resign yourself to the likelihood that
you've lost data: you've got a pretty badly hosed database there,
it would seem. How recent is your last pg_dump backup?

regards, tom lane