Re: postgres under linux can't start because of postmaster.pid - Mailing list pgsql-hackers

From Tom Lane
Subject Re: postgres under linux can't start because of postmaster.pid
Date
Msg-id 15453.1193323178@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres under linux can't start because of postmaster.pid  ("Richard Wang" <ruc_wang@hotmail.com>)
List pgsql-hackers
"Richard Wang" <ruc_wang@hotmail.com> writes:
> 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.

Postgres defends itself against that just fine, at least in any
reasonably recent release.  There are some corner cases where it
could have problems, but scripted hacking on the .pid file is just
about guaranteed to make things worse not better.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: order by in cursor declaration does not allow update
Next
From: Tom Lane
Date:
Subject: Re: MaxOffsetNumber versus MaxHeapTuplesPerPage