[Slony1-general] move_set question

[Steve Singer]

On Thu, 21 Jan 2021, Richard Yen via Slony1-general wrote:

> 
> 
> On Wed, Jan 20, 2021 at 8:55 PM 張 蔚捷（Zhang WeiJie） via Slony1-general <slony1-general at lists.slony.info> wrote:
>       But I hove no idea how to change to the following mode.
>       node 1->node2
>       node 1->node3
>
>       Any suggestions would be greatly appreciated.
> 
> 
> You should be able to just do:
> 
> subscribe set ( id = 1, provider = 1, receiver = 3 );
> 
> But first you will need to make sure node1->node2 has "forward = yes" (it is set to "yes" by default, so it may not be a problem
> for you)

Or

resubscribe node (origin=1, provider=1,receiver=3);

https://www.slony.info/documentation/2.2/stmtresubscribenode.html

If you have multiple sets I think you need to use resubscribe node so all 
sets get adjusted at the same time.


Steve

> 
> --Richard
> 
> 
>
>       _______________________________________________
>       Slony1-general mailing list
>       Slony1-general at lists.slony.info
>       http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 
> 
>