Thread: binary decode

I'm working on a decoder to take a raw main/base file and given table format
parameters to pull out relevant data.

My question is whether anyone has developed such a tool. Something that
takes the raw file and table format as input and creates an ascii dump
(similar to pgdump).

The purpose is to pull valid data out of raw postregsql files in order to
work on a recovery from a bad disk corruption which resulted in the database
being irreparable.

On Sat, Dec 22, 2007 at 02:07:28AM -0500, Francisco wrote:
> I'm working on a decoder to take a raw main/base file and given table format
> parameters to pull out relevant data.
>
> My question is whether anyone has developed such a tool. Something that
> takes the raw file and table format as input and creates an ascii dump
> (similar to pgdump).

Yes, I wrote a program called pgfsck years ago which did this. Not for
all data types, but most of the common ones. I'm in the process up
upgrading it work with the latest versions.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy