Troy Wolf troy at troywolf.com
Mon Dec 1 15:21:58 PST 2008
First, a question that I know has been asked before, but after
grepping and perusing months of the maillist archives, I did not find
the answer: Why is it required to use a Subscriber to generate log
files? Why can't the Origin slon process be started with the option to
generate logs? It just so happens that in my case, I have an Origin
and a normal Subscriber and a third node that I replicate via Log
Shipping. However, I imagine lots of people would have a need for a
single Origin and a single, WAN-connected node they want to replicate
via Log Shipping.

And now onto the issue at hand...

PostgreSQL 8.2 on SUSE ES 10
Slony1-1.2.12

The documentation at http://slony.info/documentation/logshipping.html states:
----------------------------------------------------------------------------------------------------------------------------

14.2. What takes place when a FAILOVER/ MOVE SET takes place?

Nothing special. So long as the archiving node remains a subscriber,
it will continue to generate logs.

If the archiving node becomes the origin, on the other hand, it will
continue to generate logs.

----------------------------------------------------------------------------------------------------------------------------
Hmmm..."If the archiving node becomes the origin, on the other hand,
it will continue to generate logs.". Yes, indeed, it continues to
generate logs. Unfortunately, the logs do not include any of the
changes applied to the new Origin!

We are currently building a test system to reproduce this behaviour,
but twice now, we've seen that when we performed a Switchover--that is
swapped roles between our Origin and Subscriber so the node that was
the Subscriber and also the node that generates the log files is now
the Origin--the updates to the new Origin do not make it into the log
files. The log files keep generating just dandy, but they only contain
the normal Slony-generated shell (the transaction start and commit,
etc.) and none of the actual SQL modifications.

Note that the node that had previously been the Origin that is now the
normal Subscriber does get the updates. That is, the normal Slony
replication is working. Only Log Shipping has broken after the
Switchover.

BUG? Solved in a post 1.2.12 version?

Thank you,
Troy


More information about the Slony1-general mailing list