<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:Consolas}
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline}
p
        {margin-right:0in;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif"}
pre
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New"}
span.HTMLPreformattedChar
        {font-family:Consolas}
span.EmailStyle20
        {font-family:"Calibri","sans-serif";
        color:#1F497D}
.MsoChpDefault
        {font-family:"Calibri","sans-serif"}
@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="font-size:11.0pt; font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;; color:#1F497D">Thank you.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;; color:#1F497D">&nbsp;</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:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span style="font-size:10.0pt; font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> Rene Romero Benavides [mailto:rene.romero.b@gmail.com]
<br>
<b>Sent:</b> Monday, July 08, 2013 8:10 PM<br>
<b>To:</b> Jayadevan M<br>
<b>Cc:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> Re: [pgpool-general: 1876] pgpool status values</span></p>
</div>
</div>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal"><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_node_info">http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_node_info</a></p>
<div>
<p class="MsoNormal">&nbsp;</p>
</div>
<div>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all; word-wrap:break-word; overflow:auto"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">$ pcp_node_info 10 localhost 9898 postgres hogehoge 0</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">host1 5432 1 1073741823.500000</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">The result is in the following order:</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">1. hostname</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">2. port number</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">3. status</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">4. load balance weight</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">Status is represented by a digit from [0 to 3].</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">0 - This state is only used during the initialization. PCP will never display it.</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">1 - Node is up. No connections yet.</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">2 - Node is up. Connections are pooled.</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">3 - Node is down.</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all; word-wrap:break-word; overflow:auto"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all; word-wrap:break-word; overflow:auto"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:30.0pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">&nbsp;</span></pre>
<pre style="margin-right:22.5pt; margin-bottom:0in; margin-left:35.25pt; margin-bottom:.0001pt; background:#F0F0F0; word-break:break-all"><span style="font-size:9.0pt; color:brown">Have a good day.</span><span style="font-size:9.0pt; color:#1F497D"></span></pre>
<pre style="margin-right:22.5pt; background:#F0F0F0; word-break:break-all"><span style="font-size:11.0pt; font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;; color:#1F497D">&nbsp;</span></pre>
</div>
</div>
</div>
<br>
<br>
DISCLAIMER: <font color="#999999" size="1" face="Tahoma">&quot;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.&quot;</font><br>
<font size="1"></font>
</body>
</html>