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, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group