On Sun, Oct 11, 2015 at 8:54 AM, Ali Akbar <the.apaan@gmail.com <mailto:the.apaan@gmail.com>> wrote: > C:\Windows\system32>taskkill /F /PID 2080 > SUCCESS: The process with PID 2080 has been terminated.
It does. If you want a "gracefull kill" on Windows, you must use "pg_ctl kill" which can send an "emulated term-signal".
Nevertheless, we'd like a hard crash of a backend other than the postmaster not to have worse effects than on *nix, where killing a backend even with SIGKILL doesn't halt the server:
Oh, absolutely. I was just pointing out that something like taskill *should* result in a hard restart of *all* backends, and if you want to kill off just the one you should never use it, you should instead use pg_ctl kill. But of course, none of those two should lead to the scenario explained here where it does not come back up again.