| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Anton Maksimenkov" <anton200(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: db crash after power crash |
| Date: | 2006-05-28 21:36:17 |
| Message-ID: | 203.1148852177@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Anton Maksimenkov" <anton200(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-05-28 22:04:31 | Re: The server's LC_CTYPE locale |
| Previous Message | Eci Souji | 2006-05-28 20:13:20 | DB structure for logically similar objects in different states... |