2009/10/23 Dimitri Fontaine <dfonta...@hi-media.com> > João Eugenio Marynowski <joa...@gmail.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
pg_filedump-ctid-514708
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
