> From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
>> Kill -9 is the "shoot it in the head" signal. It is not
>> generated by postgresql in normal operation. It can be
>> generated by "pg_ctl -m immediate stop" . At least I think
>> that's what signal it sends.
Just for the archives: Postgres never generates kill -9 at all.
(Immediate stop uses SIGQUIT, instead.) When you see that in
the log, you can be sure it was a manual action or the OOM killer.
regards, tom lane