Francois Suter sez:
} 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?
You'll have to provide more information. I am running OSX 10.1.4 and both
PostgreSQL 7.1.2 and MySQL and I have never seen any such behavior. The
only way I could even imagine them interacting is if you are trying to use
the same directory for both, and even then it shouldn't happen since MySQL
and PostgreSQL use different naming schemes for their pid files.
Is it possible that PostgreSQL isn't coming up after a reboot and the pid
file just happens to have an old pid from the last boot?
} Thanks.
} François
--Greg