Re: The other major HS TODO: standby promotion - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: The other major HS TODO: standby promotion
Date
Msg-id AANLkTikxkQFTgCa4GH2mWXhqvNhiDbMjE4-zMB-+uThz@mail.gmail.com
Whole thread Raw
In response to The other major HS TODO: standby promotion  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Sushant Sinha
Date:
Subject: Re: english parser in text search: support for multiple words in the same position
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: upcoming wraps