<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>$BWE$5$s!"%U%)%m!<$"$j$,$H$&$4$6$$$^$9!#(B </div>
<div><br>
</div>
<div>>Pgpool $BJ#?tBf9=@.$N>l9g!"%/%i%$%"%s%H$,(B VIP $B7PM3$G(B Pgpool-II$B!J%j!<%@!<!K$K@\B3$7$^$9!#(B</div>
<div>>$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</div>
<div>>Pgpool-II $B%j!<%@!<%N!<%I$,@Z$jBX$o$k:]$K!"(BVIP $B$N@Z$jBX$($,<+F0E*$K9T$o$l$^$9!#(B</div>
<div><br>
</div>
<div>$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</div>
<div>$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</div>
<div>zabbxi$B$N(BWeb$B$G$O(B Error connection to database $B$H$J$j$^$9!#(B</div>
<div><br>
</div>
<div><br>
</div>
<div>[root@pg-b ~]# psql -h 192.168.0.100 -p 9999 -U pgpool postgres -c "show pool_nodes"</div>
<div><br>
</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.333333 | standby | standby | 0 | false | 0 | streaming | async | 2022-05-11 22:06:51</div>
<div> 1 | 192.168.0.93 | 5432 | up | up | 0.333333 | primary | primary | 0 | true | 0 | | | 2022-05-11 22:02:44</div>
<div> 2 | 192.168.0.94 | 5432 | up | up | 0.333333 | standby | standby | 0 | false | 0 | streaming | async | 2022-05-11 22:02:44</div>
<div>(3 $B9T(B)</div>
<div><br>
</div>
<div>[root@pg-b ~]# pcp_watchdog_info -h 192.168.0.100 -p 9898 -U pgpool</div>
<div>Password:</div>
<div>3 3 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>192.168.0.94:9999 Linux pg-c 192.168.0.94 9999 9000 7 STANDBY 0 MEMBER</div>
<div><br>
</div>
<div>$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</div>
<div>$B!!!&(Bprimary (192.168.0.93)$B$N(BPostgreSQL$B$r<jF0Dd;_(B</div>
<div>$B!!!&<+F0%U%'%$%k%*!<%P!<$K$J$j!"0J2<$N>uBV$G$9!#(B</div>
<div><br>
</div>
<div>$B!!(B# su - postgres</div>
<div> $ /usr/pgsql-14/bin/pg_ctl -D /var/lib/pgsql/14/data -m immediate stop</div>
<div><br>
</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.333333 | primary | primary | 0 | true | 0 | | | 2022-05-11 22:22:00</div>
<div> 1 | 192.168.0.93 | 5432 | down | down | 0.333333 | standby | unknown | 0 | false | 0 | | | 2022-05-11 22:22:00</div>
<div> 2 | 192.168.0.94 | 5432 | up | up | 0.333333 | standby | standby | 0 | false | 0 | streaming | async | 2022-05-11 22:22:56</div>
<div>(3 $B9T(B)</div>
<div><br>
</div>
<div>[root@pg-b ~]# pcp_watchdog_info -h 192.168.0.100 -p 9898 -U pgpool</div>
<div>Password:</div>
<div>3 3 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>192.168.0.94:9999 Linux pg-c 192.168.0.94 9999 9000 7 STANDBY 0 MEMBER</div>
<div><br>
</div>
<div>$B!!!&(Bprimary $B$O(B 192.168.0.92 $B$K$J$C$?(B</div>
<div>$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</div>
<div><br>
</div>
<div>$B!!"M$3$N>uBV(B $B$G(Bzabbxi$B$N(BWeb$B$G$O(B Error connection to database$B!#(B </div>
<div><br>
</div>
<div><br>
</div>
<div>$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 </div>
<div>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</div>
<br>
<div dir="ltr">
<div class="x__Entity x__EType_OWALinkPreview x__EId_OWALinkPreview x__EReadonly_1">
</div>
<br>
</div>
</body>
</html>