Re: [COMMITTERS] pgsql: Make fast promotion the default promotion mode.

On 1 May 2013 11:25, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Wed, Apr 24, 2013 at 8:49 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> Make fast promotion the default promotion mode.
>> Continue to allow a request for synchronous
>> checkpoints as a mechanism in case of problems.
>
> Is there clean way to request synchronous checkpoint at the standby promotion?
> I'm sure that we can do that by creating the file "promote" and
> sending the SIGUSR1
> signal to the postmaster. Or by using previous version of pg_ctl.
> These are not clean
> and would confuse users.

I just removed the user interface at Heikki's request, so yes, I can
see its not ideal interface.

My wish was to have a mechanism should we need it.

A third option would be to not have any way at all.

What is your preference?

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services