Re: beta testing version

Поиск
Список
Период
Сортировка
Искать
От
Mitch Vincent
Тема
Re: beta testing version
Дата
Msg-id
01c901c05b37$55e67770$0200000a@windows
Список
Дерево обсуждения
Re: Please advise features in 7.1 (SUMMARY) Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: Please advise features in 7.1 (SUMMARY) Don Baccus <dhogaza@pacifier.com>
Re: Please advise features in 7.1 (SUMMARY) Andrew Snow <als@fl.net.au>
> > 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


В списке pgsql-hackers по дате отправления
От: ncm@zembu.com (Nathan Myers)
Дата:
Сообщение: Re: beta testing version
От: The Hermit Hacker
Дата:
Сообщение: Re: beta testing version
FAQ