On 11-08-24 06:28 PM, Jim Buttafuoco wrote: > just alter the table on the other node, I have to do it here all the time.
Your Playing with fire. With Slony 1.2.x the triggers installed on your table contain information about the structure of your table in the trigger arguments. The EXECUTE SCRIPT slonik command resets those values. Also doing any sort of DDL on a 1.2 slave outside of EXECUTE SCRIPT is a bad idea because of how slony 1.2 munges the catalog of slaves. I think mare would be better off Doing a EXECUTE SCRIPT(only on=slave node) to add the columns to the slave node. Then do an EXECUTE SCRIPT(file=some_script.sql , only on=master node) where some_script.sql is some SQL file that does not do much (ie just selects from a table). When Slonik performs the execute script it will reset the triggers. Remember EXECUTE SCRIPT in Slony 1.2 takes exclusive locks on all replicated tables. > > On Aug 24, 2011, at 6:24 PM, maretranq wrote: > >> Hello, >> >> Is it possible to fix this situation, ideally without starting over? >> >> A Slony cluster of 2 nodes was deployed and running. Some time later, >> a column was added only to the origin/"master" node outside of Slony >> control. slon is still running on both nodes, but the subscriber node >> is understandably emitting errors, such as: >> >> ERROR: column "foo" of relation "bar" does not exist >> >> Does anyone have suggestions on what might be the best way forward? >> >> Software versions: >> >> Ubuntu 10.04 >> PostgreSQL 8.4.8 (Ubuntu) >> Slony-I 1.2.20 (Ubuntu) >> >> I apologize if this scenario has been addressed previously; I'd >> greatly appreciate any pointers. What searches I tried did not turn up >> something applicable. >> >> Thanks! >> >> mare >> _______________________________________________ >> Slony1-general mailing list >> [email protected] <mailto:[email protected]> >> http://lists.slony.info/mailman/listinfo/slony1-general >> > > ___________________________________________________________ > > > > > > > > Jim Buttafuoco > [email protected] <mailto:[email protected]> > 603-647-7170 ext. 2222- Office > 603-490-3409 - Cell > jimbuttafuoco - Skype > > > > > > > > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
