Re: corrupt data
От | Robert Treat |
---|---|
Тема | Re: corrupt data |
Дата | |
Msg-id | 1057967403.24304.2052.camel@camel обсуждение исходный текст |
Ответ на | corrupt data ("Zeno R.R. Davatz" <zdavatz@ywesee.com>) |
Ответы |
corrupt data - caused by lm-sensors?
|
Список | pgsql-admin |
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. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-admin по дате отправления: