"Anton Maksimenkov" <anton200@gmail.com> writes:
> But I tried
> # su -l _postgresql
> $ postgres -D /var/postgresql/data/ -P billing
> FATAL: catalog is missing 1 attribute(s) for relid 2662
In that case I'm afraid you're stuck: it looks like it's not just the
index but the underlying catalog that's lost data. Were you running
with fsync off by any chance?
For forensic purposes it might be interesting to dump out the
pg_attribute catalog (file 1249) with pg_filedump, just to see what sort
of corruption is there. But I'm afraid the odds of resurrecting the
database are small.
regards, tom lane