binary decode

Started by Franciscoabout 18 years ago2 messages
#1Francisco
fxd@295.ca

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.

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Francisco (#1)
Re: binary decode

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/

Show quoted text

Those who make peaceful revolution impossible will make violent revolution inevitable.
-- John F Kennedy