| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Ian Harding" <iharding(at)destinydata(dot)com> |
| Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Shane Ambler" <pgsql(at)007marketing(dot)com>, "Andreas Seltenreich" <andreas+pg(at)gate450(dot)dyndns(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: why not kill -9 postmaster |
| Date: | 2006-10-21 04:02:32 |
| Message-ID: | 21208.1161403352@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory S. Williamson | 2006-10-21 04:08:27 | Re: old duplicate emails |
| Previous Message | Tom Lane | 2006-10-21 03:57:57 | Re: Overload after some minutes, please help! |