[pgpool-general-jp: 1302] オンラインリカバリ(コマンド経由)後のpgpool状態について

[前田 孝介]

$B$*@$OC$K$J$C$F$*$j$^$9!#A0ED$G$9!#(B

pgpool$B$N<jF0%*%s%i%$%s%j%+%P%j$N0J2<5sF0$K$D$$$F!"(B
$B$4B8$8$G$"$l$P$465<(D:$-$?$/$*4j$$$7$^$9!#(B

$B0J2<$N<j=g$r<B;\$7$?$?8e$K!"(BWeb$B$N(Badmin-tool$B$+$i(Bpgpool1$B$N(B
$B>uBV$r3NG'$7$?$H$3$m!"!V(BReturn$B!W$,I,MW$J>uBV$H$J$C$F$$$^$7$?!#(B
$B!t$?$@$7!"(Bps$B%3%^%s%I$G3NG'$7$?$H$3$m!"(Bpgpool$B%W%m%;%9<+BN$O(B
  $B ＠ 8$-$F$$$^$7$?!#(B

------------------------------------------------------
$B-!(B backend0$B$N(Bpostgres$BDd;_(B
$B-"(B Web$B$N(Badmin-tool$B$+$i$G$O$J$/!"%3%^%s%I<B9T$K$F!"(Bbackend1$B"M(Bbackend0$B$N(B
   $B%*%s%i%$%s%j%+%P%j$r<B;\(B
$B!t(Bcopy-base-backup$B"M(Bpgpool_recovery_pitr

$B-#(B backend0$B$N(Bpostgres$B5/F0(B
------------------------------------------------------

backend0$B$rDd;_$7$?>l9g$G$b!"(Bbackend1$B$K8~$- ＠ h$,JQ$o$k$@$1$J$N$G!"(B
pgpool$B$K$O1F6AL5$/!"(Bbackend0$B5/F0;~$KI|5l$5$l$kG'<1$G$$$?$N$G$9$,!"(B
$B%*%s%i%$%s%j%+%P%j8e$O!"JLES(Bpgpool$B$N:F5/F0$,I,MW$H$J$k$N$G$7$g$&$+!)(B
$B$=$l$H$b!"2?$+$7$i$N ＠ _DjCM$K$h$k5sF0$G$7$g$&$+!)(B
$B!t(Badmin-tool$B$+$i$N%*%s%i%$%s%j%+%P%j$H$O0[$J$k5sF0$H$J$C$?$?$a!"(B
  $B<ALd$H$J$j$^$9!#(B

$B$J$*!">e5-<j=g<B;\;~$N9=@.$O!"0J2<$H$J$j$^$9!#(B

-----------------------------------
$B!&(Bpgpool$B%P!<%8%g%s!'(B3.3.2

$B!&%b!<%I!'%l%W%j%1!<%7%g%s%b!<%I(B

$B!&(Bpgpool1(Stanby)
  - $B5/F0%5!<%P!'(BServer1
  - backend0  $B!'(BServer1(master)
  - backend1  $B!'(BServer2

$B!&(Bpgpool2(Active)
  - $B5/F0%5!<%P!'(BServer2
  - backend0  $B!'(BServer1(master)
  - backend1  $B!'(BServer2
-----------------------------------

$B0J>e$G$9!#$h$m$7$/$*4j$$$7$^$9!#(B