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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026