On Fri, 2003-07-11 at 01:58, Zeno R.R. Davatz wrote: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).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.
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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
