Re: Help using pgfsck

Mr. Oosterhout,

  it's been very hard to deal with this database error. Since my knowledge
in perl is null I think it's easier to edit database files manually.

  Could you or someone here in pgsql-general tell me where can I find more
information about database files and how to edit? Pgfsck gives me valuable
information, but I don't know how to access and change pages it reports me.


bash$ ./pgfsck -D $(pwd) bxs cham_chamada > r
bash$ cat r
-- Detected database format 7.1
-- Scanning table cham_chamada
-- Table pg_class(1259):Page 0:Tuple 64: Unknown type _aclitem (1034)
-- Table pg_class(1259):Page 1:Tuple 0: Unknown type _aclitem (1034)
...
-- Table cham_chamada(19597):Page 876:Tuple 25: Decoding tuple runs off end:
4168 > 104
>>01 00 00 00 07 00 00 00 09 00 00 00 00 00 00 90 8E 06 95 41 00 00 00 00 0A
00 00 00 0C 00 00 00 33 32 31 34 38 33 35 35 0
0 00 00 C4 8E 06 95 41 03 00 00 00 00 00 00 00 10 00 00 00 30 32 33 31 38 33
34 31 31 35 34 30 05 00 00 00 31 00 00 00 05 0
0 00 00 30 00 00 00 00 00 00 00 3D 00 00 00 00 00 00 00 02 01 00 00 00 00 00
00 07 00 00 00
-- Table cham_chamada(19597):Page 968:Tuple 30: Tuple incorrect length
(parsed data=116,length=112)
-- Table cham_chamada(19597):Page 1862:Tuple 31: Decoding tuple runs off
end: 4176 > 104


Thanks in advance.

>>Yeah, sorry about that. I couldn't work out how datetimes and timestamps
>>were stored in the file so I never got round to adding them. As you can
see
>>they look about 5 bytes in width. If you can work it out there is a
section
>>near the front of the program that does the data type conversions. Add it
>>there and it should dump properly.
--