Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group