Postgres Pro
Downloads
Home   >   mailing lists

Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error - Mailing list pgsql-admin

From Tom Lane
Subject Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
Date
Msg-id 2123.1109017522@sss.pgh.pa.us
Whole thread Raw
In response to Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error  (Christopher Smith <christopherl_smith@yahoo.com>)
Responses Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error  (Christopher Smith <christopherl_smith@yahoo.com>)
List pgsql-admin
Tree view 
Christopher Smith <christopherl_smith@yahoo.com> writes:
> ERROR:  _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error

This is a hardware failure: your disk drive has dropped some sectors.
I don't think you can do anything about it except go back to your last
backup :-(

Oh, and buy a new disk ASAP, before you lose any more data ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_clog corrupt, can't start postgres
Next
From: Geoffrey
Date:
Subject: 64 bit rpms for 7.4.7??