How is it possible that node 1 is the provider of node 2 and in the same 
time node 2 is the provider of node 1 ??


Has someone played with this feature ?


thanks.


Cyril SCETBON wrote:

> Hi,
>
>
>
> I get the following configuration :
>
>
> select * from "_CLUSTER1".sl_subscribe;
> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
> ---------+--------------+--------------+-------------+------------
>       1 |            1 |            2 | t           | t
>       1 |            1 |            3 | t           | t
>       1 |            3 |            4 | t           | t
>
>
> I used the following slonik script to make node 2 the new provider :
>
>
> CLUSTER NAME = CLUSTER1;
> NODE 1 ADMIN CONNINFO = 'dbname=dbrep host=host1 user=postgres 
> port=5433';
> NODE 2 ADMIN CONNINFO = 'dbname=dbrep host=host2 user=postgres 
> port=5434';
> NODE 3 ADMIN CONNINFO = 'dbname=dbrep host=host3 user=postgres 
> port=5435';
> NODE 4 ADMIN CONNINFO = 'dbname=dbrep host=host4 user=postgres 
> port=5436';
> LOCK SET (ID = 1, ORIGIN = 1);
> MOVE SET (ID = 1, OLD ORIGIN = 1, NEW ORIGIN = 2);
>
>
> But the new configuration is :
>
>
> select * from "_CLUSTER1".sl_subscribe;
> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
> ---------+--------------+--------------+-------------+------------
>       1 |            1 |            3 | t           | t
>       1 |            3 |            4 | t           | t
>       1 |            2 |            1 | t           | t
>
>
> on nodes 1,2,3 but not on node 4 :
>
>
> select * from "_CLUSTER1".sl_subscribe;
> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
> ---------+--------------+--------------+-------------+------------
>       1 |            1 |            2 | t           | t
>       1 |            1 |            3 | t           | t
>       1 |            3 |            4 | t           | t
>
>
> I was thinking that the one node 4 is displaying would be the new
> configuration.
>
> Thanks for you help.
>
>