From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
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 18:20:40
Message-ID:
Pine.LNX.4.30.0103061918110.778-100000@peter.localdomain (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
Lamar Owen writes:
> > case when the postmaster does not come down after 60 seconds. But this is
> > really no problem for the issue at hand because if you do a normal
> > runlevel switch then the postmaster will simply keep running, and during a
> > system shutdown all the backends are going to die anyway.
>
> Only if each and every shutdown script succeeds in its task. And I have
> to make sure that the RPM's shipping script successfully pulls down the
> system in an orderly fashion -- of course, I don't have to worry about
> the case where a postmaster is going to be started back up if we are in
> system shutdown -- but, as Tom also stated, I can't assume I'm in the
> system's death throes when called with the stop parameter.
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.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
In response to
Responses
pgsql-hackers by date
Next :From: Alfred PerlsteinDate: 2001-03-06 18:22:46
Subject : Re: How to shoot yourself in the foot: kill -9 postmaster
Previous :From : Tom LaneDate : 2001-03-06 18:18:53
Subject : Re: AW: AW: AW: AW: WAL-based allocation of XIDs is insecur e