Wed Oct 31 09:41:54 PDT 2007
- Previous message: [Slony1-general] How to pass parameters to a slonik script?
- Next message: [Slony1-general] slony installation
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] How to pass parameters to a slonik script?
- Next message: [Slony1-general] slony installation
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list