X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A4FED8B9B3F for ; Mon, 21 Feb 2005 18:38:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74561-10 for ; Mon, 21 Feb 2005 18:38:47 +0000 (GMT) Received: from web14127.mail.yahoo.com (web14127.mail.yahoo.com [66.163.171.118]) by svr1.postgresql.org (Postfix) with SMTP id 939628B9B57 for ; Mon, 21 Feb 2005 18:38:44 +0000 (GMT) Received: (qmail 70788 invoked by uid 60001); 21 Feb 2005 18:38:43 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Kk4XBX6Unx+57oRAOPUdVXuDyTndi31Z5Oi9p/NX5Vwt93ezfq2IiQg0e2FWXfwLmbpnvaNAYeAB/wf4HbUGKwF7MfJohon4iOdAmSk/K+LcOZZU96PXsVn80gz5wjCoGfvbsnrYQounBWWbYwY7VCJFEGq/Xuwt5bzJFXtWu/4= ; Message-ID: <20050221183843.70786.qmail@web14127.mail.yahoo.com> Received: from [65.4.200.58] by web14127.mail.yahoo.com via HTTP; Mon, 21 Feb 2005 10:38:43 PST Date: Mon, 21 Feb 2005 10:38:43 -0800 (PST) From: Christopher Smith Subject: Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-454306377-1109011123=:68786" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.461 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/196 X-Sequence-Number: 16364 --0-454306377-1109011123=:68786 Content-Type: text/plain; charset=us-ascii 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' --0-454306377-1109011123=:68786 Content-Type: text/html; charset=us-ascii
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' --0-454306377-1109011123=:68786--