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 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
