[pgsql-jp: 39368] Re: =?iso-2022-jp?B?cGdwb29sGyRCLTYhISROISEbKEJjdXJyZW50X2JhY2tlbmRfaG9zdA==?=

[Yoshiyuki Asaba]

$B ＠ u1)$G$9!#(B

From: "AOKI KAZUYUKI" <aoki-kazuyuki ＠ nifty.com>
Subject: [pgsql-jp: 39361] pgpool$B-6!!$N!!(Bcurrent_backend_host
Date: Wed, 23 Apr 2008 21:56:22 +0900

> show pool_status; $B$N7k2L$O0J2<$NDL$j$G$9!#(B
> 
> current_backend_host $B$H$$$&9`L\$,8+$D$+$i$J$$$N$G$9$,!"(B
> pgpool$B-6!!$N%9%F!<%?%9$G$OI=<($5$l$J$$$N$G$7$g$&$+!)(B

$B$&!<$`!"L5$$$G$9$M!D!#:#8eDI2C$7$?$$$H;W$$$^$9!#(B


> $B%5!<%P!<$O(B3$BBf9=@.$G(B1$BBf$,(Bpgpool$B!!;D$j(B2$BBf$G(BPostgreSQL$B$rF0$+$7$F$$$^$9!#(B
> pg_pool$B!!1[$7$K8+$?>l9g$O!!(B192.168.***.150$B!!$r8+$F$$$k$h$&$J$N$G$9$,!"(B
> 192.168.***.160$B!!$NJ}$,%G!<%??t$,B?$$$N$G!"G:$s$G$7$^$C$F$$$^$9!#(B

pgpool $B$N%(%i!<%m%0$O;D$C$F$$$^$9$G$7$g$&$+!)(B


> $B$^$?!"(Bbackend status0  ==$B!!(B2$B!!$H$$$&$N$,$I$&$$$&>uBV$J$N$+!)(B

$B$3$A$i$O%I%-%e%a%s%H$,H4$1$F$$$^$7$?!#0J2<$NDL$j$G$9!#(B

  0 | $B;H$C$F$$$J$$%N!<%I(B 
  1 | $B%3%M%/%7%g%s%-%c%C%7%e$r:n$C$F$$$J$$%N!<%I(B($B ＠ 5>o$J%N!<%I(B)
  2 | $B%3%M%/%7%g%s%-%c%C%7%e$N$"$k%N!<%I(B($B ＠ 5>o$J%N!<%I(B)
  3 | $B ＠ Z$jN%$5$l$?%N!<%I(B($B0[>o$J%N!<%I(B)

$B$H$$$&0UL#$K$J$j$^$9(B($B%I%-%e%a%s%H$KDI2C$7$F$*$-$^$9(B)$B!#(B2 $B$D$N%N!<%I$N%9(B
$B%F!<%?%9$,(B 2 $B$J$N$G!"N>J}$H$b ＠ 5>o$H$$$&G'<1$G$9!#%^%9%?$O0lHV>.$5$$CM(B
$B$K$J$k(B backend0 $B$K$J$j$^$9!#(B

--
Yoshiyuki Asaba
y-asaba ＠ sraoss.co.jp