Re: why not kill -9 postmaster - Mailing list pgsql-general

From Tom Lane
Subject Re: why not kill -9 postmaster
Date
Msg-id 21208.1161403352@sss.pgh.pa.us
Whole thread Raw
In response to Re: why not kill -9 postmaster  ("Ian Harding" <iharding@destinydata.com>)
Responses Re: why not kill -9 postmaster
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Overload after some minutes, please help!
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: old duplicate emails