[Slony1-general] move_set question

vividy at justware.co.jp vividy at justware.co.jp
Fri Jan 22 02:25:06 UTC 2021


subscribe set (id = 1, provider = 1, receiver = 3, forward = yes);
perfectly works for me.

Thanks!


On Thu, 21 Jan 2021 07:55:55 -0500 (EST)
Steve Singer <steve at ssinger.info> wrote:

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



More information about the Slony1-general mailing list