hi all,<div><br></div><div>Iam new to slony with postgres. Using Slony 2.x with postgres 8.4</div><div><br></div><div>I used this link: <span class="Apple-style-span" style="font-family: Arial; "><font title="http://www.slony.info/documentation/failover.html" face="Times New Roman" size="3"><a title="http://www.slony.info/documentation/failover.html" href="http://www.slony.info/documentation/failover.html">http://www.slony.info/documentation/failover.html</a></font></span></div>
<div><span class="Apple-style-span" style="font-family: Arial; "><br></span></div><div><span class="Apple-style-span" style="font-family: Arial; ">In my setup, there is only one master (node:1) and one slave (node:2)</span></div>
<br><div>to do some switchover testing.. The controlled switchover works fine.</div><div><br></div><div>The test i wanted to do was 'what if master server goes down - like a restart'. I want the 'slave' to become master and accept write requests. and when the original master server comes back up, i want it to become the 'slave'.</div>
<div><br></div><div>I tried this</div><div> 1) on Master, did shutdown -r</div><div> 2) login to slave and run</div><div> lock set (id = 1, origin = 1);</div><div><div> move set (id = 1, old origin = 1, new origin = 2);</div>
</div><div><br></div><div>The above does not work, as it is trying to talk with original master.</div><div><br></div><div>Should i run the 'failover' command? <span class="Apple-style-span" style="font-family: monospace; font-size: 13px; line-height: 16px; white-space: pre-wrap; ">failover (id = 1, backup node = 2); </span>there are some big warnings against doing this in the slony link above</div>
<div><br></div><div><span class="Apple-style-span" style="font-family: monospace; font-size: 13px; line-height: 16px; white-space: pre-wrap; "></span>If so, how do i make the old master when it restarts, run as slave.</div>
<div><br></div><div>Thanks in advance.</div>