Re: Server Crash

On Tue, Apr 22, 2008 at 10:06 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > 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.

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