<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><div><br></div><div><pre style="background-color:rgb(240,240,240);color:rgb(165,42,42);padding:5px;margin-left:40px;margin-right:30px;word-wrap:break-word;word-break:break-all;overflow:auto;font-size:12px">
$ pcp_node_info 10 localhost 9898 postgres hogehoge 0
host1 5432 1 1073741823.500000
The result is in the following order:
1. hostname
2. port number
3. status
4. load balance weight
Status is represented by a digit from [0 to 3].
0 - This state is only used during the initialization. PCP will never display it.
1 - Node is up. No connections yet.
2 - Node is up. Connections are pooled.
3 - Node is down.</pre><pre style="background-color:rgb(240,240,240);color:rgb(165,42,42);padding:5px;margin-left:40px;margin-right:30px;word-wrap:break-word;word-break:break-all;overflow:auto;font-size:12px"><br></pre><pre style="background-color:rgb(240,240,240);color:rgb(165,42,42);padding:5px;margin-left:40px;margin-right:30px;word-wrap:break-word;word-break:break-all;overflow:auto;font-size:12px">
Have a good day.</pre><br><div class="gmail_quote">2013/7/8 Jayadevan M <span dir="ltr"><<a href="mailto:jayadevan.maymala@ibsplc.com" target="_blank">jayadevan.maymala@ibsplc.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> </p>
<p><span>1)<span style="font:7.0pt "Times New Roman"">
</span></span>I am testing pgpool failover for PostgreSQL streaming replication. When I shutdown the master server, I had to restart pgpool so that it would redirect new requests to the slave. It did use the failover command and promote standby to master before
I resorted to restarting pgpool. What parameters would impact this behavior – i.e. when a new request comes in, redirect it to the slave (now master)?</p>
<p><span>2)<span style="font:7.0pt "Times New Roman"">
</span></span>I ran pgpool in debug mode to get the health check values, to see how quickly it responded, and have the following lines</p>
<p>DEBUG: pid 14549: health_check: 0 th DB node status: 1</p>
<p>DEBUG: pid 14549: health_check: 1 th DB node status: 1</p>
<p>DEBUG: pid 14549: health_check: 0 th DB node status: 2</p>
<p>DEBUG: pid 14549: health_check: 1 th DB node status: 2</p>
<p>DEBUG: pid 14549: health_check: 0 th DB node status: 3</p>
<p>DEBUG: pid 14549: health_check: 1 th DB node status: 2</p>
<p>DEBUG: pid 14549: health_check: 0 th DB node status: 3</p>
<p>DEBUG: pid 14549: health_check: 1 th DB node status: 2</p>
<p>DEBUG: pid 14549: health_check: 0 th DB node status: 3</p>
<p>DEBUG: pid 14549: health_check: 1 th DB node status: 2</p>
<p>DEBUG: pid 14549: health_check: 0 th DB node status: 3</p>
<p> </p>
<p>The significance of the status values – 1,2 and 3, are they documented somewhere? What do they mean?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"">Thanks for all the great work you are doing with pgpool and timely replies.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif""> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"">Regards,</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"">Jayadevan
</span></p>
<p class="MsoNormal"> </p>
</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>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">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><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>El genio es 1% inspiración y 99% transpiración.<br>Thomas Alva Edison<br><a href="http://pglearn.blogspot.mx/" target="_blank">http://pglearn.blogspot.mx/</a><br>
<div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div><br></div>
</div>