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 3 :


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.


On node 3, I see ACCEPT_SET - MOVE_SET or FAILOVER_SET exists -
adjusting setsync status in slon.log, while on node 4, I get ACCEPT_SET
- MOVE_SET or FAILOVER_SET not received yet - sleep



Thanks for you help.


-- 
Cyril SCETBON