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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.
Date: 2011-02-18 15:41:44
Message-ID: 22104.1298043704@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Fri, Feb 18, 2011 at 10:09 AM, Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2011-02-18 15:44:28 Re: pgsql: Use $INDENT rather than indent throughout the pgindent code
Previous Message Kevin Grittner 2011-02-18 15:41:08 Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2011-02-18 15:42:20 Re: Debian readline/libedit breakage
Previous Message Kevin Grittner 2011-02-18 15:41:08 Re: [COMMITTERS] pgsql: Make a hard state change from catchup to streaming mode.