RelationBuildDesc Notice (corrupt DB?)

From: "Tony Harper" <trharper5(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: RelationBuildDesc Notice (corrupt DB?)
Date: 2003-04-03 12:57:05
Message-ID: b6hb2u$193v$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

DB appears to be corrupted but cannot isolate cause, it has happened
multiple times after recreating database. The system seems stable otherwise

The message when trying to do
psql name_of_database:
NOTICE: RelationBuildDesc: can't open pg_statistic: No such file or
directory
ERROR: cannot open pg_statistic: No such file or directory

if I do a \d
The message is:
cannot open pg_statistic: No such file or directory

if I do a verbose vacuum, things go fine till the end....a sample:
NOTICE: RelationBuildDesc: can't open pg_group: No such file or directory
NOTICE: RelationBuildDesc: can't open pg_group_name_index: No such file or
directory
NOTICE: RelationBuildDesc: can't open pg_group_sysid_index: No such file or
directory
Error: _mdfd_getreInfd: cannot open relation pg_group: No such file or
director

if I do a REINDEX from a backend:
NOTICE: RelationBuildDesc: can't open pg_group: No such file or directory
NOTICE: RelationBuildDesc: can't open pg_inherits: No such file or
directory
NOTICE: RelationBuildDesc: can't open pg_inherits_rlid_seqno_index: No such
file or directory

Anyone know what the real issue is or how to fix?

Thanks,

TRH

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-04-03 12:59:21 Re: images in database
Previous Message Pep 2003-04-03 12:46:33 Re: Anyone know of a news group for mysql?