"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Thu, 2007-01-04 at 10:00 -0500, Tom Lane wrote: >> "Simon Riggs" <[EMAIL PROTECTED]> writes: >>> Recovery can occur with/without same setting of wal_checksum, to avoid >>> complications from crashes immediately after turning GUC on. >> >> Surely not. Otherwise even the "on" setting is not really a defense.
> Only when the CRC is exactly zero, which happens very very rarely. "It works most of the time" doesn't exactly satisfy me. What's the use-case for changing the variable on the fly anyway? Seems a better solution is just to lock down the setting at postmaster start. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend