Re: How to deal with corrupted database?

From: "Ruslan A(dot) Bondar" <fsat(at)list(dot)ru>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to deal with corrupted database?
Date: 2011-11-09 15:53:50
Message-ID: 20111109195350.51c1b014@list.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


No, this was a clean install of 9.0.x.
Maybe It was upgraded from 9.0.3 to 9.0.4. I'm not sure.

On Wed, 09 Nov 2011 09:21:18 -0600
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

> "Ruslan A. Bondar" <fsat(at)list(dot)ru> wrote:
>
> > ERROR: could not access status of transaction 15892843
> > DETAIL: Could not open file "pg_subtrans/00F2": No such file or
> directory.
>
> > postgres version: 9.0.4
>
> Did you move to 9.0.x using pg_upgrade version 9.0.3 or earlier?
>
> http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
>
> -Kevin
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-11-09 15:57:37 Re: How to deal with corrupted database?
Previous Message Kevin Grittner 2011-11-09 15:48:39 Re: database not using indexes