<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
@font-face
{font-family:"Trebuchet MS"}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
span.BalloonTextChar
{font-family:"Tahoma","sans-serif"}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{margin-right:0in;
margin-left:0in;
font-size:10.0pt;
font-family:"Times New Roman","serif"}
span.emailstyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
span.emailstyle18
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.EmailStyle22
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.EmailStyle23
{font-family:"Calibri","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi,</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Like this – </span></p>
<p class="MsoNormal"><span style="color:#1F497D">pgpool -d -D -f /etc/pgpool.conf > /tmp/pgpool.log 2>&1</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">The –d option runs it in debug mode</span></p>
<p class="MsoNormal"><span style="color:#1F497D">-D option makes it ‘ignore’ existing status and start afresh. So it discards the fact that it had ‘failed over’ to the secondary server and connects to the primary server.</span></p>
<p class="MsoNormal"><span style="color:#1F497D">-f tells it which configuration file to use</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Jayadevan</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<div style="border:none; border-left:solid blue 1.5pt; padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Wolf Schwurack [mailto:wolf@uen.org]
<br>
<b>Sent:</b> Monday, May 06, 2013 6:43 PM<br>
<b>To:</b> Jayadevan M<br>
<b>Subject:</b> RE: pgpool and failover</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="color:#1F497D">Can you share on how you did this</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Wolf</span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">
<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>
<a href="mailto:[mailto:pgpool-general-bounces@pgpool.net]">[mailto:pgpool-general-bounces@pgpool.net]</a>
<b>On Behalf Of </b>Jayadevan M<br>
<b>Sent:</b> Monday, May 06, 2013 2:26 AM<br>
<b>To:</b> 'pgpool-general@pgpool.net'<br>
<b>Subject:</b> [pgpool-general: 1683] Re: pgpool and failover</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Hi,</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Answering my own question – </span>
</p>
<p class="MsoNormal"><span style="color:#1F497D">Use –D option.</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Jayadevan</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<div style="border:none; border-left:solid blue 1.5pt; padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Jayadevan M
<br>
<b>Sent:</b> Monday, May 06, 2013 1:14 PM<br>
<b>To:</b> 'pgpool-general@pgpool.net'<br>
<b>Subject:</b> pgpool and failover</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I am testing pgpool with streaming replication. There is one master and one slave. When I shut down the master, the requests were redirected to the slave. So far so good. I want to test a few more scenarios. Now that I have the primary
master up, how do I make pgpool send connections to the master? It is still sending all requests to the slave.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Regards,</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Jayadevan M</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Senior Technical Architect - TCC</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">IBS Software Services Private Limited</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">5th Floor/NILA, Technopark Campus, Trivandrum 695 581, Kerala, India</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Phone: +91- 471-6614352 Mobile: +91 94952 00950</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Email:
<a href="mailto:Jayadevan.Maymala@ibsplc.com">Jayadevan.Maymala@ibsplc.com</a> <a href="http://www.ibsplc.com/">
www.ibsplc.com</a></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""><br>
<br>
DISCLAIMER: </span><span style="font-size:7.5pt; font-family:"Tahoma","sans-serif"; color:#999999">"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material.
If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this
email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."</span><span style="font-size:12.0pt; font-family:"Times New Roman","serif""></span></p>
</div>
</div>
<br>
<br>
DISCLAIMER: <font color="#999999" size="1" face="Tahoma">"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in
error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not
liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."</font><br>
<font size="1"></font>
</body>
</html>