Database recovery after fs crash

From: J(dot)Henning(at)t-online(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Database recovery after fs crash
Date: 2003-08-25 21:12:20
Message-ID: 4719.213.252.135.82.1061845940.squirrel@vds.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've got a serious problem. After a horrible filesystem crash the only thing
left of my database are some files in /lost+found (with changed names!). Is
there a way to recover the data from those files? I managed to identify the
files belonging to PostgreSQL (unfortunately, these are part of more than one
database (think of template0/1...)), but I don't know which file belongs to
which table.
I've searched the web for recovery tools but none of them seems capable of
what I want to do. Is there any documentation on the structure of
PostgreSQL's
database files?
If this is the wrong place to ask, please tell me where I might get help.

Cheers,
Christian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory S. Williamson 2003-08-25 21:28:10
Previous Message Tom Lane 2003-08-25 21:09:19 Re: Replication Ideas