> subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
> subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);
> subscribe set ( id = 3, provider = 1, receiver = 2, forward = yes);
>
> subscribe set ( id = 1, provider = 1, receiver = 3, forward = yes);
> subscribe set ( id = 2, provider = 1, receiver = 3, forward = yes);
> subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);
> subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);
>ERROR:
><stdin>:74: PGRES_FATAL_ERROR select "_cls".subscribeSet(1, 2, 4,
>'t'); - ERROR: Slony-I: subscribeSet(): provider 2 is not an active
>forwarding node for replication set 1
Try adding a
wait for event (origin = <origin_node>, confirmed = <subscriber_node>);
after _each_ of your subscribe commands.
eg:
subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
wait for event (origin = 1 confirmed = 2);
subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);
wait for event (origin = 1 confirmed = 2);
...
...
...
subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);
wait for event (origin = 1 confirmed = 3);
subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);
Melvin Davidson
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general