From: | Frederic Massot <frederic(at)juliana-multimedia(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | To recover data corrupted |
Date: | 2006-05-23 11:03:16 |
Message-ID: | e4uq5m$t33$1@floppy.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
We have an old waiter Postgresql 6.5.3 which regularly had problem and
which crashed.
I recovered a large part of the data saved with pg_dump, except that
which were corrupted.
In the directory "/var/lib/postgres/data/base", I found the files which
correspond to the tables corrupted. With a text editor, I can edit these
binary files.
There are the texts and many nonprintable characters :
Ø^(at)ì^@^@ ^@
<94><9F>Ø^@,<9F>Ð^(at)Ž<9E>ð^(at)ì<94>è^Et<93>ð^B<<91>p^Dô<8F><90>^Bä<8C>
^F<9C><83> ^DŽ<88>\<87>°^Bì<85>à^B<80><99>Ð
^A°<98> ^<9E>X^Aà<97> ^AL<9D>x^Ah<9A>p^Dì<80>`^EÌ
^(at)^@ <9C>X^A4^B^(at)^@
^A^(at)^@^L^T^(at)^@l^S^(at)^@Œ^R^(at)^@^L^R^(at)^@\^Q^(at)^@¬^P^(at)^@ü^O^(at)^@<8C>^O^(at)^@^L^O^(at)^@|^N^(at)^@Ü^M^(at)^@,^M^(at)^@|^L^(at)^@È
^K^(at)^@^P^K^(at)^@T
^(at)^@<94>
^(at)^@^(at)^@^(at)^@x^G^(at)^@Œ^F^(at)^@ü^E^(at)^@<^E^(at)^@|^D^(at)^@Œ^C^(at)^@ü^B^(at)^@<^B^(at)^@<80>^]^(at)^@^L^A^(at)^@^(at)^@^(at)^@^(at)^@^(at)^@^(at)^@^@
^(at)^@^(at)^@^(at)^@^(at)^@^(at)À^@<9B>^(at)éŒW^A^@^(at)^@^@<86>UW^A%TÅ^A^(at)^@
^(at)^K^@^O^(at)^B<85> ^@<8C>^(at)^@^(at)^\^@^(at)^@^V^(at)^@^(at)Mr et Mme Perro
nno^(at)^@x^(at)^@^(at)Dans une maison indépendante, située dans un quartier
résidentiel, à 800 mètres des commerces et à 13 Km des
plages(dot)ª^A^(at)^@<br>Appréciation de l'Office de Tourisme : *<br><br>
1 chambre en rez-de-chaussée avec 1 lit 2 personnes avec entrée
indépendante (possibilité couchage 1 personne supplémentaire
). Salle d'eau et WC<br>
Ouvert toute l'année<br>
Do you know how I can recover the data without having to make copy/paste
from the binary file?
Regards.
--
==============================================
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:frederic(at)juliana-multimedia(dot)com |
===========================Debian=GNU/Linux===
From | Date | Subject | |
---|---|---|---|
Next Message | Rafal Pietrak | 2006-05-23 11:15:44 | FUNCTION returns SETOF |
Previous Message | Alban Hertroys | 2006-05-23 10:35:30 | Re: Why won't it index scan? |