Re: pid gets overwritten in OSX - Mailing list pgsql-general

From Bruce Momjian
Subject Re: pid gets overwritten in OSX
Date
Msg-id 200204251544.g3PFinp17743@candle.pha.pa.us
Whole thread Raw
In response to pid gets overwritten in OSX  (Francois Suter <dba@paragraf.ch>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: No long-lived transaction, still can't delete tuples
Next
From: Masaru Sugawara
Date:
Subject: Re: group by with multiple selects having different where conditions