<html><head><style>P {margin-top:2px;margin-bottom:2px;}</style></head><body><div style="font-size:10pt; font-family:Gulim,Gulim,AppleGothic,sans-serif;"><P>hi..</P>
<P> </P>
<P>1<BR>##################################################<BR>we test EnterpriseDB Replication (slony) node1/node2.</P>
<P>we test Controlled Switchover node1/node2...<BR>(it will be node1 master-->slave, node2 slave ---> master)</P>
<P> </P>
<P>$ cat switchovernode2.sk<BR>--------------------------------------------<BR>#!/u01/PostgresPlus/8.4AS/bin/slonik<BR>#file switchovernode2.sk<BR>cluster name = testcluster;<BR>node 1 admin conninfo = 'service=192.168.2.61-slonik';<BR>node 2 admin conninfo = 'service=192.168.2.71-slonik';</P>
<P> </P>
<P>lock set (id=1, origin=1);<BR>move set (id=1, old origin=1, new origin=2);</P>
<P>wait for event (origin=1, confirmed=2); <##### This is issue...<BR>--------------------------------------------<BR>$<BR>$ chmod ugo+x switchovernode2.sk<BR>$<BR>$ ./switchovernode2.sk<BR>./switchovernode2.sk:9: Error: No admin conninfo provided for node -1<BR>$<BR>$<BR>$ </P>
<P> </P>
<P>2<BR>##################################################<BR>so, we test </P>
<P> </P>
<P>1></P>
<P>$ cat switchovernode2test1.sk<BR>--------------------------------------------<BR>#!/u01/PostgresPlus/8.4AS/bin/slonik<BR>#file switchovernode2test1.sk</P>
<P>cluster name = testcluster;<BR>node 1 admin conninfo = 'service=192.168.2.61-slonik';<BR>node 2 admin conninfo = 'service=192.168.2.71-slonik';</P>
<P> </P>
<P>lock set (id=1, origin=1);<BR>move set (id=1, old origin=1, new origin=2);<BR>--------------------------------------------<BR>$</P>
<P>$ ./switchovernode2test1.sk<BR> <--- OK, no error message, and "switchover ok"<BR>$<BR>$ -- remove wait for event</P>
<P> </P>
<P>2></P>
<P>$ cat switchovernode2test2.sk<BR>--------------------------------------------<BR>#!/u01/PostgresPlus/8.4AS/bin/slonik<BR>#file switchovernode2test2.sk<BR>cluster name = testcluster;<BR>node 1 admin conninfo = 'service=192.168.2.61-slonik';<BR>node 2 admin conninfo = 'service=192.168.2.71-slonik';</P>
<P> </P>
<P>lock set (id=1, origin=1);<BR>move set (id=1, old origin=1, new origin=2);</P>
<P>wait for event (origin=1, confirmed=2, wait on=2); <=== add """wait on = 2""<BR>--------------------------------------------<BR>$ ./switchovernode2test2.sk<BR> <--- OK, no error message, and "switchover ok"<BR>$<BR>$ -- === add """wait on = 2""</P>
<P><BR>3<BR>##################################################</P>
<P>1><BR>Could you teach me,<BR> how can we overcome the error messages when executing switchovernode2.sk.....<BR> "./switchovernode2.sk:8: Error: No admin conninfo provided for node -1"</P>
<P> </P>
<P>2><BR>Could you teach me,<BR> Can I use "switchovernode2test1.sk" or "switchovernode2test2.sk" ???</P>
<P> </P>
<P>Thanks...</P></div></body></html>
<!--start_signature--><P> <BR></P><div id="content-wrap" style="padding: 10px 0;">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr><td colspan="2" height="16" style="background:url(http://static.naver.com/mail4/blog_dotline.gif) repeat-x;"></td></tr>
<tr>
<td align="left" valign="top" width="29">
<a href="http://blog.naver.com/noh019.do" target="_blank" hidefocus><img src="http://static.naver.com/mail4/blog_img.gif" border="0" width="21" height="16"></a>
</td>
<td align="left" valign="top" style="padding-top:3px; line-height:16px;">
<a href="http://blog.naver.com/noh019.do" target="_blank" style=" float:left; font-family:dotum; color: black; font-size: 9pt; font-weight: bold; text-decoration: none; margin-bottom:4px;" hidefocus>noh019님의 블로그</a><br />
<a href="http://blog.naver.com/noh019.do" class="c" target="_blank" style="clear:both; float:left; font-family:dotum; color:#666; font-size: 9pt; font-weight: normal; text-decoration: none; line-height:15px" hidefocus title="">안녕하세요.</a>
</td>
</tr>
</tbody>
</table>
</div><!--navermail.footer.start-->
<!--navermail.footer.end-->
<IMG SRC="http://mail2.naver.com/newmailcheck/jXnlKxIcWrl4azpoFomsKAtmM6F0a6i0K434KAUrFqvmMobZpA3oK4kvtH3Xp6UqFLdZ74lRhoRqWze5DxuRprk5pBiCWuIn1BFdbZlqWze5DLlGW4pT.gif" border=0 width=0 height=0 style="display:none">