<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 id="appendonsend"></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#3Bf9=@.$r#2Bf9=@.$KJQ99$7!"F0:nJQ$o$k$N$+8!>Z$7$^$7$?!#(B
<div>$B7k2LE*$K$O$*$J$8>I>u$G$7$?!#(B</div>
<div><br>
</div>
<div>$B!&(Bpg$B!]$H(Bpg-b</div>
<div>$B!&2<5-%m%0$=$N$^$^$G$9$,!"(Bpg-a $B$G$N:n6H$G$9(B($B:G8e$@$1(Bpg-b$B$"$j(B)$B!#(B</div>
<div>$B!&(Bpg-a$B$,(BLEADER$B$G(Bprimary$B!"<jF0$G(BPostgreSQL$B$r;_$a$k(B</div>
<div>$B!&%U%'%$%k%*!<%P!<$7$F(Bpg-b$B$,(Bprimary$B$K(B</div>
<div>$B!&(BLEADER$B$O(Bpg-a$B$N$^$^(B</div>
<div><br>
</div>
<div><br>
</div>
<div>[root@pg-a ~]# psql -h 192.168.0.100 -p 9999 -U pgpool postgres -c "show pool_nodes"</div>
<div> 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</div>
<div>---------+--------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------</div>
<div> 0       | 192.168.0.92 | 5432 | up     | up        | 0.500000  | primary | primary | 0          | true              | 0                 |                   |                        | 2022-05-14 14:45:44</div>
<div> 1       | 192.168.0.93 | 5432 | up     | up        | 0.500000  | standby | standby | 0          | false             | 0                 | streaming         | async                  | 2022-05-14 14:45:44</div>
<div>(2 $B9T(B)</div>
<div><br>
</div>
<div>[root@pg-a ~]# pcp_watchdog_info -p 9898 -h 192.168.0.100 -U pgpool</div>
<div>Password:</div>
<div>2 2 YES 192.168.0.92:9999 Linux pg-a 192.168.0.92</div>
<div><br>
</div>
<div>192.168.0.92:9999 Linux pg-a 192.168.0.92 9999 9000 4 LEADER 0 MEMBER</div>
<div>192.168.0.93:9999 Linux pg-b 192.168.0.93 9999 9000 7 STANDBY 0 MEMBER</div>
<div><br>
</div>
<div>[root@pg-a ~]# ip a</div>
<div>1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000</div>
<div>    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00</div>
<div>    inet 127.0.0.1/8 scope host lo</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>    inet6 ::1/128 scope host</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000</div>
<div>    link/ether 00:15:5d:00:06:00 brd ff:ff:ff:ff:ff:ff</div>
<div>    inet 192.168.0.92/24 brd 192.168.0.255 scope global noprefixroute eth0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>    inet 192.168.0.100/24 scope global secondary eth0:0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>3: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000</div>
<div>    link/ether 52:54:00:d2:53:49 brd ff:ff:ff:ff:ff:ff</div>
<div>    inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div><br>
</div>
<div>[root@pg-a ~]# su - postgres</div>
<div>[postgres@pg-a ~]$ /usr/pgsql-14/bin/pg_ctl -D /var/lib/pgsql/14/data -m immediate stop</div>
<div>$B%5!<%P!<Dd;_=hM}$N40N;$rBT$C$F$$$^$9(B....$B40N;(B</div>
<div>$B%5!<%P!<$ODd;_$7$^$7$?(B</div>
<div>[postgres@pg-a ~]$ exit</div>
<div>$B%m%0%"%&%H(B</div>
<div><br>
</div>
<div>[root@pg-a ~]# psql -h 192.168.0.100 -p 9999 -U pgpool postgres -c "show pool_nodes"</div>
<div> 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</div>
<div>---------+--------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------</div>
<div> 0       | 192.168.0.92 | 5432 | down   | down      | 0.500000  | standby | unknown | 0          | false             | 0                 |                   |                        | 2022-05-14 14:52:06</div>
<div> 1       | 192.168.0.93 | 5432 | up     | up        | 0.500000  | primary | primary | 0          | true              | 0                 |                   |                        | 2022-05-14 14:52:06</div>
<div>(2 $B9T(B)</div>
<div><br>
</div>
<div>[root@pg-a ~]# ip a</div>
<div>1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000</div>
<div>    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00</div>
<div>    inet 127.0.0.1/8 scope host lo</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>    inet6 ::1/128 scope host</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000</div>
<div>    link/ether 00:15:5d:00:06:00 brd ff:ff:ff:ff:ff:ff</div>
<div>    inet 192.168.0.92/24 brd 192.168.0.255 scope global noprefixroute eth0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>    inet 192.168.0.100/24 scope global secondary eth0:0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>3: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000</div>
<div>    link/ether 52:54:00:d2:53:49 brd ff:ff:ff:ff:ff:ff</div>
<div>    inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div><br>
</div>
<div>$B!z(BZabbix$B$N(BWeb$B$,8+$l$J$/$J$k(B</div>
<div><br>
</div>
<div>[root@pg-a ~]# systemctl stop pgpool.service</div>
<div>[root@pg-a ~]# systemctl start pgpool.service</div>
<div>[root@pg-a ~]# pcp_watchdog_info -p 9898 -h 192.168.0.100 -U pgpool</div>
<div>Password:</div>
<div>2 2 YES 192.168.0.93:9999 Linux pg-b 192.168.0.93</div>
<div><br>
</div>
<div>192.168.0.93:9999 Linux pg-b 192.168.0.93 9999 9000 4 LEADER 0 MEMBER</div>
<div>192.168.0.92:9999 Linux pg-a 192.168.0.92 9999 9000 7 STANDBY 0 MEMBER</div>
<div><br>
</div>
<div>$B!z(Bpg-a$B$N(Bpgpool$B$r(Bstop$B!"(Bstart$B$9$k$3$H$G(BLEADER$B$,(Bpg-b$B$K$J$j(B</div>
<div><br>
</div>
<div>[root@pg-b ~]# ip a</div>
<div>1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000</div>
<div>    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00</div>
<div>    inet 127.0.0.1/8 scope host lo</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>    inet6 ::1/128 scope host</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000</div>
<div>    link/ether 00:15:5d:00:06:01 brd ff:ff:ff:ff:ff:ff</div>
<div>    inet 192.168.0.93/24 brd 192.168.0.255 scope global noprefixroute eth0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>    inet 192.168.0.100/24 scope global secondary eth0:0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div>3: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000</div>
<div>    link/ether 52:54:00:38:93:11 brd ff:ff:ff:ff:ff:ff</div>
<div>    inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0</div>
<div>       valid_lft forever preferred_lft forever</div>
<div><br>
</div>
<div>$B!z(Bpg-b$B$N(Beth0:0$B$K(BVIP$B$,0\F0$9$k$3$H$G(BZabbix$B$N(BWeb$B$,8+$l$^$9(B</div>
<div><br>
</div>
<div>$B5sF08+$F$$$k$H%U%'%$%k%*!<%P!<$7$F(BPostgreSQL Primary$B$K$J$C$?%^%7%s$N(BPgpool-II$B$,(B</div>
<div>LEADER$B$KJQ99$K$J$j(BVIP$B$,$=$N(BNIC$B$KIU$1JQ$o$i$J$$8B$j%@%a$J$N$G$O$H$$$&:G=i$N<ALd$K(B</div>
<div>$B$J$C$F$7$^$$$^$9!#(B</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<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>$B:9=P?M(B:</b> pgpool-general-jp <pgpool-general-jp-bounces@sraoss.jp> $B$,(B yas see_ <yassee_@hotmail.com> $B$NBeM}$GAw?.(B<br>
<b>$BAw?.F|;~(B:</b> 2022$BG/(B5$B7n(B12$BF|(B 18:31<br>
<b>$B08@h(B:</b> pgpool-general-jp@sraoss.jp <pgpool-general-jp@sraoss.jp><br>
<b>$B7oL>(B:</b> [pgpool-general-jp: 1703] Re: watchdog$B$N<+F02>A[(BIP$B@ZBX$,$&$^$/F0:n$7$J$$(B</font>
<div> </div>
</div>
<div dir="ltr">/etc/zabbix/zabbix_server.conf
<div><br>
</div>
<div>$B!!(BDBHost=192.168.0.100</div>
<div class="x_elementToProof"><br>
</div>
<div><br>
</div>
<div>/etc/zabbix/web/zabbix.conf.php</div>
<div><br>
</div>
$B!!(B$DB['SERVER']  = '192.168.0.100';<br>
<div id="x_appendonsend"></div>
<div class="x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
$B$G$9(B<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>$B:9=P?M(B:</b> pgpool-general-jp <pgpool-general-jp-bounces@sraoss.jp> $B$,(B yas see_ <yassee_@hotmail.com> $B$NBeM}$GAw?.(B<br>
<b>$BAw?.F|;~(B:</b> 2022$BG/(B5$B7n(B12$BF|(B 18:19<br>
<b>$B08@h(B:</b> Bo Peng <pengbo@sraoss.co.jp>; pgpool-general-jp@sraoss.jp <pgpool-general-jp@sraoss.jp><br>
<b>$B7oL>(B:</b> [pgpool-general-jp: 1702] Re: watchdog$B$N<+F02>A[(BIP$B@ZBX$,$&$^$/F0:n$7$J$$(B</font>
<div> </div>
</div>
<div dir="ltr">
<div dir="auto" class="x_x_elementToProof" 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">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt">$BWE$5$s(B</span></font></div>
<div dir="auto" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"><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" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"><br>
</span></font></div>
<div dir="auto" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"> $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" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"> <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" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"><br>
</span></font></div>
<div dir="auto" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt">>- $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" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"><br>
</span></font></div>
<div dir="auto" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"><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" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof" style="font-size:11pt"><br>
</span></font></div>
<div dir="auto" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<font size="2"><span class="x_x_elementToProof x_elementToProof" style="font-size:11pt">>- 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" class="x_x_elementToProof" style="color:rgb(33,33,33); background-color:rgb(255,255,255)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
$B!!(Bzabbix server 6.0.4$B$K$J$j$^$9!#(B<br>
</div>
<div class="x_x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Meiryo,"$B%a%$%j%*(B","Hiragino Sans",sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_x_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="x_x_BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="x_x_PlainText x_x_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&data=05%7C01%7C%7C6044bb4dced54dfbe81408da33fa3aa9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637879447076332189%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=pGJbSM4N9d7jCDsBqjTlEJOnYRRJJv3tqWSyENRvuL8%3D&reserved=0" data-auth="Verified" originalsrc="http://www.sraoss.co.jp/" shash="AdQ07cLK8UsOnBYTfSndUzlkPivmlQtzlMs2D7KfoG9VlKbMcp03o6qcL9Fhp8nGRuh/zDxHBvBPwhPn+f+89sSx3Mb2vy1GGAHIh87qBeh/Zr0T1YHWY0h4s+BZEW6dTO7+niYBmxyb7U+73S9s9DrAK3M1OaJio0vWNKNqhRY=">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>
<div class="x_x_ms-editor-squiggler" style="display:block!important; height:0px!important; width:0px!important">
</div>
</span></font></div>
</div>
</div>
</body>
</html>