<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)">
<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:windowtext;}
.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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">I’m having problems with arping .<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We have two pgpool servers using watchdog, if I stop pgpool on the primary pgpool watchdog will failover to the secondary pgpool server. But the setting for arping in pgpool.conf floods our network arp request, which cause the network to
fail. I have tried different setting for the arping commard, then the network never knows about the failover of watchdog.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here are the different setting I have tried<o:p></o:p></p>
<p class="MsoNormal">arping_cmd = 'arping -U $_IP_$ -w 1' : Floods network with arp request<o:p></o:p></p>
<p class="MsoNormal">arping_cmd = 'arping -U $_IP_$ -w 1 –c 100’: Network never see failover<o:p></o:p></p>
<p class="MsoNormal">arping_cmd = 'arping -U $_IP_$ -w 1 –c 1000’: Network never see failover<o:p></o:p></p>
<p class="MsoNormal">arping_cmd = 'arping -U $_IP_$ -w 1 –c 5000’: Network never see failover<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Servers: Ubuntu 14.04.3<o:p></o:p></p>
<p class="MsoNormal">Pgpool: 3.4.3<o:p></o:p></p>
<p class="MsoNormal">PostgreSQL: 9.4.5<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here is the setting we have in pgpool.conf<o:p></o:p></p>
<p class="MsoNormal"># - Virtual IP control Setting -<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">delegate_IP = 'My_IP_ADDRESS'<o:p></o:p></p>
<p class="MsoNormal"> # delegate IP address<o:p></o:p></p>
<p class="MsoNormal"> # If this is empty, virtual IP never bring u<o:p></o:p></p>
<p class="MsoNormal">p.<o:p></o:p></p>
<p class="MsoNormal"> # (change requires restart)<o:p></o:p></p>
<p class="MsoNormal">ifconfig_path = '/sbin'<o:p></o:p></p>
<p class="MsoNormal"> # ifconfig command path<o:p></o:p></p>
<p class="MsoNormal"> # (change requires restart)<o:p></o:p></p>
<p class="MsoNormal">if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'<o:p></o:p></p>
<p class="MsoNormal"> # startup delegate IP command<o:p></o:p></p>
<p class="MsoNormal"> # (change requires restart)<o:p></o:p></p>
<p class="MsoNormal">if_down_cmd = 'ifconfig eth0:0 down'<o:p></o:p></p>
<p class="MsoNormal"> # shutdown delegate IP command<o:p></o:p></p>
<p class="MsoNormal"> # (change requires restart)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">arping_path = '/usr/local/sbin' # arping command path<o:p></o:p></p>
<p class="MsoNormal"> # (change requires restart)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">arping_cmd = 'arping -U $_IP_$ -w 1 -c 5000'<o:p></o:p></p>
<p class="MsoNormal"> # arping command<o:p></o:p></p>
<p class="MsoNormal"> # (change requires restart)<o:p></o:p></p>
</div>
</body>
</html>