RedHat with PG 7.3.2

I'm recovering a harddrive failure where all 
of the database files were thrown into one
directory.  I'm trying to sort out which ones
go with what. (Stop laughing.)

I've identified template1 and template0 files,
but I don't need to recover those...

The rest of the files seem to be database
data files and it is possible the the zero length
files were directories, but I'm not sure.

Does anyone have any tools or hints?  I can
determine a lot by just looking at them, but
hints would help.
If necessary, I could write a little C program
to extract the headers if that is what is 
necessary.

All advice is greatly appreciated.

Thanks,

elein
elein@varlena.com



Mon, 29 Mar 2004 15:55:22 -0800
elein <elein@varlena.com>
hacking data directories
On Mon, Mar 29, 2004 at 03:55:22PM -0800, elein wrote:

> Does anyone have any tools or hints?  I can
> determine a lot by just looking at them, but
> hints would help.
> If necessary, I could write a little C program
> to extract the headers if that is what is 
> necessary.

Try RedHat's pg_filedump, at http://sources.redhat.com/rhdb/

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Use it up, wear it out, make it do, or do without"

Mon, 29 Mar 2004 21:20:53 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: hacking data directories