Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group