hacking data directories

Started by eleinalmost 22 years ago2 messages
#1elein
elein@varlena.com

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

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: elein (#1)
Re: 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"