Mon Mar 19 14:04:36 PDT 2012
- Previous message: [Slony1-general] Slony installation query.
- Next message: [Slony1-general] Moveset changes to sub_forward
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony installation query.
- Next message: [Slony1-general] Moveset changes to sub_forward
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list