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 eith

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 crea

[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 m