Mon Dec 1 15:21:58 PST 2008
- Next message: [Slony1-general] Log Shipping fails after Switchover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: [Slony1-general] Log Shipping fails after Switchover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list