Re: corrupt data

On Fri, 11 Jul 2003, 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).
>
> Thanks for any hints and feedback.

Sounds like a bad block on the hard drive maybe?

Maybe bad ram.

You should probably test the drive and memory for errors.

Can you backup parts of the database?  I.e. recover most in place and then
restore the parts you can't from backups...