Re: auto removing stale pid for postmaster NT service

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: auto removing stale pid for postmaster NT service
Date: 2002-09-17 14:27:26
Message-ID: 20020917102726.D27778@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Sep 16, 2002 at 05:27:38PM -0400, Tom Lane wrote:

> FYI, sendmail has the same restart failure mode; I imagine a lot of
> other Unix daemons do too.

Yes, as far as I know atd, klogd, and ypbind also fail this way, at
least on some flavours of Linux (where I've had it happen). And ISTR
that some bit of NFS didn't recover correctly under Solaris 2.6, but
I can't recall for sure now.

> It wasn't yet, mainly because it's not obvious how to tell reliably
> whether some other process is a postmaster or not.

I had a feeling this might be the case. I think the suggestion of a
boot-time "cleaning script" is a good idea -- something run by root
before switching runlevels is the obvious answer -- but that's the
sort of thing that probably should be hand-crafted by a competent
sysadmin for each case. In some environments, there are good reasons
not to restart things in case of crash. (If the hardware is flakey,
for instance, you might not want the service to be going up and
down.)

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-09-17 14:33:47 Re: [GENERAL] Still big problems with pg_dump!
Previous Message Wim 2002-09-17 14:25:45 Re: Still big problems with pg_dump!