Forgot your password?
typodupeerror

Comment: "Don't kill -9 postmaster" is NOT about power loss (Score 1) 456

by tgl (#24315605) Attached to: Why Power Failures Can Always Lead To Data Loss

I lost faith that this guy knows what he's talking about when I read this:

> The PostgreSQL mailinglist doesn't have "don't kill -9 the postmaster!" as a standard signature to list messages for nothing.

Indeed that is standard advice, but it has NOTHING WHATSOEVER to do with power failure recoverability. The reason you're not supposed to do it is that hard-killing the postmaster doesn't get rid of its subprocesses or shared memory segment, which could make a subsequent attempt to restart the postmaster hazardous. But those things won't survive a system crash due to power loss (or any other reason).

I'm not really qualified to evaluate all the other statements in the article, but the fact that the one statement I do know about is hogwash doesn't make me feel good about the others.

"The greatest warriors are the ones who fight for peace." -- Holly Near

Working...