[pgsql-jp: 35505] Pgpool→Pgpool経由でのDB接続

[岡村 健一]

$B$3$s$K$A$O!"2,B<$H?=$7$^$9!#(B
 
 (Pgpool-1)--------(Pgpool-2)$B"*(B(psotgres-1)
                                     $B!_(B
          -------- (Pgpool-3)$B"*(B(psotgres-2)

$B!!!!"((BPgpool-1$B$H(BPgpool-2$B!"(BPgpool-3$B$N4V$O%U%'!<%k%*!<%P(B
$B!!!!!!!!(BPgpool-2$B!"(BPgpool-3$B$H(Bpsotgres-1$B!"(Bpsotgres-2$B$N4V$O(B
$B!!!!!!!!%l%W%j%1!<%7%g%s$N%/%m%9!J<+%[%9%H$N(Bpsotgre$B$r%^%9%?!"Aj<jB&$N(B
psotgre
$B$r%9%l!<%V!K(B

$B>e<j$N9=@.!J(BPgpool$B$N%+%9%1!<%I!K$G(BDB$B@\B3$7$F$$$^$9!#(B
Pgpool-1$B!K(B $B%U%'%$%k%*!<%P!<5!G=$N$_(B
($B%P%C%/%(%s%I%[%9%H(B=Pgpool-2$B!"%;%+%s%@%j%P%C%/%(%s%I%[%9%H(B=Pgpool-3)

Pgpool-2$B!K%l%W%j%1!<%7%g%s5!G=(B+$B%X%k%9%A%'%C%/5!G=$N$_(B
($B%P%C%/%(%s%I%[%9%H(B=postgres-1$B!"%;%+%s%@%j%P%C%/%(%s%I%[%9%H(B=postgres-2)

Pgpool-3$B!K%l%W%j%1!<%7%g%s5!G=(B+$B%X%k%9%A%'%C%/5!G=$N$_(B
($B%P%C%/%(%s%I%[%9%H(B=postgres-2$B!"%;%+%s%@%j%P%C%/%(%s%I%[%9%H(B=postgres-1)

$B>e5-$N9=@.$G ＠ 5>o$K5/F0$7!"F0:n$7$F$$$k$3$H$r3NG'$7$?8e$K0J2<$N%F%9%H(B
$B$r9T$$$^$7$?!#(B
$B-!(Bpsotgres-1$BDd;_8e(BPgpool-3$BDd;_(B
$B!!!!(BPgpool-1$B7PM3$G(Bpostgres-2$B$r;2>H$9$k$3$H$,$G$-$:!"#p#s#q#l%3%^%s%I<B9T;~<!(B


$B$N%(%i!<$,JV$C$FMh$^$7$?!#(B
$B!!!!!!!!(Bpsql: server closed the connection unexpectedly
        $B!!!!!!!!(BThis probably means the server terminated abnormally
       $B!!(B $B!!!!!!(Bbefore or while processing the request.
$B!!!!$?$@$7!"$3$N$H$-!"(BPgpool-2$B7PM3$G(Bpostgres-2$B;2>H$9$k$3$H$,$G$-$^$9!#(B
   $B3F(Bpool_status$B$N>uBV(B
$B!!!!!!(Bpgpool-1$B!!(Bpostgres-2$B$r;2>H(B
$B!!!!!!(Bpgpool-2$B!!(Bpostgres-2$B$r;2>H(B

$B-"(BPgpool-3$BDd;_8e(Bpsotgres-1$BDd;_(B
$B!!!!(BPgpool-1$B7PM3$G(Bpostgres-2$B$r;2>H$9$k$3$H$,$G$-$:!"(Bpsql$B%3%^%s%I<B9T;~<!(B
$B$N%(%i!<$,JV$C$FMh$^$7$?!#(B
$B!!!!!!!!(Bpsql: server closed the connection unexpectedly
        $B!!!!!!!!(BThis probably means the server terminated abnormally
       $B!!(B $B!!!!!!(Bbefore or while processing the request.

$B!!!!$?$@$7!"$3$N$H$-!"(BPgpool-2$B7PM3$G(Bpostgres-2$B;2>H$9$k$3$H$,$G$-$^$9!#(B
   $B3F(Bpool_status$B$N>uBV(B
$B!!!!!!(Bpgpool-1$B!!(Bpostgres-2$B$r;2>H(B
$B!!!!!!(Bpgpool-2$B!!(Bpostgres-2$B$r;2>H(B

$B-#(Bpsotgres-2$BDd;_8e(BPgpool-2$BDd;_(B
$B!!(BPgpool-1$B7PM3$G(Bpostgres-1$B$r;2>H2DG=!#(B

$B-$(BPgpool-2$BDd;_8e(Bpsotgres-2$BDd;_(B
$B!!(BPgpool-1$B7PM3$G(Bpostgres-1$B$r;2>H2DG=!#(B

$B%F%9%H%1!<%9-!!"-"$N>l9g!"(BPgpool-1$B$h$j(BDB$B;2>H$r$9$k$3$H$,(B
$B$G$-$^$;$s!#(B

$B$I$J$?$G$b9=$$$^$;$s$N$G!"$42rEz$r$*4j$$$$$?$7$^$9!#(B

$B<:Ni$7$^$9!#(B

_________________________________________________________________
MSN Hotmail$B$G3+1?%a%k%"%I ＠ j$$<B;\Cf(B 
http://promotion.msn.co.jp/hotmail/fortune/input_un.asp