HS/SR and smart shutdown
in [PgSql]
|
Prev: [HACKERS] HS/SR and smart shutdown
Next: plpython3 perf
From: Fujii Masao on 4 Mar 2010 10:17 On Thu, Mar 4, 2010 at 11:55 PM, Greg Stark <gsstark(a)mit.edu> wrote: > On Thu, Mar 4, 2010 at 12:11 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: >> There is no post about this for over a month. Can I remove this >> from TODO item of SR for 9.0? Thought? Objection? >> > > Does smart shutdown still fail to shut down a slave? Yes. More precisely, smart shutdown during recovery does not complete until recovery ends. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Robert Haas on 4 Mar 2010 10:56 On Thu, Mar 4, 2010 at 10:17 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: > On Thu, Mar 4, 2010 at 11:55 PM, Greg Stark <gsstark(a)mit.edu> wrote: >> On Thu, Mar 4, 2010 at 12:11 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: >>> There is no post about this for over a month. Can I remove this >>> from TODO item of SR for 9.0? Thought? Objection? >>> >> >> Does smart shutdown still fail to shut down a slave? > > 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". ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Greg Stark on 4 Mar 2010 12:39 On Thu, Mar 4, 2010 at 3:56 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: > On Thu, Mar 4, 2010 at 10:17 AM, Fujii Masao <masao.fujii(a)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.... -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Robert Haas on 4 Mar 2010 12:42
On Thu, Mar 4, 2010 at 12:39 PM, Greg Stark <gsstark(a)mit.edu> wrote: > On Thu, Mar 4, 2010 at 3:56 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: >> On Thu, Mar 4, 2010 at 10:17 AM, Fujii Masao <masao.fujii(a)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 -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |