corrupt table - Mailing list pgsql-admin

From Brandon Metcalf
Subject corrupt table
Date
Msg-id Pine.LNX.4.58L.0501310847510.1039@cash.rhiamet.com
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: Geoffrey
Date:
Subject: Re: postgresql-7.4.6-2PGDG.src.rpm broken for Redhat 7,8
Next
From: Ben Kim
Date:
Subject: relation tmp_pg_shadow already exists