corrupt data - caused by lm-sensors?
От | Zeno Davatz |
---|---|
Тема | corrupt data - caused by lm-sensors? |
Дата | |
Msg-id | 20030712194301.1623.qmail@debian обсуждение исходный текст |
Ответ на | Re: corrupt data (Robert Treat <xzilla@users.sourceforge.net>) |
Ответы |
Re: corrupt data - caused by lm-sensors?
|
Список | 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
В списке pgsql-admin по дате отправления: