Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Smith
Subject Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
Date
Msg-id 20050221183843.70786.qmail@web14127.mail.yahoo.com
Whole thread Raw
Responses Re: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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'

pgsql-admin by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: pg_clog corrupt, can't start postgres
Next
From: Tom Lane
Date:
Subject: Re: pg_clog corrupt, can't start postgres