To recover data corrupted

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===

Responses

Browse pgsql-general by date

  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?