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

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