<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;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Thanks David. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The VIP question is for PGPOOL watch dog failover, not the database failover. Sorry my question was not clear.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco) [mailto:dsisk@cisco.com]
<br>
<b>Sent:</b> Thursday, December 08, 2016 10:02 AM<br>
<b>To:</b> KALAGARA, KASTURI <KK1674@att.com>; pgpool-general@pgpool.net<br>
<b>Subject:</b> RE: install pgpool II as non-root user<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><a name="_MailEndCompose"><span style="color:#1F497D">For RHEL, use the rpm package, unless you simply cannot do it as root and don’t have sudo privs. I don’t know if there’s a tarball, but I’m sure someone will pipe in…<o:p></o:p></span></a></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">For automatic failover with PGPool, you don’t need to move a VIP…PGPool (if configured correctly) will, once detecting the primary is down, 1) kill all app connections to the primary, 2) issue the pg_ctl promote
on the standby (or whatever commands or script you’ve configured), then 3) reconnect all the app connections to the new primary…the app will see errors/disconnects while this is happening (takes a few seconds).
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">IMO, moving a VIP (or changing a DNS entry) is the worst possible way to failover a database…it almost guarantees you’ll have a “split-brain” for some period of time.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">HTH,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="543" style="width:407.25pt">
<tbody>
<tr>
<td colspan="3" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="color:#1F497D"><img width="543" height="70" style="width:5.6562in;height:.7291in" id="Picture_x0020_1" src="cid:image003.png@01D2513B.53B72EC0" alt="banner2"></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:7.5pt">
<td style="padding:0in 0in 0in 0in;height:7.5pt">
<p class="MsoNormal"><span style="font-size:1.0pt;font-family:"Times New Roman",serif;color:#1F497D"> <o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in;height:7.5pt"></td>
<td style="padding:0in 0in 0in 0in;height:7.5pt"></td>
</tr>
<tr>
<td nowrap="" valign="top" style="padding:0in 0in 0in .25in">
<p class="MsoNormal"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">David Sisk</span></b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Engineer - Software<o:p></o:p></span></p>
<p class="MsoNormal"><a href="mailto:dsisk@cisco.com"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666;text-decoration:none">dsisk@cisco.com</span></a><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Tel:
<o:p></o:p></span></p>
</td>
<td width="275" valign="top" style="width:206.25pt;padding:0in 0in 0in 15.0pt">
<p class="MsoNormal"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Cisco Systems, Inc.<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">7025-6 Kit Creek Road PO Box 14987<br>
RESEARCH TRIANGLE PARK<br>
27709-4987<br>
United States<br>
cisco.com<o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="400" style="width:300.0pt">
<tbody>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#009900"><img border="0" width="18" height="19" style="width:.1875in;height:.1979in" id="Picture_x0020_3" src="cid:image005.jpg@01D2513B.53B72EC0" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think
before you print.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is
strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">Please
</span><a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#0E58A0">click here</span></a><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">
for Company Registration Information.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:pgpool-general-bounces@pgpool.net">
pgpool-general-bounces@pgpool.net</a> [<a href="mailto:pgpool-general-bounces@pgpool.net">mailto:pgpool-general-bounces@pgpool.net</a>]
<b>On Behalf Of </b>KALAGARA, KASTURI<br>
<b>Sent:</b> Wednesday, December 7, 2016 6:05 PM<br>
<b>To:</b> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> [pgpool-general: 5155] install pgpool II as non-root user<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is it possible to install pg-pool II as non-root user? Is Tar ball install available for RHEL?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If setting up pg-pool 11 primary and standby for redundancy, how is the VIP failover controlled?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal">Kasturi<o:p></o:p></p>
</div>
</body>
</html>