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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Richard Wang" <ruc_wang(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgres under linux can't start because of postmaster.pid
Date: 2007-10-25 14:39:38
Message-ID: 15453.1193323178@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Richard Wang" <ruc_wang(at)hotmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-10-25 14:45:55 pgsql: Extract catalog info for error reporting before an error actually
Previous Message Tom Lane 2007-10-25 14:21:41 Re: order by in cursor declaration does not allow update