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 <ssinger at ca.afilias.info> 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
>>> Slony1-general at lists.slony.info <mailto:Slony1-general at lists.slony.info>
>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>> 
>> 
>> ___________________________________________________________
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Jim Buttafuoco
>> jim at contacttelecom.com <mailto:jim at contacttelecom.com>
>> 603-647-7170 ext. 2222- Office
>> 603-490-3409 - Cell
>> jimbuttafuoco - Skype
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
> 
>