<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>
<div>
<div>You can not run DDL statement using slony, it states that in slony docs</div>
<div><font face="Calibri,Verdana,Helvetica,Arial"><span style="font-size:11pt">
<div><br>
</div>
</span></font><font color="#130080"><font size="2"><font face="Courier New"><span style="font-size:10pt"> 0___ Wolfgang Schwurack<br>
c/ /'_ SA/DBA - UEN<br>
(*) \(*) 801-587-9444<br>
<a href="wolf@uen.org">wolf@uen.org</a></span></font></font></font><font face="Calibri,Verdana,Helvetica,Arial"><span style="font-size:11pt"><br>
</span></font></div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Efraín Déctor <<a href="mailto:efraindector@motumweb.com">efraindector@motumweb.com</a>><br>
<span style="font-weight:bold">Organization: </span>HESA Técnica<br>
<span style="font-weight:bold">Date: </span>Monday, July 2, 2012 12:49 PM<br>
<span style="font-weight:bold">To: </span>"<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>" <<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>><br>
<span style="font-weight:bold">Subject: </span>[Slony1-general] slonik_execute_script not working<br>
</div>
<div><br>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<div>Hello. I’m testin Slony, everything is running fine in terms of replication, however I’m trying to test adding a column to a table that is beaing replicated.</div>
<div> </div>
<div>I’m using altperl, so using the documentation I see that using slonik_execute_script should help me to create the new column.</div>
<div> </div>
<div>This is how I am using it: <br>
<br>
<em>slonik_execute_script 1 /root/script.sql</em></div>
<div> </div>
<div>After I execute the script this message is shown:</div>
<div> </div>
<div><em>cluster name = replication;</em></div>
<div><em>node 1 admin conninfo='host=192.168.20.144 dbname=nomina user=pgsql port=5432';</em></div>
<div><em>node 2 admin conninfo='host=192.168.20.210 dbname=nomina user=pgsql port=5432;</em></div>
<div><em> execute script (</em></div>
<div><em> set id = 1,</em></div>
<div><em> filename = '/tmp/EpbvGiNpWb',</em></div>
<div><em> event node = 1</em></div>
<div><em> );</em></div>
<div><em></em> </div>
<div>script.sql contains: <em>ALTER TABLE personas ADD COLUMN prueba integer;</em></div>
<div><em></em> </div>
<div>However, nothing happens on the master or slave. <br>
<br>
Could you please, tell me what Im doing wrong?.</div>
<div> </div>
<div>Thank you in advance.</div>
<div> </div>
</div>
</div>
</div>
</div>
</span>
</body>
</html>