Re: Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.
Date
Msg-id 22104.1298043704@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Feb 18, 2011 at 10:09 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Make a hard state change from catchup to streaming mode.
>> More useful state change for monitoring purposes, plus a
>> required change for synchronous replication patch.

> As far as I can see, this patch was not posted or discussed before
> commit, and I'm not sure it's the behavior everyone wants.  It has the
> effect of preventing the system from ever going backwards from
> "streaming" to "catchup".  Is that what we want?

That seems like a very bad idea from here.  Being able to go back to
catchup after loss of the streaming connection is essential for
robustness.  If we now have to restart the slave for that to happen,
it's not an improvement.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.
Next
From: Andrew Dunstan
Date:
Subject: Re: Debian readline/libedit breakage