<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">For admin conninfo, you only specified the server. You also need to specify the<br>Database, port(if not standard 5432, slonik user (and possibly password)<br>eg:<br>node 1 admin conninfo='dbname=$MASTERDBNAME host=$MASTERHOST port=$PGPORT user=$REPLICATIONUSER password=$PASSWORD';<br><br><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br><br></div>--- On <b>Wed, 8/11/10, 노현석 <i><noh019@naver.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: 노현석 <noh019@naver.com><br>Subject: [Slony1-general] how can we overcome error messages "No admin conninfo provided for node -1"??<br>To: slony1-general@lists.slony.info<br>Date: Wednesday, August 11, 2010, 3:21 AM<br><br><div
id="yiv928436694"><style>#yiv928436694 P {margin-top:2px;margin-bottom:2px;}</style><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></div></div><br></blockquote></td></tr></table><br>