On Sat, Sep 4, 2010 at 5:02 AM, Josh Berkus <josh@agliodbs.com> wrote:
> As far as I'm concerned, the other big "missing feature" for HS is the
> ability to promote standbys to become the new master.
Absolutely. Users often express disappointment when they know
a new base backup required after fail over.
> b) when we bring a standby up, it comes up on a new timeline. Since the
> other standbys don't have this new timeline, they are incompatible with it.
>
> The second method would be by giving standbys a way to "subscribe" to a
> new timeline. This seems like the better approach, as it would
> logically be part of the re-mastering command. What changes would be
> required to do this?
On my test, standby servers succeeded to subscribe the new master
when I set "recovery_target_timeline" to the new master's one.
It actually worked in some cases, but I'm not sure in all cases.
--
Itagaki Takahiro