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.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
