<br /><br /><div class="gmail_quote">2009/10/23 João Eugenio Marynowski <span dir="ltr"><<a
href="mailto:joaoem@gmail.com"target="_blank">joaoem@gmail.com</a>></span><br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="gmail_quote"></div>Ithought this would solve my problems but not yet ...<br />the block that I found is not
presentingerror...<br /> find_bad_block <br />----------------<br /> (514708,16)<br />(1 registro)<br /> blockId /
blocks_per_chunk= 514708 / 131072 = 3,9269104<br /> base/21058/21271.3 <br />chunk_block_id = block_id %
blocks_per_chunk= 514708 % 131072 = 121492<br />is attached the result of pg_filedump -if -R 121492
/var/lib/postgresql/8.2/main/base/21058/21271.3<br/>Even then I filled the block with zero<br /> But when I run again
thefind_bad_block it show one block before, ctid 514707, and then, 514706 and I stop...<br />Any suggestion and
explication?<br/><br clear="all" />--<br /><font color="#888888">João Eugenio<br /></font></blockquote></div><br />I
fondmanually a record with error (462813,13) and zeroed it and the BD work ok only with 18 register lost that will be
recoveryfrom old backup.<br />The function find_bad_block ( <a
href="http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php">http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php</a>
)<br/> don't work for me, anybody know why?<br /><br />Thanks for now!<br /><br clear="all" />--<br />João Eugenio
Marynowski<br/><br /><br />