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: (view raw or whole 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?



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-2015 The PostgreSQL Global Development Group