<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} .ms-cui-menu {background-color:#ffffff;border:1px rgb(171, 171, 171) solid;font-family:"Microsoft YaHei UI", "Microsoft YaHei", 微软雅黑, SimSun, 宋体, sans-serif;font-size:11pt;color:rgb(51, 51, 51);} .ms-cui-menusection-title {display:none;} .ms-cui-ctl {vertical-align:text-top;text-decoration:none;color:rgb(51, 51, 51);} .ms-cui-ctl-on {background-color:rgb(223, 237, 250);opacity: 0.8;} .ms-cui-img-cont-float {display:inline-block;margin-top:2px} .ms-cui-smenu-inner {padding-top:0px;} .ms-owa-paste-option-icon {margin: 2px 4px 0px 4px;vertical-align:sub;padding-bottom: 2px;display:inline-block;} .ms-rtePasteFlyout-option:hover {background-color:rgb(223, 237, 250) !important;opacity:1 !important;} .ms-rtePasteFlyout-option {padding:8px 4px 8px 4px;outline:none;} .ms-cui-menusection {float:left; width:85px;height:24px;overflow:hidden}
<!--
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-menusection-title
{}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
-->
<!--
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
-->
<!--
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
-->
--></style>
</head>
<body>
<div style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<style type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-menusection-title
{}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
-->
</style>
<div style="font-size: 12pt; color: #000000; background-color: #ffffff; font-family: calibri, arial, helvetica, sans-serif;">
<style type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
-->
</style>
<div style="font-size: 12pt; color: #000000; background-color: #ffffff; font-family: calibri, arial, helvetica, sans-serif;">
<style type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
.ms-cui-menu
{background-color:#ffffff;
border:1px rgb(171,171,171) solid;
font-family:"Microsoft YaHei UI","Microsoft YaHei",微软雅黑,SimSun,宋体,sans-serif;
font-size:11pt;
color:rgb(51,51,51)}
.ms-cui-ctl
{vertical-align:text-top;
text-decoration:none;
color:rgb(51,51,51)}
.ms-cui-ctl-on
{background-color:rgb(223,237,250)}
.ms-cui-img-cont-float
{display:inline-block;
margin-top:2px}
.ms-cui-smenu-inner
{padding-top:0px}
.ms-owa-paste-option-icon
{margin:2px 4px 0px 4px;
vertical-align:sub;
padding-bottom:2px;
display:inline-block}
.ms-rtePasteFlyout-option
{padding:8px 4px 8px 4px;
outline:none}
.ms-cui-menusection
{float:left;
width:85px;
height:24px;
overflow:hidden}
-->
</style>
<div style="font-size: 12pt; color: #000000; background-color: #ffffff; font-family: calibri, arial, helvetica, sans-serif;">
<p>Hi <span style="font-family: calibri, sans-serif; font-size: 14.6667px; background-color: #ffffff;">Muhammad Usama</span>:<br>
</p>
<p><span> </span>Thanks for the suggestions you giving and the help you provided during my development. I have rebased my patch with the current head of the master branch.</p>
<p>And,in this patch,I used <span style="color: #282828; font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; background-color: #ffffff;"> (</span><span style="color: #282828; font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; background-color: #ffffff;">--scope=cluster)</span>
to implement the cluster mode.<br>
</p>
<p><br>
</p>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
How to use the patch to test pcp_reload_config command<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
1、do patch under the directory of pgpool<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
patch -p1 < pcp_reload_config.patch<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
2、you should need automake and autoconf<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
<br>
</div>
<pre style="font-size: 16px; margin-top: 14pt; margin-bottom: 14pt;">for example:
$ autoheader
$ aclocal
$ automake -a -c
$ autoconf
</pre>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
3、then to do make and make install<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
4、under the directory of bin，you can find the pcp_reload_config <br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
./pcp_reload_config -s c or ./pcp_reload_config --scope=cluster<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
this can reload the config file of all pgpool nodes<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
./pcp_reload_config or ./pcp_reload_config -s l or ./pcp_reload_config --scope=local<br>
</div>
<div style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px; margin-top: 0px; margin-bottom: 0px;">
this can only reload the config file of local pgpool node<br>
</div>
<p><br>
</p>
<p style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px;"><span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Thanks</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Best regards</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
Zhou Jianshen</p>
<p style="font-family: calibri, arial, helvetica, sans-serif; font-size: 16px;"><span style="font-family: verdana; font-size: 13.3333px; background-color: #ffffff;"><a href="mailto:zhoujianshen@highgo.com" target="_blank">zhoujianshen@highgo.com</a></span></p>
<div style="color: #282828;">
<hr tabindex="-1" style="display: inline-block; width: 98%;">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size: 11pt;"><b>发件人:</b> Muhammad Usama <m.usama@gmail.com><br>
<b>发送时间:</b> 2020年5月4日 21:43<br>
<b>收件人:</b> 周建身<br>
<b>抄送:</b> pgpool-hackers; Muhammad<br>
<b>主题:</b> Re: [pgpool-hackers: 3606] add the command of pcp_reload_config</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div dir="ltr">Hi Zhou Jianshen,
<div><br>
</div>
<div>Welcome to the Pgpool-II community and thanks for the patch.</div>
<div><br>
</div>
<div>I just committed a reorganization patch and now this patch does not apply anymore</div>
<div>so can you please rebase it with the current head of the master branch.</div>
<div><br>
</div>
<div>Secondly, you need to implement the cluster mode (--scope=cluster) for the</div>
<div>PCP reload config utility as well.</div>
<div><br>
</div>
<div>For the reference, you can see the implementation same ( scope=cluster)</div>
<div>in the pcp_stop_pgpool utility.</div>
<div><br>
</div>
<div><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=87e6e11c1931555e90a1cc65cc3ee79759ebaaab">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=87e6e11c1931555e90a1cc65cc3ee79759ebaaab</a><br>
</div>
<div><br>
</div>
<div>You can find more info on steps for executing the command over watchdog network</div>
<div>in the following email.</div>
<div><br>
</div>
<div><a href="https://www.pgpool.net/pipermail/pgpool-hackers/2020-May/003608.html">https://www.pgpool.net/pipermail/pgpool-hackers/2020-May/003608.html</a><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Do let me know if you need further information or clarification</div>
<div><br>
</div>
<div>Best Regards</div>
<div>
<div><span style="color: #000000; font-family: calibri, arial, helvetica, sans-serif; font-size: 16px;"><br>
</span></div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Apr 29, 2020 at 12:10 PM 周建身 <<a href="mailto:zhoujianshen@highgo.com" target="_blank">zhoujianshen@highgo.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;">
<div>
<div style="font-size: 12pt; color: #000000; background-color: #ffffff; font-family: calibri, arial, helvetica, sans-serif;">
<p><span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 15px; background-color: #ffffff;">Hi Hackers,</span><br>
</p>
<p><span> </span>As Usama Muhammad said in his email before,we should enhance/add the PCP utilities more cluster-mode friendly.</p>
<p>There are four commands which need to be added or enhanced.The first command which should be added is pcp_reload_config.<br>
</p>
<p><span> </span><br>
</p>
<p><span> <span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">1- pcp_reload_config</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">==================</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">The utility to make the whole Pgpool-II cluster to reload the</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">configuration files at once.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">I think this is required because currently if some installation has</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">let say 3 node Pgpool-II cluster</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">and we want to change one specific configuration parameter ( for</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">example: adding a new backend node)</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">we would require to go on and edit Pgpool configuration files on each</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">node separately and then</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">issue pgpool reload on each node one by one.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">In my opinion, we need multiple enhancement in this area.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">We need some mechanisms to let pgpool-II cluster use the centralized</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">configuration</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">( except watchdog config) or at least a mechanism to push the</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">configuration settings using some</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">new utility like "pcp_load_config" that could take a pgpool.conf file</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">and propagate it to all nodes</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">using watchdog.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">The centralized configuration part of the problem is a big task and I</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">believe we could take it on after the</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">"simplifying watchdog config" feature that Peng is working on.</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Meanwhile, I think we can work on pcp_reload_config utility in</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">parallel to make reloading part easier.</span></span><br>
</p>
<p><span><br>
</span></p>
<p><span><br>
</span></p>
<p><span>I tried to solve this command.And I realized reloading the configuration of an individual node.After Peng's working on </span></p>
<p><span>watchdog config,we can eventually realize the reloading the configurations of all nodes.</span></p>
<p><span><br>
</span></p>
<p><span>How to use the patch,</span></p>
<p>1、do patch under the directory of pgpool-II-4.1.1<br>
</p>
<p>patch -p1 < pcp_reload_config.patch<br>
</p>
<p>2、you should need automake and autoconf<br>
</p>
<p><br>
</p>
<pre style="white-space: pre-wrap;">for example:
$ autoheader
$ aclocal
$ automake -a -c
$ autoconf<br></pre>
<p>3、then to do make and make install</p>
<p><br>
</p>
<p>4、under the directory of bin，you can find the pcp_reload_config ,try is as ./pcp_reload_config<br>
</p>
<p><span> </span></p>
<p><span><br>
</span></p>
<p><span>Comments and suggestions are welcome.</span></p>
<p><span><br>
</span></p>
<p><span><span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Thanks</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
<span style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">Best regards</span><br style="color: #282828; font-family: "microsoft yahei ui", "microsoft yahei", 微软雅黑, simsun, 宋体, sans-serif; font-size: 13.3333px; background-color: #ffffff;">
Zhou Jianshen</span></p>
<p><span><span style="font-family: verdana; font-size: 13.3333px; background-color: #ffffff;"><a href="mailto:zhoujianshen@highgo.com" target="_blank">zhoujianshen@highgo.com</a></span><br>
</span></p>
<p><span><br>
</span></p>
</div>
</div>
_______________________________________________<br>
pgpool-hackers mailing list<br>
<a href="mailto:pgpool-hackers@pgpool.net" target="_blank">pgpool-hackers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div style="color: #000000;">
<div>
<div><span style="color: #444444;">...<br>
</span></div>
<div><span style="color: #444444;">Muhammad Usama<br>
</span></div>
<div><span><span style="font-family: lato;"><span style="font-size: 14px;"><span style="color: #444444;">Highgo Software (Canada/China/Pakistan)</span><span><span style="color: #444444;"> </span></span></span></span></span><span style="color: #444444;"><br>
</span></div>
<div><span><span style="font-family: lato;"><span style="font-size: 14px;"><span style="color: #444444;">URL :</span><span><span style="color: #444444;"> </span></span></span></span></span><a href="http://www.highgo.ca/" target="_blank" style="color: #598fde; font-family: lato; font-size: 14px;"><span style="color: #444444;">http://www.highgo.ca</span></a><span><span style="font-family: lato;"><span style="font-size: 14px;"><span><span style="color: #444444;"> </span></span></span></span></span><span style="color: #444444;"><br>
</span></div>
<div><span><span style="font-family: lato;"><span style="font-size: 14px;"><span style="color: #444444;">ADDR: 10318 WHALLEY BLVD, Surrey, BC</span><span><span style="color: #444444;"> </span></span></span></span></span><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>