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