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.

I’m using altperl, so using the documentation I see that using slonik_execute_script should help me to create the new column.

This is how I am using it: 

slonik_execute_script 1 /root/script.sql

After I execute the script this message is shown:

cluster name = replication;
node 1 admin conninfo='host=192.168.20.144 dbname=nomina user=pgsql port=5432';
node 2 admin conninfo='host=192.168.20.210 dbname=nomina user=pgsql port=5432;
  execute script (
    set id = 1,
    filename = '/tmp/EpbvGiNpWb',
    event node = 1
  );

script.sql contains:  ALTER TABLE personas ADD COLUMN prueba integer;

However, nothing happens on the master or slave. 

Could you please, tell me what Im doing wrong?.

Thank you in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120702/5930d3c7/attachment.htm