corrupt data

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