"Anton Maksimenkov" <anton200@xxxxxxxxx> 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
