Re: db crash after power crash

"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