Subject: Re: New trigger option of pg_standby
From: Simon Riggs <simon@2ndQuadrant.com>
To: Guillaume Smet <guillaume.smet@gmail.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, Fujii Masao <masao.fujii@gmail.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
In-Reply-To: <1d4e0c10903270519p556649bfr9b19f9156c43be4b@mail.gmail.com>
References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com>
	<1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com>
	<3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com>
	<1d4e0c10903250155w34bd79dcvfab2ad5c95e56011@mail.gmail.com>
	<49C9F255.EE98.0025.0@wicourts.gov>
	<1d4e0c10903250848x4e067c86ue611c0c50f25e49d@mail.gmail.com>
	<3f0b79eb0903251851v5936d6b4x49997ac8f04b98b9@mail.gmail.com>
	<1d4e0c10903260032v767da1fdg6cf7cea86c64cc45@mail.gmail.com>
	<1238064633.16568.420.camel@ebony.2ndQuadrant>
	<49CCBEE0.1080307@gmx.net>
	<1d4e0c10903270519p556649bfr9b19f9156c43be4b@mail.gmail.com>
Content-Type: text/plain
Date: Fri, 27 Mar 2009 13:09:24 +0000
Message-Id: <1238159364.16568.600.camel@ebony.2ndQuadrant>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit


On Fri, 2009-03-27 at 13:19 +0100, Guillaume Smet wrote:
> On Fri, Mar 27, 2009 at 12:56 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> > Simon Riggs wrote:
> >>
> >> If we go with this, I would suggest we make *neither* the default by
> >> removing -t, and adopting two new options: something like -f == fast
> >> failover, -p == patient failover.
> >
> > -m smart|fast|immediate :-)
> 
> The advantage of having 2 options (or the ability to put a string
> value in the trigger file) is that you can choose the behaviour when
> you need to trigger it (you just have to use the 2 options with 2
> different filenames). I don't think it's the case with your proposal.

Yes, sorry. I meant we should use the naming Peter suggests.

So we would have two triggers, but call them fast and smart, rather than
fast and patient.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support