Re: postgres under linux can't start because of postmaster.pid

I just consider this may happens and pg can't recover correctly:
if postgres crashed last time and left a postmaster.pid file, and last
postgres
id is reused by another process which is not postgres now.

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> :29598(dot)1193228404(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "Richard Wang" <ruc_wang(at)hotmail(dot)com> writes:
>> I construct a postmaster.pid file and then set the pid to be one of
>> existing
>> process id(not postgres, e.g vim), then I run postgres. This may happen
>> if
>> postgres crashed last time and left a postmaster.pid file, and last
>> postgres
>> id is reused by another process which is not postgres now.
>
> Don't do that. The postmaster is perfectly capable of recovering on
> its own, why would you want to mess with the postmaster.pid file?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>