Re: why not kill -9 postmaster

"Ian Harding" <iharding@destinydata.com> writes:
> On 10/20/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Personally I think the TIP that's really needed is "never remove
>> postmaster.pid by hand".

> When the machine crashes, don't you have to remove the pid file by
> hand to get the Postgres to start?  I seem to remember having to do
> that....

Given a properly written startup script and a reasonably recent
postmaster, that shouldn't be necessary.  In any case, retrying the
startup script is a *far* safer habit to develop than manually removing
the pidfile (and putting an "rm" into the script itself is folly of the
first magnitude).

            regards, tom lane