Re: [BUGS] BUG #5976: Corrupted pages on the production database

2011-04-13 Thread Vlad Arkhipov
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 directo

Re: [BUGS] BUG #5976: Corrupted pages on the production database

2011-04-13 Thread Kevin Grittner
"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?

Re: [BUGS] BUG #5976: Corrupted pages on the production database

2011-04-12 Thread Heikki Linnakangas
On 13.04.2011 06:52, Vlad Arkhipov wrote: There is also a stand-by server (streaming replication) which does not have this error. I've elaborated on this issue a bit and found 2 corrupted pages in the file of relation. The first one is semi-corrupted, one half of it is correct, but another part c