| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | sameer(dot)kumar(at)ashnik(dot)com |
| Cc: | susan(dot)cassidy(at)decisionsciencescorp(dot)com, dmitry(dot)koterov(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fully-automatic streaming replication failover when master dies? |
| Date: | 2014-01-24 03:28:32 |
| Message-ID: | 20140124.122832.1618189672413908662.t-ishii@sraoss.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I don't think pgpool adds the lost node on its own (once the node is live
> or available again).
That's one of my TODOs. If we limit it to the standby nodes, it will
be safe. I hope this is added to next major version of pgpool-II.
> Plus if you have a 3 node replication you need to have
> your own failover_command (as a shell script) which changes the master node
> for 2nd secondary when one of the secondary servers decides to be promoted
> to primary). I hope things will get easy with version 9.4 (I guess in 9.4
> one won't have to rebuild a master node from backup. if the wal files are
> available it will just roll forward).
Yes, if you have multiple candicate standbys to be promoted, you
should make a discion on this. Pgpool-II cannot guess your will.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Torsten Förtsch | 2014-01-24 03:44:50 | Re: Help with details of what happens when I create a constraint NOT VALID |
| Previous Message | Scott Marlowe | 2014-01-24 02:41:54 | Re: Fully-automatic streaming replication failover when master dies? |