Re: pid gets overwritten in OSX

>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.

No, I'm definitely not using the same directory for both. As for more
info, I'm using Postgres 7.2.

>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?

It could be. I have been thinking along this line. I could imagine
the following scenario: Postgres starts after quite a few other
processes, tries to start with the pid stored in the postmaster.pid
file and actually doesn't start because the pid is already in use. Is
there an error log somewhere where such an error might appear?

Thanks.

--------
François

Home page: http://www.monpetitcoin.com/
"A fox is a wolf who sends flowers"