| From: | "Zeno Davatz" <zdavatz(at)ywesee(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: corrupt data |
| Date: | 2003-07-12 19:47:16 |
| Message-ID: | 20030712194716.1703.qmail@debian |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera writes:
> On Fri, Jul 11, 2003 at 09:32:12AM +0200, Zeno R.R. Davatz wrote:
>
>> Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we get:
>>
>> psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
>> No such file or directory
>>
>> REINDEX does not work. We get the same error.
>
> Did you try REINDEX with a standalone backend using -P?
Thanks for the hint - we tried that but still could not connect to the
database. In the meantime we could get access to some data with pgfsck 0.14
- great tool, great maintainer, very dedicated (Tom Lane says pgfsck does
not exist).
What I forgot to mention:
I installed lm-sensors (cvs) version and force-loaded some drivers. Then
sensors-detect gave me a segmentation fault. Do you think that could have
caused the data-corruption?
Thanks for feedback.
Zeno
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond | 2003-07-12 20:22:01 | Insert Updates Deletes on Views; Triggers on System Tables |
| Previous Message | Jim C. Nasby | 2003-07-12 15:42:46 | Re: PL/pgSQL CASE Support |