[pgpool-general-jp: 73] Re: 縮退運転とパラメータ設定について

[Yoshiyuki Asaba]

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

From: "Masami GOTO" <m-goto ＠ networld.ne.jp>
Subject: [pgpool-general-jp: 70] $B=LB`1?E>$H%Q%i%a!<%?@_Dj$K$D$$$F(B
Date: Thu, 11 Jan 2007 18:27:08 +0900

> pgpool$B-6$r%F%9%H$7$F$*$j$^$9$,!"%Q%i%a!<%?@_Dj$KLdBj$,$"$k$N$+!"(B
> $B=LB`1?E>$K$D$$$F0U?^$9$kF0:n$r$7$^$;$s!#(B
$B>JN,(B
> $B!J0U?^$9$kF0:n!K(B
> $B#1!%(Btesthost1$B$N(Bpostgres$B!J(BsystemDB$B$H$OJL!K$rDd;_$5$;$?:]"*=LB`(B
> $B#2!%#2(BHOST$B4V$H$G(BDB$BFb%G!<%?IT ＠ 09g$,5/$-$?>l9g"*=LB`$;$:IT ＠ 09g$N$^$^2TF0(B
> 
> $B!J8=:_$NF0:n!K(B
> $B#1!%=LB`$;$:!#!J0J2<$N%W%m%s%W%H%a%C%;!<%8!K(B
> test=# select * from test2;
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> 
> $B#2!%=LB`$;$:IT ＠ 09g$N$^$^2TF0!J0U?^DL$j$K2TF0!K(B
> 
> load_balance_mode = false$B$H$9$l$P!"#1!%$N%1!<%9$OK~$?$5$l$^$9$,!"(B
> $B#2!%$N%1!<%9$,(BNG$B$K$J$C$F$7$^$$$^$9!#(B
> $B$^$?!"(Bload_balance_mode = true$B$H$9$l$P!"#2!%$N%1!<%9$,K~$?$5$l$^$9$,!"(B
> $B#1!%$N%1!<%9$G$O(BNG$B$K$J$C$F$7$^$$$^$9!#(B
> 
> $BD9!9$H?=$7Lu$"$j$^$;$s$,!"#1!%#2!%6&$KK~$?$5$l$k$?$a$K$O$I$N$h$&$K ＠ _Dj$r9T$((B
> $B$P(B
> $BNI$$$N$G$7$g$&$+!)(B

$B%G!<%?$NIT ＠ 09g;~$N=LB`1?E>$NM^@)$O(B

  replication_stop_on_mismatch = false

$B$K$9$l$P=LB`1?E>$7$^$;$s!#$3$A$i$r ＠ _Dj$7$F$_$F$/$@$5$$!#(B

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