Search Postgresql Archives

Re: Possible causes for database corruption and solutions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Wed, Dec 16, 2009 at 2:05 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote:
Michael Clark wrote:
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
 

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.


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.

Totally agree, not having PG setup properly and expecting the user to not fall into this problem is irresponsible.

I was speaking more generally on the OS level.  How aggressive should we expect an OS to be in a case like this where some responsibility should lie with the user. 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux