Re: pid gets overwritten in OSX

Francois Suter wrote:
> Hi,
>
> I'm running Postgres on Mac OSX (10.1.4). Every once in a while, I
> get the following problem: for some reason the postmaster seems to
> stop running postgres. When I look at the pid attributed to postgres
> (in postmaster.pid) and check it against ps -aux, I see that either
> the process doesn't exist anymore or that it has been overwritten by
> some other program (e.g. MySQL). It's not a big problem since it is
> enough to restart for the pids to get sorted (just once the problem
> happened twice in a row), but does anyone have an idea how I could
> avoid this?

That is strange.  The odds that a pid would get reused by another
long-running program, and that it would be another database, is very
small.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026