Re: Immediate standby promotion - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Immediate standby promotion
Date
Msg-id CA+TgmobB-XkO_bnXL4eBUzOtC8PCdxb=BKjgJmimfPAujdNEJA@mail.gmail.com
Whole thread Raw
In response to Re: Immediate standby promotion  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Immediate standby promotion
List pgsql-hackers
On Wed, Sep 24, 2014 at 4:36 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> To me, being able to say "pg_ctl promote_right_now -m yes_i_mean_it"
>> seems like a friendlier interface than making somebody shut down the
>> server, run pg_resetxlog, and start it up again.
>
> It makes sense to go from paused --> promoted.

Well, we could certainly require that people call
pg_xlog_replay_pause() before they call pg_promote_now().  I don't
think I like that better, but it beats not having pg_promote_now().

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: proposal: rounding up time value less than its unit.
Next
From: Simon Riggs
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}