Re: why not kill -9 postmaster

what type of start up script are you talking about here?

On 10/21/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Ian Harding" <iharding(at)destinydata(dot)com> writes:
> > On 10/20/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>