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 10:48:30
Message-ID:
AANLkTi=z+eg6yMEtJCqYb0OnGaNMoTg9eYiK-xm8v0AQ@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 Tue, Mar 8, 2011 at 12:04 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> 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.
I included this fix in the patch, which emits FATAL if pause_at_recovery_target
is enabled while hot standby is disabled and the recovery target is set.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Fujii MasaoDate: 2011-03-08 12:05:08Subject : Re: Sync Rep v19Previous :From : Jan UrbańskiDate : 2011-03-08 10:11:03Subject : Re: pl/python tracebacks
pgsql-committers by date
Next :From: User FxjrDate: 2011-03-08 15:50:38Subject : npgsql - Npgsql2: Fixed problems with SSPI authentication when the Previous :From : Michael MeskesDate : 2011-03-08 10:28:33Subject : pgsql: Added new version of ecpg's parser test script which waswritten
