From: | "Zeno Davatz" <zdavatz(at)ywesee(dot)com> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | corrupt data - caused by lm-sensors? |
Date: | 2003-07-12 19:43:01 |
Message-ID: | 20030712194301.1623.qmail@debian |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Robert Treat writes:
> On Fri, 2003-07-11 at 01:58, Zeno R.R. Davatz wrote:
>> Hi List
>>
>> 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.
>>
>> pgfsck gives us: wrong blockseize.
>>
>> We are using postgresql 7.3.3-1 (debian).
>>
>
> uh oh, sounds like you might have some flakey hardware.
>
> try vacuumdb template1 and if that gets you in you might want to do a
> pg_dump and then do some hardware testing.
Thanks for the hint. 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 | D A Bridge | 2003-07-12 21:32:39 | Hello, Pgsql-admin! |
Previous Message | weigelt | 2003-07-12 10:10:56 | Re: xml output |