That was it. It worked.

Thank you really much.

-----Mensaje original----- 
From: Guillaume Lelarge
Sent: Monday, July 02, 2012 3:37 PM
To: Efraín Déctor
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] slonik_execute_script not working

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