Re: Help using pgfsck
От | Vilson farias |
---|---|
Тема | Re: Help using pgfsck |
Дата | |
Msg-id | 014f01c3037d$9880a970$98a0a8c0@dgtac обсуждение исходный текст |
Ответ на | Help using pgfsck ("Vilson farias" <vilson.farias@digitro.com.br>) |
Ответы |
Re: Help using pgfsck
|
Список | pgsql-general |
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. --
В списке pgsql-general по дате отправления: