Brian Trudal dbrb2002-sql at yahoo.com
Mon Mar 19 14:04:36 PDT 2012
Hi there

We have 3 nodes in cluster. 

After moving a set from one node (node-1) to another (node-2), whats the best way to reset the origin in another subscriber (node-3) as it still talking to node-1 as node-1 is doing forward of node-2 changes to node-3 ; rather I want node-3 directly talk to node-2 (new origin) without sub_forward by node-1.

The sl_subscribe looks like this:

engine_db=# select * from sl_subscribe where sub_set=1;
 sub_set | sub_provider | sub_receiver | sub_forward | sub_active 
---------+--------------+--------------+-------------+------------
       1 |            1 |            3 | f           | t
       1 |            2 |            1 | t           | t
(3 rows)

Rather, after moveset, I expected, line 1 to go away and line-2 to have direct replication to 3 instead of forward through 1.

Thanks for help
Brian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120319/2f21fa29/attachment.htm 


More information about the Slony1-general mailing list