On Mon, 2012-07-02 at 13:49 -0500, Efraín Déctor wrote:
> 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?.
> 

You forgot to send the slonik script to slonik. IOW:

slonik_execute_script 1 /root/script.sql | slonik


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com