From:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To:
Magnus Hagander <magnus(at)hagander(dot)net>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Re: [COMMITTERS] pgsql: Basic Recovery Control
functions for use in Hot Standby. Pause,
Date:
2011-03-08 03:04:34
Message-ID:
AANLkTinXFfS3we4=Qj29kyTB0=thVjhAGmk1UOic8V7p@mail.gmail.com (view raw or flat )
Thread:
2011-02-08 18:30:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-02-09 03:50:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-02-09 05:02:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-02-09 06:22:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-02-09 08:12:32 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-02-15 02:07:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-08 03:04:34 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-08 10:48:30 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-10 19:36:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-11 09:58:09 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-11 14:31:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-03-11 16:59:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-16 07:29:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-16 08:41:12 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-16 11:46:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-16 14:27:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-03-17 06:47:18 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-17 16:17:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 05:13:13 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-18 07:22:47 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-18 12:14:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 12:27:15 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-18 12:31:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-23 08:51:20 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-23 11:50:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-23 13:38:50 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-23 15:19:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-24 11:02:49 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-24 21:43:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-19 00:52:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-15 00:21:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-02-15 02:06:22 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-02-09 04:00:58 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2011-02-09 04:18:45 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-08 00:20:27 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2011-03-08 02:36:09 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-08 03:04:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-03-08 03:29:06 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Lists:
pgsql-committers pgsql-hackers
On Wed, Feb 9, 2011 at 5:12 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> I was also worried about the non-hot-standby case, but I see that the
> patch makes sure you can't enable pause when not in hot standby mode.
> Which in itself might be surprising - perhaps we need a NOTICE for
> when that happens as well?
I didn't include this fix in the patch because I prefer FATAL to
NOTICE for that.
NOTICE doesn't stop recovery. So we might be unable to notice such a NOTICE
message and stop the recovery before it's too late, i.e., the recovery has
completed at the undesirable point. So I think that emitting FATAL is safer.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2011-03-08 03:28:45Subject : Re: Parallel make problem with git master Previous :From : Tom LaneDate : 2011-03-08 03:04:26Subject : Re: pgsql: Basic Recovery Control functions for use in Hot Standby. Pause,
pgsql-committers by date
Next :From: Fujii MasaoDate: 2011-03-08 03:29:06Subject : Re: pgsql: Basic Recovery Control functions for use in
Hot Standby. Pause,Previous :From : Tom LaneDate : 2011-03-08 03:04:26Subject : Re: pgsql: Basic Recovery Control functions for use in Hot Standby. Pause,
