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

From Harpreet Dhaliwal
Subject Re: why not kill -9 postmaster
Date
Msg-id d86a77ef0610211556u6c2de32bhec7df82f6ab5d9a9@mail.gmail.com
Whole thread Raw
In response to Re: why not kill -9 postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
what type of start up script are you talking about here?

On 10/21/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: brian
Date:
Subject: Re: Column Deletion
Next
From: Tom Lane
Date:
Subject: Re: unstable postgres on freebsd