Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 263DC18055C7
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  9 Nov 2011 11:53:24 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 29930-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  9 Nov 2011 15:53:15 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from smtp28.mail.ru (smtp28.mail.ru [94.100.176.181])
	by mail.postgresql.org (Postfix) with ESMTP id CF97C18055C6
	for <pgsql-admin@postgresql.org>; Wed,  9 Nov 2011 11:53:14 -0400 (AST)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru;
	s=mail;
	h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:In-Reply-To:Message-ID:Subject:Cc:To:From:Date;
	bh=K7GqPV9wUa0g6a0d8qtw4xsXwOSvSQbx9Se41H1PNgQ=;
	b=31dg3DYPwa0AP9g1xyi4XkqFbMQ/oTJXXOSDdzXogasgEdyToF8uHtB5AjusF+TefTLXO6KB3Sm3J9feHphql+iglRNzSoyezeipdiJBSMEJBOWS8LV7inNS5NWyZgCt;
Received: from [95.174.102.250] (port=6528 helo=localhost)
	by smtp28.mail.ru with asmtp
	id 1ROASf-0006eM-00; Wed, 09 Nov 2011 19:53:13 +0400
Date: Wed, 9 Nov 2011 19:53:50 +0400
From: "Ruslan A. Bondar" <fsat@list.ru>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: How to deal with corrupted database?
Message-ID: <20111109195350.51c1b014@list.ru>
In-Reply-To: <4EBA460E0200002500042BCD@gw.wicourts.gov>
References: <20111109150225.076c2f38@list.ru>
	<4EBA460E0200002500042BCD@gw.wicourts.gov>
X-Mailer: Claws Mail 3.7.10 (GTK+ 2.24.6; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Spam: Not detected
X-Mras: Ok
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201111/31
X-Sequence-Number: 38625


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.Grittner@wicourts.gov> wrote:

> "Ruslan A. Bondar" <fsat@list.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
>