Re: [GENERAL] recovery_target_timeline and multiple slave behavior when master fails

2011-12-19 Thread Rick Pufky
Thanks for the comments. I'm not actually running with an archive directory in this configuration (archiving is disabled), however, scp'ing the new history file and the last WAL File from the new master allowed the other slave to just continue replay from where it left off. This is expected in

[GENERAL] recovery_target_timeline and multiple slave behavior when master fails

2011-12-18 Thread Rick Pufky
I'm attempting to make use of the ability defined by the statement at the end of the first paragraph in this section of the documentation ( http://www.postgresql.org/docs/9.1/static/warm-standby.html#STANDBY-SERVER-SETUP). Specifically, If you plan to have multiple standby servers for high

Re: [GENERAL] recovery_target_timeline and multiple slave behavior when master fails

2011-12-18 Thread Fujii Masao
On Fri, Dec 16, 2011 at 3:59 AM, Rick Pufky r...@omniti.com wrote: Any thoughts on the above snippets? Am I interpreting the documentation correctly? Is there any further information needed to debug this? You need to share the archive directory between all three nodes to use that trick. To