Thu Aug 9 10:26:19 PDT 2007
- Previous message: [Slony1-general] Re: log shipping gone wrong
- Next message: [Slony1-general] REshaping on loss of middle tier node?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On 7/31/2007 6:54 PM, Jerry Sievers wrote:
>
> Chris, this is very helpful. Thanks!>
>
> Basically, I misunderstood the documentation and believe that what I
> was trying was supported and straightforward to do. You have affirmed
> that it is not.
What you intended to do is well supported and was so from day one. What
the "subscribe set" command, that is supposed to let slave2 become a
direct subscriber, requires is a path to the master. If that didn't
exist, the subscribe should have failed. So all you have to do is
store path (master->slave2)
store path (slave2->master)
subscribe set (...)
After that subscribe set finished and slave2 is catching up again, you
can drop slave1 and are done.
I am not sure if 1.1.5 maintained the sl_listen table automagically. So
you might want to add the appropriate "store listen" commands in there
as well.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck at Yahoo.com #
- Previous message: [Slony1-general] Re: log shipping gone wrong
- Next message: [Slony1-general] REshaping on loss of middle tier node?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list