Re: HS/SR and smart shutdown - Mailing list pgsql-hackers

From Robert Haas
Subject Re: HS/SR and smart shutdown
Date
Msg-id 603c8f071003040942m32194837u8fdaff8922f0b3e9@mail.gmail.com
Whole thread Raw
In response to Re: HS/SR and smart shutdown  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
On Thu, Mar 4, 2010 at 12:39 PM, Greg Stark <gsstark@mit.edu> wrote:
> On Thu, Mar 4, 2010 at 3:56 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> On Thu, Mar 4, 2010 at 10:17 AM, Fujii Masao <masao.fujii@gmail.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


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: HS/SR and smart shutdown
Next
From: Josh Berkus
Date:
Subject: Re: Streaming replication and privilege