[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