Re: [GENERAL] Database recovery after fs crash

2003-08-28 Thread J . Henning
How do I do that? I don't know the format of the clog files. The only information I found was in clog.h and xlog.h. xlog is fairly easy, I think resetxlog or something can work there. For clog I just noted from the logs which clog files it was missing and created them filled with either 0x00

Re: [GENERAL] Database recovery after fs crash

2003-08-26 Thread J . Henning
Hmm, presumably you don't have those. Unfortunately not. All backup measures I took failed on the exact same occasion - worst case possible. I usually start by browsing files by hand to see if I can determine from any embedded text which table it was. Seems easy enough. Then if you create

[GENERAL] Database recovery after fs crash

2003-08-25 Thread J . Henning
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