Re: Re: Running Postmaster - PGDATA Variable - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Re: Running Postmaster - PGDATA Variable
Date
Msg-id 20010727104920.A31003@svana.org
Whole thread Raw
In response to Re: Running Postmaster - PGDATA Variable  (missive@frontiernet.net (Lee Harr))
Responses Re: Re: Running Postmaster - PGDATA Variable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: Running Postmaster - PGDATA Variable
Next
From: Michael Samuel
Date:
Subject: PL/PgSQL and arrays