Re: BUG #5976: Corrupted pages on the production database - Mailing list pgsql-bugs

From Vlad Arkhipov
Subject Re: BUG #5976: Corrupted pages on the production database
Date
Msg-id 4DA5A011.4030007@dc.baikal.ru
Whole thread Raw
In response to Re: BUG #5976: Corrupted pages on the production database  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
13.04.2011 20:48, Kevin Grittner wrote:
> "Vlad Arkhipov"  wrote:
>
>
>> PostgreSQL version: 9.0.3
>>
>
>
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR: could not access status
>> of transaction 3499806839
>> DETAIL: Could not open file "pg_clog/0D09": No such file or
>> directory.
>>
>
> Did you get to 9.0 using pg_upgrade?
>
> http://archives.postgresql.org/pgsql-announce/2011-04/msg00007.php
>
> -Kevin
>
>
No. We have upgraded to 9.0 several months ago and daily pg_dump worked
well until 10 April 2011. Also the corrupted table truncates and filled
with data every hour, so pg_upgrade could not affect it.

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5976: Corrupted pages on the production database
Next
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] PostgreSQL backend process high memory usage issue