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

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

pgsql-admin by date

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

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