Skip site navigation (1) Skip section navigation (2)

hacking data directories

From: elein <elein(at)varlena(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: elein(at)varlena(dot)com
Subject: hacking data directories
Date: 2004-03-29 23:55:22
Message-ID: 20040329155522.E2655@cookie.varlena.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)varlena(dot)com



Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2004-03-30 01:20:53
Subject: Re: hacking data directories
Previous:From: Dann CorbitDate: 2004-03-29 23:34:52
Subject: Win32 compatibility now broken for Microsoft and Intel Windows compilers even for Libpq in current snapshot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group