Re: table corrupted

2009/10/23 Dimitri Fontaine <dfontaine(at)hi-media(dot)com>

> João Eugenio Marynowski <joaoem(at)gmail(dot)com> writes:
> > 2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in
> > block 462821 of relation "..."
>
> It could be that the following will prove helpful:
> http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php
> http://pgsql.tapoueh.org/site/html/news/20080410.badblock.html
>
> Regards,
> --
> dim
>
I thought this would solve my problems but not yet ...
the block that I found is not presenting error...
find_bad_block
----------------
(514708,16)
(1 registro)
blockId / blocks_per_chunk = 514708 / 131072 = 3,9269104
base/21058/21271.3
chunk_block_id = block_id % blocks_per_chunk = 514708 % 131072 = 121492
is attached the result of pg_filedump -if -R 121492
/var/lib/postgresql/8.2/main/base/21058/21271.3
Even then I filled the block with zero
But when I run again the find_bad_block it show one block before, ctid
514707, and then, 514706 and I stop...
Any suggestion and explication?

--
João Eugenio