Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error

From: Christopher Smith <christopherl_smith(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
Date: 2005-02-21 18:38:43
Message-ID: 20050221183843.70786.qmail@web14127.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Emergency: I have a 200+ million row zip code radius table that has recently gone haywire.

I cannot access it and get the following error code

ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error

My environment.

Postgresql 7.3.2
OS: Redhat Linux 7.2

Any ideas to fix this...

Thanks.


---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-02-21 20:19:43 Re: pg_clog corrupt, can't start postgres
Previous Message Anjan Dave 2005-02-21 17:44:50 Re: pg_clog corrupt, can't start postgres