On Sat, Sep 4, 2010 at 5:02 AM, Josh Berkus <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
