Re: Possible causes for database corruption and solutions
От | Greg Smith |
---|---|
Тема | Re: Possible causes for database corruption and solutions |
Дата | |
Msg-id | 4B292F88.5060903@2ndquadrant.com обсуждение исходный текст |
Ответ на | Re: Possible causes for database corruption and solutions (Michael Clark <codingninja@gmail.com>) |
Ответы |
Re: Possible causes for database corruption and solutions
|
Список | pgsql-general |
Michael Clark wrote:
Sure, but the point is that if your database will get corrupted if that doesn't happen, that's a mistake because sooner or later every such portable system is going to end up there and not get plugged in on time.
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith <greg@2ndquadrant.com> wrote:Florian Weimer wrote:I've never heard of such a thing. The best you can do is try to push the system into hibernation instead of going down hard. That *should* clear any disk caches as part of the graceful shutdown. But you're relying on a relatively fragile system now, once the battery is quite low who knows if that will even execute in the window of time you have left.I hope that Mac OS X turns off write caches on low battery.
And at this point it is not unreasonable to expect the user to perform some sort of action. Shutdown before the power completely dies, or plug in the power.
Sure, but the point is that if your database will get corrupted if that doesn't happen, that's a mistake because sooner or later every such portable system is going to end up there and not get plugged in on time.
-- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.com
В списке pgsql-general по дате отправления: