> > No, WAL does help, cause you can then pull in your last dump and recover > > up to the moment that power cable was pulled out of the wall ... > > False, on so many counts I can't list them all. Why? If we're not talking hardware damage and you have a dump made sometime previous to the crash, why wouldn't that work to restore the database? I've had to restore a corrupted database from a dump before, there wasn't any hardware damage, the database (more specifically the indexes) were corrupted. Of course WAL wasn't around but I don't see why this wouldn't work... Note I'm not saying you're wrong, just asking that you explain your comment a little more. If WAL can't be used to help recover from crashes where database corruption occurs, what good is it? -Mitch
- Re: [HACKERS] beta testing version The Hermit Hacker
- Re: [HACKERS] beta testing version xuyifeng
- Re: [HACKERS] beta testing version Nathan Myers
- Re: [HACKERS] beta testing version Hannu Krosing
- Re: [HACKERS] beta testing version Horst Herb
- Re: [HACKERS] beta testing version Alain Toussaint
- Re: [HACKERS] beta testing version The Hermit Hacker
- Re: [HACKERS] beta testing version Don Baccus
- Re: [HACKERS] beta testing version The Hermit Hacker
- Re: [HACKERS] beta testing version Nathan Myers
- Re: [HACKERS] beta testing version Mitch Vincent
- Re: [HACKERS] beta testing version Nathan Myers
- Re: [HACKERS] beta testing version Don Baccus
- Re: [HACKERS] beta testing version Vadim Mikheev
- Re: [HACKERS] beta testing version Nathan Myers
- Re: [HACKERS] beta testing version Philip Warner
- Re: [HACKERS] beta testing version Nathan Myers
- Re: [HACKERS] beta testing version Tom Lane
- Re: [HACKERS] beta testing version Don Baccus
- Re: [HACKERS] beta testing version Don Baccus
- Re: [HACKERS] beta testing version Vadim Mikheev