From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Greg Stark <gsstark(at)mit(dot)edu>
Cc:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: HS/SR and smart shutdown
Date:
2010-03-04 17:42:50
Message-ID:
603c8f071003040942m32194837u8fdaff8922f0b3e9@mail.gmail.com (view raw or flat )
Thread:
2010-01-20 23:04:20 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-21 01:40:51 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-21 01:44:43 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-21 01:52:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-21 01:56:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-21 01:58:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-21 01:59:00 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2010-01-21 02:42:03 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-21 07:27:58 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-21 08:35:55 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-01-29 13:28:06 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-29 19:43:06 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-29 21:04:33 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-29 22:59:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-30 00:01:15 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-01-30 00:05:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-31 17:27:59 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-30 03:54:30 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-01 02:49:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-03-04 12:11:36 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-03-04 14:55:10 from Greg Stark <gsstark(at)mit(dot)edu>
2010-03-04 15:17:51 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-03-04 15:56:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-03-04 17:39:02 from Greg Stark <gsstark(at)mit(dot)edu>
2010-03-04 17:42:50 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
On Thu, Mar 4, 2010 at 12:39 PM, Greg Stark <gsstark(at)mit(dot)edu> wrote:
> On Thu, Mar 4, 2010 at 3:56 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Thu, Mar 4, 2010 at 10:17 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>>
>>> Yes. More precisely, smart shutdown during recovery does not complete
>>> until recovery ends.
>>
>> Well, I don't think we should let smart shutdown just never terminate
>> when standby_mode = on. That's really a minefield for the unwary. I
>> think we either need to make it work, or somehow give the user an
>> error that says "try a different shutdown mode".
>
> It also seems dangerous to let someone think they have a standby
> database ready to go and the minute they need it -- it shuts down....
LOL.
Yeah, that would not be cool.
...Robert
In response to
pgsql-hackers by date
Next :From: Josh BerkusDate: 2010-03-04 18:14:15Subject : Re: Streaming replication and privilegePrevious :From : Greg StarkDate : 2010-03-04 17:39:02Subject : Re: HS/SR and smart shutdown
