Re: Server Crash

On Tue, Apr 22, 2008 at 10:06 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > From: Scott Marlowe [mailto:scott.marlowe@gmail.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.

Thanks.  Just wondering, what's the difference in behavior from
pgsql's perspective from sigquit and siqkill?  Is sigkill more
dangerous than sigquit?