Hi,

i'm experimenting with Slony-i and was trying the the following
configurations:

# A. one origin node (N1), one subscriber (N2); same host.        
(simple,local)
#
# B. A + remote node (N3) subscribing directly from origin node.
(simple,local) +
#                                                                                                
(remote)
#
# C. B + remote node (N4), getting cascade events from N2.     
(simple,local) +
#                                                                                                
(remote,cascade)
#
# D. modify C:        N3   getting cascade events from N2.            (swap
provider)
#
# E. modify D:        N2   becomes origin,
#                           N1   becomes subscriber,
#                           getting cascade events from N2.                   
(swap master)
#
# F. failover:        N3   becomes origin,
#                         N1   subscribing directly from origin node, N3.
#                         N4   subscribing directly from origin node, N3.
#                         N2   dropped from configuration.

The slonik commands works as expected until I try to test E:
moving the origin of the set from N1 to N2.

the commands i executed are :

> $ cat mod_master.sk
> #! /opt/postgresql-8.2.5/bin/slonik
>
> include <preamble.sk>;
> 
> lock set ( id = @SID_1,     origin = @SC6_1 );
> move set ( id = @SID_1, old origin = @SC6_1, new origin = @SC6_2 );>
>
> $ cat mod_subsets.sk
> #! /opt/postgresql-8.2.5/bin/slonik
> 
> include <preamble.sk>;
> 
> subscribe set ( id = @SID_1, provider = @SC6_2, receiver = @SC6_1, forward
> = yes );
>
>
> $

after running the 2 scripts above, the origin was moved from N1 to N2.
i was able to update a row in a table in the set on N2, and the change
was reflected on N1.

however, N3 and N4 cannot see any changes after the "move set".

what are additional commands i need to invoke ? 

N1 and N2 are on one machine, while N3 and N4 are on another.

Thanks Very Much in advance!
cheers,
sam
-- 
View this message in context: http://www.nabble.com/subscrptions-lost-after-move-set---tp16935639p16935639.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.