<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-2022-jp">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div dir="auto" style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Meiryo, "$B%a%$%j%*(B", "Hiragino Sans", sans-serif; font-size: 12pt;" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof">$BWE$5$s(B</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"><br>
>- psql $B$G(B 192.168.0.100 $B$K@\B3$G$-$^$9$,!"(BZabbix Web$B%$%s%?!<%U%'!<%9$+$i@\B3$G$-$J$$$N$G$7$g$&$+!#(B</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"><br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"> $B!!(BPgpool-II($B%j!<%@!<(B) $B$H(BPostgreSQL Primary $B$,%$%3!<%k$N>l9g$O(B VIP$B$N(B 192.168.0.100 $B$G(B Zabbxi Web OK$B$G$9!#(B</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"> <font size="2"><span style="font-size:11pt">$B!!(BPgpool-II($B%j!<%@!<(B) $B$H(BPostgreSQL Primary $B$,%$%3!<%k$G$J$$>l9g$O(B VIP$B$N(B 192.168.0.100 $B$G(B Zabbxi Web NG$B$G$9!#(B</span></font><br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"><br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof">>- $B>e5-(B show pool_nodes $B$N7k2L$O!"%U%'%$%k%*!<%P!<8e!"(B192.168.0.100 $B$KBP$7$F<B9T$7$?7k2L$G$7$g$&$+!#(B<br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"><br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"><font size="2"><span style="font-size:11pt">$B!!(B[root@pg-b ~]</span></font>$B$NC<Kv$N$^$^$G%R%9%H%j$+$i<B9T$7$?7k2L$G$9$N$G!"F1$8C<Kv$H$J$j$^$9!#(B<br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof"><br>
</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<font size="2"><span style="font-size:11pt" class="elementToProof">>- Zabbix Web $B$G@_Dj$7$?(BDB$B$N%[%9%H$O(B 192.168.0.100 $B$G$7$g$&$+!#(B<br>
 > ($B%P!<%8%g%s$K$h$C$F%U%!%$%k$,0[$J$k$+$b$7$l$^$;$s$,!"(Bzabbix.conf.php $B$N(B $DB['SERVER'] $B$K;XDj$7$?CM(B)</span></font></div>
<div dir="auto" style="color:rgb(33,33,33); background-color:rgb(255,255,255)" class="elementToProof">
<br>
</div>
<div style="font-family: Meiryo, "$B%a%$%j%*(B", "Hiragino Sans", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
$B!!(Bzabbix server 6.0.4$B$K$J$j$^$9!#(B<br>
</div>
<div style="font-family: Meiryo, "$B%a%$%j%*(B", "Hiragino Sans", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Meiryo, "$B%a%$%j%*(B", "Hiragino Sans", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Meiryo, "$B%a%$%j%*(B", "Hiragino Sans", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Meiryo, "$B%a%$%j%*(B", "Hiragino Sans", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Bo Peng <pengbo@sraoss.co.jp><br>
<b>Sent:</b> Thursday, May 12, 2022 1:20:47 PM<br>
<b>To:</b> pgpool-general-jp@sraoss.jp <pgpool-general-jp@sraoss.jp><br>
<b>Cc:</b> yas see_ <yassee_@hotmail.com><br>
<b>Subject:</b> Re: [pgpool-general-jp: 1700] Re: watchdog$B$N<+F02>A[(BIP$B@ZBX$,$&$^$/F0:n$7$J$$(B</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="PlainText elementToProof">$BWE$G$9!#(B<br>
<br>
> $BWE$5$s!"%U%)%m!<$"$j$,$H$&$4$6$$$^$9!#(B<br>
> <br>
> >Pgpool $BJ#?tBf9=@.$N>l9g!"%/%i%$%"%s%H$,(B VIP $B7PM3$G(B Pgpool-II$B!J%j!<%@!<!K$K@\B3$7$^$9!#(B<br>
> >$B$=$N$?$a!"(BVIP $B$O(B PostgreSQL $B$G$O$J$/!"(BPgpool-II$B$N%j!<%@!<%N!<%I$KI3$E$/$b$N$H$J$j$^$9!#(B<br>
> >Pgpool-II $B%j!<%@!<%N!<%I$,@Z$jBX$o$k:]$K!"(BVIP $B$N@Z$jBX$($,<+F0E*$K9T$o$l$^$9!#(B<br>
> <br>
> $B$3$A$i$GH/@8$7$F$$$k>u67$O0J2<$H$J$j$^$9!#$3$NF0$-$O@5$7$$$N$G$7$g$&$+!#(B<br>
> $B$?$@$7$3$N>u67$G$O<+F0%U%'%$%k%*!<%P!<8e$O(B VIP(192.168.0.100)$B$G$O(BDB$B$K@\B3$G$-$:(B<br>
> zabbxi$B$N(BWeb$B$G$O(B Error connection to database $B$H$J$j$^$9!#(B<br>
> <br>
> <br>
> [root@pg-b ~]# psql -h 192.168.0.100 -p 9999 -U pgpool postgres -c "show pool_nodes"<br>
> <br>
>  node_id |   hostname   | port | status | pg_status | lb_weight |  role   | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change<br>
> ---------+--------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------<br>
>  0       | 192.168.0.92 | 5432 | up     | up        | 0.333333  | standby | standby | 0          | false             | 0                 | streaming         | async                  | 2022-05-11 22:06:51<br>
>  1       | 192.168.0.93 | 5432 | up     | up        | 0.333333  | primary | primary | 0          | true              | 0                 |                   |                        | 2022-05-11 22:02:44<br>
>  2       | 192.168.0.94 | 5432 | up     | up        | 0.333333  | standby | standby | 0          | false             | 0                 | streaming         | async                  | 2022-05-11 22:02:44<br>
> (3 $B9T(B)<br>
> <br>
> [root@pg-b ~]# pcp_watchdog_info -h 192.168.0.100 -p 9898 -U pgpool<br>
> Password:<br>
> 3 3 YES 192.168.0.93:9999 Linux pg-b 192.168.0.93<br>
> <br>
> 192.168.0.93:9999 Linux pg-b 192.168.0.93 9999 9000 4 LEADER 0 MEMBER<br>
> 192.168.0.92:9999 Linux pg-a 192.168.0.92 9999 9000 7 STANDBY 0 MEMBER<br>
> 192.168.0.94:9999 Linux pg-c 192.168.0.94 9999 9000 7 STANDBY 0 MEMBER<br>
> <br>
> $B!!!&>e5-$N>uBV$G(B VIP $B$+$i@\B3(BOK$B$J>uBV!#(Bpg-b$B$N(B eth0$B$,(B 192.168.0.93$B!"(Beth0:0$B$,(B 192.168.0.100 $B$G$9(B<br>
> $B!!!&(Bprimary (192.168.0.93)$B$N(BPostgreSQL$B$r<jF0Dd;_(B<br>
> $B!!!&<+F0%U%'%$%k%*!<%P!<$K$J$j!"0J2<$N>uBV$G$9!#(B<br>
> <br>
> $B!!(B# su - postgres<br>
>   $ /usr/pgsql-14/bin/pg_ctl -D /var/lib/pgsql/14/data -m immediate stop <br>
>  node_id |   hostname   | port | status | pg_status | lb_weight |  role   | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change<br>
> ---------+--------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------<br>
>  0       | 192.168.0.92 | 5432 | up     | up        | 0.333333  | primary | primary | 0          | true              | 0                 |                   |                        | 2022-05-11 22:22:00<br>
>  1       | 192.168.0.93 | 5432 | down   | down      | 0.333333  | standby | unknown | 0          | false             | 0                 |                   |                        | 2022-05-11 22:22:00<br>
>  2       | 192.168.0.94 | 5432 | up     | up        | 0.333333  | standby | standby | 0          | false             | 0                 | streaming         | async                  | 2022-05-11 22:22:56<br>
> (3 $B9T(B)<br>
> <br>
> [root@pg-b ~]# pcp_watchdog_info -h 192.168.0.100 -p 9898 -U pgpool<br>
> Password:<br>
> 3 3 YES 192.168.0.93:9999 Linux pg-b 192.168.0.93<br>
> <br>
> 192.168.0.93:9999 Linux pg-b 192.168.0.93 9999 9000 4 LEADER 0 MEMBER<br>
> 192.168.0.92:9999 Linux pg-a 192.168.0.92 9999 9000 7 STANDBY 0 MEMBER<br>
> 192.168.0.94:9999 Linux pg-c 192.168.0.94 9999 9000 7 STANDBY 0 MEMBER<br>
> <br>
> $B!!!&(Bprimary $B$O(B 192.168.0.92 $B$K$J$C$?(B<br>
> $B!!!&(BLEADER$B$O(B 192.168.0.93$B$N$^$^!#(Bpg-b$B$N(B eth0$B$,(B 192.168.0.93$B!"(Beth0:0$B$,(B 192.168.0.100$B$N$^$^(B<br>
> <br>
> $B!!"M$3$N>uBV(B $B$G(Bzabbxi$B$N(BWeb$B$G$O(B Error connection to database$B!#(B<br>
> <br>
> <br>
> $B2?$,@5$7$$F0:n$J$N$+M}2rITB-$J$N$G$9$,!">e5->uBV$G(B 192.168.0.100 $B$X$N%"%/%;%9$G(B<br>
> 192.168.0.92 $B$N(BDB$B$X@\B3$9$kF0$-$K$J$k$O$:$,!"$3$A$i$N4D6-$G$O$J$C$F$J$$$H$$$&$3$H$K$J$j$^$9$+!#(B<br>
<br>
$B0J2<$K$D$$$F3NG'$5$;$F$$$?$@$-$^$9!#(B<br>
<br>
- psql $B$G(B 192.168.0.100 $B$K@\B3$G$-$^$9$,!"(BZabbix Web$B%$%s%?!<%U%'!<%9$+$i@\B3$G$-$J$$$N$G$7$g$&$+!#(B<br>
- $B>e5-(B show pool_nodes $B$N7k2L$O!"%U%'%$%k%*!<%P!<8e!"(B192.168.0.100 $B$KBP$7$F<B9T$7$?7k2L$G$7$g$&$+!#(B<br>
- Zabbix Web $B$G@_Dj$7$?(BDB$B$N%[%9%H$O(B 192.168.0.100 $B$G$7$g$&$+!#(B<br>
  ($B%P!<%8%g%s$K$h$C$F%U%!%$%k$,0[$J$k$+$b$7$l$^$;$s$,!"(Bzabbix.conf.php $B$N(B $DB['SERVER'] $B$K;XDj$7$?CM(B)<br>
<br>
-- <br>
Bo Peng <pengbo@sraoss.co.jp><br>
SRA OSS, Inc. Japan<br>
<a href="https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sraoss.co.jp%2F&amp;data=05%7C01%7C%7Cd4b8edfe0b8e42ca91c808da33cecbbe%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637879260528763671%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=j5Mx0g6TRwfuNg4RudAjhyaHBZK2AbsxbBQBp3zVqoQ%3D&amp;reserved=0" data-auth="NotApplicable">https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sraoss.co.jp%2F&amp;data=05%7C01%7C%7Cd4b8edfe0b8e42ca91c808da33cecbbe%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637879260528763671%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=j5Mx0g6TRwfuNg4RudAjhyaHBZK2AbsxbBQBp3zVqoQ%3D&amp;reserved=0</a><br>
</div>
<editor-squiggler style="height: 0px; width: 0px;"><style>
  @media print {
    .ms-editor-squiggler {
        display:none !important;
    }
  }
  .ms-editor-squiggler {
    all: initial;
    display: block !important;
    height: 0px !important;
    width: 0px !important;
  }</style>
<div class="ms-editor-squiggler" style="transform: scale(1); transform-origin: left top 0px;">
</div>
</editor-squiggler></span></font></div>
</body>
</html>