<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=utf-8">
<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;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Jon, <o:p></o:p></p>
<p class="MsoNormal">Also know that the primary and leader are not necessarily the same thing. The primary is the node that allows RW access, the leader hosts the VIP.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Todd Stein <br>
<b>Sent:</b> Monday, September 12, 2022 8:37 PM<br>
<b>To:</b> Umar Hayat <m.umarkiani@gmail.com>; Jon SCHEWE <jon.schewe@raytheon.com><br>
<b>Cc:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> RE: [pgpool-general: 8388] Re: Determine primary frontend<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">You can also use the parameter wd_priority to control the order that the Leader is elected.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> pgpool-general <<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>>
<b>On Behalf Of </b>Umar Hayat<br>
<b>Sent:</b> Monday, September 12, 2022 8:34 PM<br>
<b>To:</b> Jon SCHEWE <<a href="mailto:jon.schewe@raytheon.com">jon.schewe@raytheon.com</a>><br>
<b>Cc:</b> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> [pgpool-general: 8388] Re: Determine primary frontend<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Jon,<br>
Leader watchdog node holds the VIP, try <span style="color:black;background:#F7F7F7"><a href="https://www.pgpool.net/docs/latest/en/html/pcp-watchdog-info.html" target="_blank">pcp_watchdog_info</a> </span>to get current leader host information.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Umar Hayat<br>
<a href="http://bitnine.net">Bitnine Inc</a><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Sep 13, 2022 at 7:33 AM Jon SCHEWE <<a href="mailto:jon.schewe@raytheon.com" target="_blank">jon.schewe@raytheon.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal">Is there a way to query pgpool to determine which host is the primary frontend? Or is the only way to determine this to check the IP addresses on all potential frontends to see which one has the virtual IP?<br>
<br>
Jon<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</body>
</html>