corrupt table

From: Brandon Metcalf <bmetcalf(at)nortelnetworks(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: corrupt table
Date: 2005-01-31 14:52:19
Message-ID: Pine.LNX.4.58L.0501310847510.1039@cash.rhiamet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm seeing the following with one of our tables:

db=> select * from diskmon.vob_usage;
ERROR: _mdfd_getrelnfd: cannot open relation vob_usage: No such file or directory

This is running under 7.3.3. I'm not sure how this occurred. Is this table
completely trashed or is there something that can done to recover it?

Thanks.

--
Brandon

Browse pgsql-admin by date

  From Date Subject
Next Message Ben Kim 2005-01-31 16:33:00 relation tmp_pg_shadow already exists
Previous Message Geoffrey 2005-01-31 13:17:38 Re: postgresql-7.4.6-2PGDG.src.rpm broken for Redhat 7,8