<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 15 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.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="1027" />
</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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:navy">Hi Guys<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">(version pgpool-II-pg93-3.4.0-3pgdg.rhel6.x86_64.rpm)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">I’ve seen some chat online about this from a while back, but I haven’t found a solve.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">I have 2 pgpool servers running streaming replication and load balancing. They connect to 3 postgres servers. 2 are virtual machines and 1 Physical machine.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">I’d prefer the physical machine to be the master server. I have done test using the pcp_promote_node command, and I see that the show pool_nodes; shows the node I select as primary, however on postgres side the
command SELECT pg_is_in_recovery(); show that server still in recovery.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">All the pcp_promote command does, is detach master node. Which then prevents insert into the DB.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">Secondly If the master fails, another server does become master, however the other slave is clueless of this and does not replicate any new data until I recover it from the new master. Recovering is a pain as it
copies the whole data folder, and our data folder is growing rapidly.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">Is there a work around for the above 2 problems. Also please let me know if u need more info, such as logs etc etc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">Thanks<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1101" style="width:825.75pt">
<tbody>
<tr style="height:127.5pt">
<td width="1184" valign="top" style="width:888.0pt;padding:0in 0in 0in 0in;height:127.5pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr style="height:15.0pt">
<td width="933" valign="top" style="width:699.75pt;padding:0in 0in 0in 3.75pt;height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#333333">
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:24.0pt">
<td style="padding:0in 0in 0in 0in;height:24.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:navy">Robert Kennedy</span></b><span style="font-size:10.0pt;color:#134883">|</span><span style="font-size:10.5pt;color:#333333">
</span><b><span style="font-size:12.0pt;color:#0095D4">Software & Systems Developer</span></b><span style="font-size:10.0pt;color:#134883">|
</span><span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
<td valign="bottom" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_2" o:spid="_x0000_s1026" type="#_x0000_t75" style='position:absolute;margin-left:0;margin-top:0;width:63.75pt;height:18pt;z-index:251659264;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:0;mso-wrap-distance-top:0;mso-wrap-distance-right:0;mso-wrap-distance-bottom:0;mso-position-horizontal:left;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:line;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page' o:allowoverlap="f">
<v:imagedata src="cid:image001.jpg@01D02F44.C11CB4F0" o:href="file:///C:\Users\robert\AppData\Roaming\Microsoft\Signatures\UwinIwin%20JHB\uwin-logo.jpg" />
<w:wrap type="square" anchory="line"/>
</v:shape><![endif]--><![if !vml]><img width="85" height="24" src="cid:image001.jpg@01D02F44.C11CB4F0" align="left" v:shapes="Picture_x0020_2"><![endif]><span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr style="height:19.5pt">
<td style="padding:0in 0in 0in 0in;height:19.5pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:navy">
<b>Tel </b>: 011 557 5729 | <b>Ext</b>: 229 | <b>Cell:</b> 084 998 9850 </span>
<span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:20.25pt">
<td style="padding:0in 0in 0in 3.75pt;height:20.25pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;color:navy">Email :</span></b><span style="font-size:10.5pt;color:navy"> </span><span style="font-size:10.0pt;color:navy"> robert@uwiniwin.co.za</span><span style="font-size:10.5pt;color:navy">
</span><span style="font-size:7.5pt;color:navy">|</span><span style="font-size:10.5pt;color:navy">
</span><b><span style="font-size:10.0pt;color:navy">Site</span></b><span style="font-size:10.0pt;color:navy">:</span><span style="font-size:10.5pt;color:navy">
</span><span style="font-size:10.0pt;color:navy">www.uwiniwin.co.za</span><span style="font-size:10.0pt;color:#333333"><br>
</span><b><span style="font-size:10.0pt;color:navy">Address</span></b><span style="font-size:10.0pt;color:navy"> : The Oval Office Park , Ground Floor Kingsmead, Meadowbrook Lane, Bryanston</span><span style="font-size:10.0pt;color:#333333">
</span><span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:30.75pt">
<td style="padding:0in 0in 0in 0in;height:30.75pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="199" style="width:149.25pt">
<tbody>
<tr>
<td width="44" style="width:33.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><img width="44" height="36" id="_x0000_i1031" src="cid:image002.jpg@01D02F43.B2765C40" alt="site-award-logo"></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="66" style="width:49.5pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><img width="65" height="36" id="_x0000_i1030" src="cid:image003.jpg@01D02F43.B2765C40" alt="site-aita-logo"></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="33" style="width:24.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="https://twitter.com/intent/follow?original_referer=http%3A%2F%2Fwww.linkedin.com%2Fprofile%2Fview%3Fid%3D7202140%26locale%3Den_US%26trk%3Dtyah&region=follow_link&screen_name=sandmandavid&source=followbutton&variant=2.0"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="33" height="35" id="_x0000_i1029" src="cid:image004.jpg@01D02F43.B2765C40"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="27" style="width:20.25pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.facebook.com/UwinIwinIncentives"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="33" height="35" id="_x0000_i1028" src="cid:image005.jpg@01D02F43.B2765C40" alt="czxc"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="41" style="width:30.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.linkedin.com/company/uwin-iwin-incentives?trk=fc_badge"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="33" height="35" id="_x0000_i1027" src="cid:image006.jpg@01D02F43.B2765C40"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="41" style="width:30.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.linkedin.com/company/uwin-iwin-incentives?trk=fc_badge"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="65" height="36" id="_x0000_i1026" src="cid:image007.jpg@01D02F43.B2765C40"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1177" style="width:882.75pt">
<tbody>
<tr style="height:80.25pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:80.25pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="540" style="width:405.0pt">
<tbody>
<tr>
<td style="border:solid lightgrey 1.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.uwiniwin.net/"><span style="font-size:8.5pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="758" height="114" id="_x0000_i1025" src="cid:image008.jpg@01D02F43.B2765C40"></span></a><span style="font-size:8.5pt;font-family:"Times New Roman",serif;color:#093362"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 1.5pt">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="758" style="width:568.5pt">
<tbody>
<tr>
<td width="758" valign="top" style="width:568.5pt;padding:0in 0in 0in 1.5pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;color:#2A5E2D">Please consider the environment before printing this email-</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 1.5pt">
<p class="MsoNormal"><span style="font-size:7.5pt;color:#2A5E2D">The views expressed in this e-mail are, unless otherwise stated, those of the author and not those of Uwin Iwin Incentives (PTY) LTD or its management. The information in this e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for
whatever reason, corrupted or does not reach its intended destination.</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>