Re: [HACKERS] The other major HS TODO: standby promotion

2010-09-06 Thread Fujii Masao
On Sat, Sep 4, 2010 at 5:02 AM, Josh Berkus j...@agliodbs.com wrote: (a) seems easily enough solved by giving two steps: giving the DBA a way to check where in the replication stream each standby is (I think we already have this) Yep, pg_last_xlog_receive_location would help. The second

Re: [HACKERS] The other major HS TODO: standby promotion

2010-09-04 Thread Itagaki Takahiro
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

[HACKERS] The other major HS TODO: standby promotion

2010-09-03 Thread Josh Berkus
All, As far as I'm concerned, the other big missing feature for HS is the ability to promote standbys to become the new master. If we had that feature, then HS can be the backbone of a large-scale PostgreSQL cloud; if we don't have it, then HS does not contribute very much to scalability beyond