auto removing stale pid for postmaster NT service - Mailing list pgsql-admin

From Tony_Chao@putnam.com
Subject auto removing stale pid for postmaster NT service
Date
Msg-id OFB91CFC47.33257F49-ON85256C31.00654C8C@putnaminv.com
Whole thread Raw
Responses Re: auto removing stale pid for postmaster NT service  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,

I've seen this question a couple of times in the archives, but I wasn't
able to find a solution. Please advise if you know of a workaround.

I have postmaster install as a service throught cygrunsrv on my win2k
machine. The postmaster service starts and stops fine most of the time.
But if the server crashes without a proper shutdown, the postmaster.pid
is left behind and the postmaster service fails to start at the next boot.

Is there a way to delete stale postmaster.pid on boot-up before
the postmaster service is attempted to be started?

Thanks
-Tony



pgsql-admin by date:

Previous
From: gar8@pitt.edu (Tony Reina)
Date:
Subject: Primary key order matters?
Next
From: pgomez@freesurf.ch (pgomez)
Date:
Subject: psql database recovery error