Re: how to terminate a process when kill fails - Mailing list pgsql-general

From Tom Lane
Subject Re: how to terminate a process when kill fails
Date
Msg-id 500.1036003966@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to terminate a process when kill fails  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Mike Mascari <mascarm@mascari.com> writes:
> This scenario was fixed a long time ago (7.1?). The whole 'Don't kill
> -9 the postmaster' comment was actually a tongue-in-cheek remark
> by me regarding a parallel discussion of RedHat init scripts.
> The corruption possibility has long-since been fixed. Since I've
> seen FUD claiming PostgreSQL doesn't have sufficient
> crash-recovery because of the tip, I suggest the tip be changed to:
> 'Feel free to kill -9 the postmaster'

Yes, that TIP is very long obsolete.   However, kill -9 is still not
the *preferred* way to shut down the postmaster ;-).  You don't get
a checkpoint, and in some cases the shared memory block may not get
recycled when you try to restart the postmaster, leading to serious
memory wastage.

I'd suggest we just remove that TIP from the set of possible messages...

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: permission prob: granted, but still denied
Next
From: Richard Huxton
Date:
Subject: Re: newbie question for return date