<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 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* 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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m wondering if its possible to query any of the databases in my cluster to see when Slony is done replicating changes to a single node. I was going to use the Acks Outstanding statistic but then realized that the slave nodes that my
controller service is waiting to update (and do not have Slony running on) will keep adding to that count. If there is no statistic to query, is my assumption that tables are replicated in the order they are added to the replication set correct?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">As for why I can’t just let the changes replicate to all slaves at once, it is because of a no single point of failure for the web app that is reading the replicated data.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Shaun McCloud – Associate Software Developer<br>
Geo-Comm, Inc</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><br>
601 W. Saint Germain St., Saint Cloud, MN 56301<br>
<b>Office:</b> 320.240.0040 <b>Fax:</b> 320.240.2389 <b>Toll Free:</b> 888.436.2666<br>
<b><i>click here to visit </i></b><a href="http://www.geo-comm.com/"><b><i><span style="color:black">www.geo-comm.com</span></i></b></a><o:p></o:p></span></p>
<p class="MsoNormal"><a href="http://www.linkedin.com/companies/geocomm"><span style="color:windowtext;text-decoration:none"><img border="0" width="35" height="35" id="Picture_x0020_3" src="cid:image001.jpg@01CD1198.8E1EB250"></span></a>
<a href="http://twitter.com/_geocomm"><span style="color:windowtext;text-decoration:none"><img border="0" width="36" height="36" id="Picture_x0020_4" src="cid:image002.jpg@01CD1198.8E1EB250"></span></a><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:3.75pt"><span style="font-size:24.0pt;font-family:Webdings;color:green">P</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:navy">
</span><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:green">Think before you print!</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Microsoft Certified Desktop Support Technician (MCDST)<o:p></o:p></span></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>