<html 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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 0 5 0 0 0 0 0 0 0;}
@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:12.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;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0in;
margin-bottom:.0001pt;
background:#D7D3B7;
font-size:9.0pt;
font-family:Courier;
color:#3B2322;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
p.p2, li.p2, div.p2
{mso-style-name:p2;
margin:0in;
margin-bottom:.0001pt;
background:#D7D3B7;
font-size:9.0pt;
font-family:Courier;
color:#3B2322;}
.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>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">I have setup some new Ubunut 20.04 hosts with Pgpool-II-4.1.1 using watchdog but unable to get watchdog to work on Ubuntu 20.04<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: LOG:</span><span class="apple-converted-space">
</span><span class="s1">Setting up socket for :::9999</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: LOG:</span><span class="apple-converted-space">
</span><span class="s1">perhaps failed to create INET domain socket</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: DETAIL:</span><span class="apple-converted-space">
</span><span class="s1">socket(::) failed: "Address family not supported by protocol"</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: LOG:</span><span class="apple-converted-space">
</span><span class="s1">find_primary_node_repeatedly: waiting for finding a primary node</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: LOG:</span><span class="apple-converted-space">
</span><span class="s1">find_primary_node: primary node is 0</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: LOG:</span><span class="apple-converted-space">
</span><span class="s1">find_primary_node: standby node is 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 11:50:11: pid 7727: LOG:</span><span class="apple-converted-space">
</span><span class="s1">pgpool-II successfully started. version 4.1.1 (karasukiboshi)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">…<o:p></o:p></span></p>
<p class="p1"><span class="s1">2020-05-07 11:50:23: pid 7731: LOG:</span><span class="apple-converted-space">
</span><span class="s1">Watchdog is shutting down</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I check for the IP with # ip a – No watchdog started<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">2: ens160: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">link/ether 00:50:56:b3:d3:58 brd ff:ff:ff:ff:ff:ff</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">inet 10.11.0.205/24 brd 10.11.0.255 scope global ens160</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">valid_lft forever preferred_lft forever</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">To start the secondary IP from the command line I can use<o:p></o:p></span></p>
<p class="p1"><span class="s1">ip addr add 10.11.0.204/24 dev ens160 label ens160:1</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">if I put this command in pgpool.conf it doesn’t start watchdog<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">But If I run the command from the command line, It creates the secondary IP for watchdog<o:p></o:p></span></p>
<p class="p1"><span class="s1">2: ens160: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">link/ether 00:50:56:b3:d3:58 brd ff:ff:ff:ff:ff:ff</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">inet 10.11.0.205/24 brd 10.11.0.255 scope global ens160</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">valid_lft forever preferred_lft forever</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">inet 10.11.0.204/24 scope global secondary ens160:1</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I comment out if_up_cmd and and if_down_cmd in pgpool.conf<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Then I start pgpool, still get this in pgpool.log<o:p></o:p></span></p>
<p class="p1"><span class="s1">2020-05-07 12:02:12: pid 8130: LOG:</span><span class="apple-converted-space">
</span><span class="s1">perhaps failed to create INET domain socket</span><o:p></o:p></p>
<p class="p1"><span class="s1">2020-05-07 12:02:12: pid 8130: DETAIL:</span><span class="apple-converted-space">
</span><span class="s1">socket(::) failed: "Address family not supported by protocol"</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">but no message that watchdog is down<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Then I test the connection, it work<o:p></o:p></span></p>
<p class="p1"><span class="s1">$ psql -h wd-pgtest -p 9999 -U postgres</span><o:p></o:p></p>
<p class="p1"><span class="s1">psql (12.2 (Ubuntu 12.2-4))</span><o:p></o:p></p>
<p class="p1"><span class="s1">Type "help" for help.</span><o:p></o:p></p>
<p class="p2"><o:p> </o:p></p>
<p class="p1"><span class="s1">postgres=#</span><span class="apple-converted-space"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">My question is why can’t I get the command to work in pgpool.conf?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Wolfgang Schwurack<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Database/System Administrator<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Utah Education Network<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">801-587-9444<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="mailto:wolf@uen.org"><span style="color:#0B4CB4">wolf@uen.org</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>