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

[Masami GOTO]

$B8eF#$G$9!#(B

$B ＠ u1)$5$s!"$4JV?.$"$j$,$H$&$4$6$$$^$9!#(B
$B$o$+$j$K$/$$%a!<%k$G<:NiCW$7$^$7$?!#(B

$B$5$F!"%G!<%?IT ＠ 09g$,5/$-$?>l9g$K!"(B
replication_stop_on_mismatch = false
$B$G=LB`1?E>$r$7$J$$$3$H$O3NG'$5$;$FD:$-$^$7$?!#(B

$B$G$9$,!"$$$m$$$m;n$7$F$_$?$N$G$9$,!"(B
replication_mode = true
replication_strict = true
load_balance_mode = true
replication_stop_on_mismatch = false
$B$H$7!"(Btesthost1$B$b$7$/$O(Btesthost2$B$N(Bpostgres$B$rDd;_$5(B
$B$;$?>l9g!"(B

test=# select * from xxxx;
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$N%a%C%;!<%8$,=P$^$9!#!J#12sL\$@$1$G$O$J$/!"$:$C$H!K(B

replication_strict = false
$B$H$7$?>l9g$K$O!"=LB`1?E>$,$5$l$k$3$H$O3NG'CW$7$^$7$?$,!"(B
$B$G$-$l$P$3$N%Q%i%a!]%?$O(Btrue$B$G;H$$$?$$$H;W$C$F$*$j$^$9!#(B
$B!J$^$?!"(Breplication_strict $B%Q%i%a!<%?$H=LB`1?E>$H$N4XO"@-$,(B
$B;d$K$O$h$/$o$+$i$J$$$N$G$9$,!D!K(B

-------
Masami GOTO

| $B ＠ u1)$G$9!#(B
|
| > 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$r(B
$B9T$((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
|


----------------------------------------------------------------------------
----


| _______________________________________________
| pgpool-general-jp mailing list
| pgpool-general-jp ＠ sraoss.jp
| http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
|