[Linux-ha-jp] PostgreSQLのストリーミングレプリケーションのフェイルオーバーの原因について

Back to archive index

海藤 廣一 kaido****@jp*****
2015年 8月 27日 (木) 09:44:49 JST


$BBg^<MM!">>EgMM(B

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

$B3d$j9~$s$G?=$7Lu$"$j$^$;$s!#(B
$BB?J,!"3'$5$s$K$OMF0W$K=PMh$k$3$H$H;W$$$^$9$,;d$,<B;\M=Dj$N(B
$B#F!?#O8!=PJ}K!$r$4>R2p$7$^$9!#(B

$B>>EgMM$NJ}K!$O%$%s%?!<%M%C%H$K@\B3$5$l$F$$$k%M%C%H%o!<%/$G$O(B
$BHs>o$KM-8z$H;W$$$^$9$,!";d$N8!F$$7$F$$$k%5!<%P!<$OJD$8$?(BLAN
$B$J$N$G2<5-$NJ}K!$H$J$j$^$7$?!#(B

$B-!%5!<%P!<!JN>(BNode$B!K$K$=$l$>$l(BUDP$B%5!<%P!<%W%m%0%i%`(B
$B!!$r<B9T$5$;$^$9!#(B
$B!!(BUDP$B%3%^%s%I$G(BHost$BL>!J(B/etc/hostname$B$NFbMF!K$r1~Ez$9$k$b$N!#(B
$B-"%5!<%P!<$K$O%/%i%9%?%j%s%0$G2>A[(BIP$B$rN>(BNode$B @ _Dj(B
$B-#%/%i%$%"%s%H$+$iN>(BNode($B2>A[(BIP)$B08$K$=$l$>$l(BHost$BL>MW5a%3%^%s%I(B
$B!!$r(BUDP$BAw?.$9$k!#(B
$B-$%/%i%$%"%s%H$G<u?.$7$?(BHost$BL>$,$=$l$>$l @ 5>oF0:n$r<($7$F(B
$B!!$$$k$+$I$&$+$rL>>N$GH=CG$9$k!#(B
$B!!"($=$NET9g$G!"(BDBS_PRI$B$H(BDBS_STB$B$H$$$&(BHost$BL>$K$7$F$$$^$9!#(B

$B=PMh$l$P;d$N:n$C$?!J$*$b$A$c$N$h$&$J!K(BUDP$B%5!<%P!<%W%m%0%i%`(B
$B$r$*;n$7$$$?$@$1$l$P$H;W$$$^$9$,$$$+$,$G$7$g$&!)(B
$B$b$H$b$H%M%C%H$G8+$D$1$?%5%s%W%k$r2~B$$7$?$b$N$J$N$G$9$,(B
$BBh;0<T$K$h$k%G%P%C%0$K$b$J$k$N$G!*(B

$B!z$$$-$J$j%=!<%9$rAw$j$D$1$F$b!&!&!&$H;W$$$^$7$?$N$G:#2s$O(B
$B95$($^$7$?!#(B

$B0J>e$G$9!#(B


On Wed, 26 Aug 2015 11:45:27 +0900
Takehiro Matsushima <takeh****@gmail*****> wrote:

> $BBg^<$5$s(B
> 
> $B>>Eg$G$9!#(B
> OSC 2015 Tokyo/Fall$B$G$*2q$$$G$-$k$3$H$r3Z$7$_$K$7$F$*$j$^$9!*(B
> 
> 
> Web$B%5!<%P!<(B($B @ 53N$K$O(BAP$B%5!<%P!<(B)$B$,(BDB$B$KBP$7$F$$$/$D$N%3%M%/%7%g%s$rD%$k$+$H$$$&$3$H$rK\Ev$O7W;;$7$F$*$/I,MW$,$"$j$^$9!#(B
> AP$B$"$?$j$N%3%M%/%7%g%s?t!"(BAP$BBf?t!"FbItE*$K @ 8$8$k%3%M%/%7%g%s?t!"DL>o4IM}MQ$KI,MW$J%3%M%/%7%g%s?t!"(BDB$B$N%j%=!<%9!"(BAP$B$N%j%=!<%9$J$I$+$iCM$r7h$a$F$$$/$3$H$K$J$k$H$*$b$$$^$9!#(B
> 
> pg_isready$B$G$9$,!"8=>u$N(Bpgsql RA$B$OL$BP1~$G$9$N$G!"(BRA$B$r2~=$$7$F$_$k$N$b3Z$7$$$H;W$$$^$9!#(B
> 
> $B%U%'%$%k%*!<%P!<$N8!CN$G$9$,!";d$O(BMailTo RA$B$r;HMQ$7$F%a!<%kDLCN$r$9$k$h$&$K$7$F$$$^$9!#(B
> Zabbix$BEy$N4F;k%=%j%e!<%7%g%s$G%W%m%;%94F;k$7$?$j%+%9%?%`%3%^%s%I$G4F;k$7$?$j!"$b$7$/$O(BSNMP$B$r;HMQ$9$k$N$b$h$$$H;W$$$^$9!#(B
> $B;~4VE*$KM>M5$,$"$k$N$G$7$?$i$$$m$$$m;n$7$F$_$F!":G=*E*$K7hDj$7$F$$$?$@$/$N$,$b$A$m$s:GA1$@$H$O;W$$$^$9$,!"B(@J$G$H$$$&$3$H$G$7$?$i$H$j$"$($:(BMailTo
> RA$B$,;H$$$d$9$$0u>]$G$9!#(B
> $B$<$R$*;n$7$/$@$5$$!#(B
> 
> $B0J>e$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> 
> ----
> Takehiro Matsushima
> 
> 2015$BG/(B8$B7n(B26$BF|(B 10:32 $BBg^<><IW(B <ohbuc****@m2j*****>:
> > $B>>Eg$5$s(B
> >
> > $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> > $BBg^<$G$9!#(B
> >
> > $B$4L5:;BA$7$F$^$9!*(B
> > $B$^$?<!2s$N(BOSC$B$KM7$S$K9T$3$&$+$H;W$C$F$^$9!#(B
> >
> > $BAaB.$NJV?.$"$j$,$H$&$4$6$$$^$9!#(B
> > $BBgJQ=u$+$j$^$9!#(B
> >
> > max_connections$B$N @ _Dj$,%G%U%)%k%H$N(B100$B$@$C$?$N$,LdBj$@$C$?$s$G$9$M!#(B
> > WEB$B%5!<%P!<B&$N @ _Dj$H(BDB$BB&$N @ _Dj$KAj0c$,$"$C$?$h$&$J$N$G!":#2s$O(B
> > max_connections$B$rE, @ Z$J?tCM$K9g$o$;$kJ}8~$GBP=h$7(B $B$h$&$H;W$$$^$9!#(B
> > $B$A$J$_$K(Bsuperuser_reserved_connections$B$O%3%a%s%H%"%&%H$5$l$F$$$^$7$?!#(B
> >
> > $B:#;H$C$F$$$k%5!<%P!<<+BN$,MhG/$"$?$j$K$O%j%W%l%$%9$K$J$k$+$b$7$l$^$;$s$N(B
> > $B$G!"$=$N:]$K$O(Bpg_isready$B$bD4$Y$F$_$h$&$+$H;W$$$^(B $B$9!#(B
> >
> > $B$H$3$m$G!":#2s$?$^$?$^%U%'%$%k%*!<%P!<$7$F$$$?$3$H$K5$$E$$$?$N$G$9$,!"$_(B
> > $B$J$5$s$O$I$N$h$&$K%U%'%$%k%*!<%P!<$r8!CN$7$F$$$k$N$G$7$g$&(B $B$+!#(B
> >
> > $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> >




Linux-ha-japan メーリングリストの案内
Back to archive index