hi..
 
1
##################################################
we test EnterpriseDB Replication (slony) node1/node2.
we test Controlled Switchover node1/node2...
(it will be node1 master-->slave, node2 slave ---> master)
 
$ cat switchovernode2.sk
--------------------------------------------
#!/u01/PostgresPlus/8.4AS/bin/slonik
#file switchovernode2.sk
cluster name = testcluster;
node 1 admin conninfo = 'service=192.168.2.61-slonik';
node 2 admin conninfo = 'service=192.168.2.71-slonik';
 
lock set (id=1, origin=1);
move set (id=1, old origin=1, new origin=2);
wait for event (origin=1, confirmed=2); <##### This is issue...
--------------------------------------------
$
$ chmod ugo+x switchovernode2.sk
$
$ ./switchovernode2.sk
./switchovernode2.sk:9: Error: No admin conninfo provided for node -1
$
$
$ 
 
2
##################################################
so, we test 
 
1>
$ cat switchovernode2test1.sk
--------------------------------------------
#!/u01/PostgresPlus/8.4AS/bin/slonik
#file switchovernode2test1.sk
cluster name = testcluster;
node 1 admin conninfo = 'service=192.168.2.61-slonik';
node 2 admin conninfo = 'service=192.168.2.71-slonik';
 
lock set (id=1, origin=1);
move set (id=1, old origin=1, new origin=2);
--------------------------------------------
$
$ ./switchovernode2test1.sk
 <--- OK, no error message, and "switchover ok"
$
$ -- remove wait for event
 
2>
$ cat switchovernode2test2.sk
--------------------------------------------
#!/u01/PostgresPlus/8.4AS/bin/slonik
#file switchovernode2test2.sk
cluster name = testcluster;
node 1 admin conninfo = 'service=192.168.2.61-slonik';
node 2 admin conninfo = 'service=192.168.2.71-slonik';
 
lock set (id=1, origin=1);
move set (id=1, old origin=1, new origin=2);
wait for event (origin=1, confirmed=2, wait on=2); <=== add """wait on = 2""
--------------------------------------------
$ ./switchovernode2test2.sk
 <--- OK, no error message, and "switchover ok"
$
$ -- === add """wait on = 2""
3
##################################################
1>
Could you teach me,
 how can we overcome the error messages when executing switchovernode2.sk.....
 "./switchovernode2.sk:8: Error: No admin conninfo provided for node -1"
 
2>
Could you teach me,
 Can I use "switchovernode2test1.sk" or "switchovernode2test2.sk" ???
 
Thanks...
 
 
 
 
 
 
 
 
 
 noh019님의 블로그
 안녕하세요.
 
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100811/45f0be68/attachment.htm