<HTML><HEAD></HEAD>
<BODY 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></BODY></HTML>