Re: corrupt data

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "Zeno R(dot)R(dot) Davatz" <zdavatz(at)ywesee(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: corrupt data
Date: 2003-07-11 23:45:20
Message-ID: 20030711234520.GB14912@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 11, 2003 at 09:32:12AM +0200, Zeno R.R. Davatz wrote:

> Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we get:
>
> psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
> No such file or directory
>
> REINDEX does not work. We get the same error.

Did you try REINDEX with a standalone backend using -P?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Lo esencial es invisible para los ojos" (A. de Saint Exúpery)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-07-11 23:58:04 Re: This works in 7.2.1, not in 7.3.2
Previous Message Maksim Likharev 2003-07-11 23:12:30 Re: PG crash on simple query, story continues