"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
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.