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