Alvaro Herrera <alvherre@commandprompt.com> writes:
> Shane Ambler wrote:
>> The one thing worse than kill -9 the postmaster is pulling the power
>> cord out of the server. Which is what makes UPS's so good.
>>
>> If your server is changing the data file on disk and you pull the power
>> cord, what chance do you expect of reading that data file again?
> 1. That's what we have WAL for. The only thing that can really kill
> you is the use of non-battery-backed write cache.
The important distinction here is "will you lose data" vs "can you start
a new server without tedious manual intervention" (ipcrm etc). kill -9
won't lose data, but you may have to clean up after it. And, as Andreas
already noted, some people have been seen to mess up the manual
intervention part badly enough to cause data loss by themselves.
Personally I think the TIP that's really needed is "never remove
postmaster.pid by hand".
regards, tom lane