Re: Re: Running Postmaster - PGDATA Variable

On Fri, Jul 27, 2001 at 12:28:25AM +0000, Lee Harr wrote:
> > Lock file "/usr/local/pgsql/data/postmaster.pid" already exists.

> If you are absolutely sure that there is not another postmaster
> still running you can remove the postmaster.pid file
>
> The file may have been left there if you killed the postmaster
> without shutting down properly (like if the power went out on
> your computer.)

Can't postgres check to see if the pid listed in that file is still active?
If it is then you can say so, if not then (unless the data is shared out and
there's a postmaster running elsewhere) it's fine to delete it.

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.