Piotr Gasidło wrote:
I _can_ afford of loosing some data in case of power failure. But I'm
afraid of having database in unrecoverable state after crash.
Then turn off synchronous_commit. That's exactly the behavior you get
when it's disabled: some data loss after a crash, no risk of datab
On Wed, Feb 16, 2011 at 04:40:43PM +0100, Piotr Gasidło wrote:
> Is it safe, to have RAID controller (not BBC) write cache _enabled_
> for disks where data are stored and write cache _disabled_ for disks
> where WAL segments are stored?
No.
> I _can_ afford of loosing some data in case of powe
Hello,
Is it safe, to have RAID controller (not BBC) write cache _enabled_
for disks where data are stored and write cache _disabled_ for disks
where WAL segments are stored?
I _can_ afford of loosing some data in case of power failure. But I'm
afraid of having database in unrecoverable state afte