<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">I am working on setting up a secondary machine, at another location, with roughly the same structure as our primary machine here. The current machine is running Slony 2.0 (I think 2.0.7 but cannot recall for certain) against Postgres
8.4.13, the newer one is running Slony 2.1.4 against Postgres 9.2.15.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The main machine uses slony to generate log-shipping files, which are then sent out to other servers we maintain to feed the local database copies on them. The new remote machine is intended as a backup to this system, eventually to become
a replacement for the current machine. To this end, I was asked to get the new remote machine set up to both create log files, and to receive the log files we’re sending to the other machines we maintain.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have managed to install Slony 2.1.4 on the new machine, and I have verified that I can replicate changes input manually on the new machine. Changes from the log files being generated by the old machine, however, don’t replicate on the
new system. I believe, from what I’ve found online, that the cause of this is the line ‘set session_replication_role to replica;’ found near the beginning of the log files. If I’m understanding correctly, that is forcing the system to bypass the triggers
that Slony needs to run the replication setup.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is there some setting I can change in the Slony instance on the log-shipping generating machine to prevent the log files from being sent out with that line, or something I can change on the receiving machine that will allow it to ignore
the line in question? Or something else, perhaps, which can work to resolve this? What options do I have for getting this setup to work?
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
<p class="MsoNormal">Andrew Edson<o:p></o:p></p>
<p class="MsoNormal">Application Software, Inc.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>