From:
Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To:
Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: How to shoot yourself in the foot: kill -9 postmaster
Date:
2001-03-06 19:07:32
Message-ID:
3AA53574.B29B7645@wgcr.org (view raw or flat )
Thread:
2001-03-05 22:30:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-05 23:19:34 from Thomas Swan <tswan-lst(at)ics(dot)olemiss(dot)edu>
2001-03-05 23:47:51 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 01:46:41 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 01:49:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 01:52:40 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-03-06 01:52:13 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-03-06 01:55:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 02:11:38 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 02:14:16 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-03-06 02:23:55 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 02:36:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 02:45:08 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 02:53:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 03:03:49 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 03:10:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 03:24:11 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 03:31:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 02:57:56 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-03-06 03:06:41 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 03:08:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-03-06 03:11:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 17:04:44 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-03-06 17:55:54 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 18:20:40 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-03-06 19:07:32 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 16:57:48 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-03-06 16:54:49 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-03-06 02:19:25 from ncm(at)zembu(dot)com (Nathan Myers)
2001-03-06 02:33:19 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 02:19:33 from Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
2001-03-06 02:28:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 02:36:56 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 02:40:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 02:55:11 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 03:04:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 03:12:00 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 03:17:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 03:27:23 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 03:33:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 03:44:36 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 12:30:06 from dom(at)idealx(dot)com
2001-03-06 05:43:13 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 18:10:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 18:22:46 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 18:35:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 18:44:47 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 18:57:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 19:12:16 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 19:24:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 19:34:32 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-07 00:04:20 from Cyril VELTER <cyril(dot)velter(at)libertysurf(dot)fr>
2001-03-07 00:22:10 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 19:19:12 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-03-06 19:27:12 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 19:49:45 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 19:36:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 19:54:44 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-06 20:20:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-06 20:46:24 from ncm(at)zembu(dot)com (Nathan Myers)
2001-03-06 21:20:13 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 22:43:05 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2001-03-07 00:29:41 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-07 00:58:16 from ncm(at)zembu(dot)com (Nathan Myers)
2001-03-07 01:16:18 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2001-03-06 21:56:25 from Samuel Sieb <samuel(at)sieb(dot)net>
2001-03-06 22:01:48 from "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
2001-03-08 16:43:16 from teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=)
2001-03-07 01:50:52 from teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=)
2001-03-07 04:38:36 from "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Lists:
pgsql-hackers
Peter Eisentraut wrote:
> Well, if you have something clever you want to do if the postmaster
> doesn't come down after an orderly shutdown then please share it. The
> current alternatives are 'leave running' or 'kill -9'. I know I'd prefer
> the former.
Well, my preferences aren't really relevant here. I have a job to do as
an initscript in the RPMish environment -- and I really have to meet my
obligations (using the first personal pronoun there to anthropomorph the
initscript to a person, allowing us to have a little sympathy for the
poor shell script's plight :-)).
My preference is to let it float in limbo -- if it's in limbo and won't
come out, then we have bigger issues.
However, I could do something really sneaky in the RedHat environment
and let init do the dirty work for me -- but, again, I am not at all
guaranteed that things will come down orderly -- if it is at all
possible for me to bring about an orderly (if slow) shutdown that does
terminate as the rest of the system needs it to do, then I'll attempt to
do so.
But, the immediate issue is preventing chaotic stops within the
initscript, so I'm going to experiment with things and see if I can make
the initscript hang -- if I can't, then I'll likely put in the 'killproc
postmaster -INT' with escalation to -TERM if it doesn't come down within
sixty seconds (and, no, I am not going to sleep 60 then check things --
I am going to sleep 1 and loop sixty times) -- no need to unnecessarily
delay system shutdown (and potential restart). And I won't put in the
-KILL unless I can find a safe and thorough way to do so.
Or I may go ahead and pg_ctl-ize things and let pg_ctl do the dirty
work, as that IS what pg_ctl is supposed to accomplish.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
In response to
pgsql-hackers by date
Next :From: Alfred PerlsteinDate: 2001-03-06 19:12:16
Subject : Re: How to shoot yourself in the foot: kill -9 postmaster
Previous :From : Jarom HagenDate : 2001-03-06 19:02:40
Subject : COBOL