in general I agree, but sometimes you need to get the knife out...
Sent from my iPad On Aug 24, 2011, at 19:44, Steve Singer <[email protected]> wrote: > 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
