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-28 Thread Bruce Momjian
What operating system and file system? Can I guess Linux/ext2? --- Christian von Kietzell wrote: > Hi, > > I've got a serious problem. After a horrible filesystem crash the only thing > left of my database are some files i

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

Re: [GENERAL] Database recovery after fs crash

2003-08-26 Thread Alvaro Herrera Munoz
On Tue, Aug 26, 2003 at 10:17:48AM +1000, Martijn van Oosterhout wrote: > Wow. Take to pull out those backups... > > Hmm, presumably you don't have those. There are programs to read postgresql > data files however they need to know the exact structure of the table before > you can even start to de

Re: [GENERAL] Database recovery after fs crash

2003-08-26 Thread Martijn van Oosterhout
Wow. Take to pull out those backups... Hmm, presumably you don't have those. There are programs to read postgresql data files however they need to know the exact structure of the table before you can even start to decode them. I usually start by browsing files by hand to see if I can determine fro