Обсуждение: corrupt data
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). Thanks for any hints and feedback. Zeno
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? -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Lo esencial es invisible para los ojos" (A. de Saint Exúpery)
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