Re: why not kill -9 postmaster

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.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.