"Ian Harding" <iharding@xxxxxxxxxxxxxxx> writes: > On 10/20/06, Tom Lane <tgl@xxxxxxxxxxxxx> 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
