<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>For some time now, we've been working with an older SuSE 11.3 server that had slony 1.1 (I think 1.1.2, possibly 1.1.5) on it. Our remote servers were being replicated to by means of the log shipping setup. As a result, the remote machines are all prepared
for log files that have entries like the following:</p>
<p> </p>
<p><font face="System">select "_cpc_replic".setsyncTracking_offline(12, '476698', '476700', '2013-04-22 11:00:32.050019');</font></p>
<p><font face="System"></font> </p>
<p>However, for the past week, I've been working on getting a new server (RHEL 6.4 virtual machine) in place as our primary replication box. I couldn't get the old slony version to install on that correctly, so I ended up downloading and installing Slony 2.0.7
on it. As a result, the logshipping files now no longer have the line above, they instead have a line much like the one below:</p>
<p> </p>
<p><font face="System">select "_cpc_replic".archiveTracking_offline('5945', '2013-04-22 11:07:38.617205');</font></p>
<p> </p>
<p>How do I go about converting those? My preference would be to modify the process itself so it goes back to generating the .setsyncTracking_offline statements, but if that cannot be done, where can I find a good set of instructions on converting our current
database replication schemas to correctly handle the new statement types?</p>
</div>
</body>
</html>