[pgsql-jp: 41804] Re: Replication状態について

2015年 7月 10日 (金) 11:41:15 JST

$B#T#o!'@P66MM(B
$B#C#c!'(BPostgreSQL$B%a!<%j%s%0%j%9%H2q0w3'MM(B

$B3$F#$G$9!#(B
$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B
$B>\$7$$$4 ＠ bL@M-Fq$&$4$6$$$^$9!#(B

$BMW$9$k$K(B
$B-!(Bpg_stat_replication$B%S%e!<$r4F;k$7$F$b3NG'$7$?=V4V$K$h$C$F$O(B
$B!!(Bsent_location,write_location,flush_location,replay_location$BCM$,(B
$B!!0[$J$k$3$H$OEvA3$N$3$H$H$7$FH/@8$9$k$?$a0UL#$J$7!#(B
$B!!(BState$B$N(BSync/Async$BDxEY$N4F;k$^$G$,F@:v!#(B
$B-"(BMaster/Standby$B$,(B1:1$B$N9=@.$N>l9g$NF14|!?HsF14|$N%a%j%C%H!?%G%a%j%C%H$O(B
$B!!F14|$N>l9g!"(BMaster$B$,%@%&%s$7$?:]$N2aEO4|$N%G!<%?$b(BStandby$B$H(B
$B!!0lCW$7$F$$$k$,!"5U$K(BStandby$B$,%@%&%s$7$?:]$K(BMaster$B$,$7$P$i$/(B
$B!!%/%i%$%"%s%H$KBP$7$F(BSQL$B1~Ez$7$J$/$J$k!#(B
$B!!HsF14|$N>l9g!"(BMaster$B$,%@%&%s$7$?:]$N2aEO4|$N%G!<%?$,(BStandby
$B!!$KFO$$$F$$$kJ]>Z$,L5$$$,!"(BStandby$B$,%@%&%s$7$F$b(BMaster$B$O%/%i%$%"%s%H(B
$B!!$KBP$7$F$N1~Ez$KLdBj$J$7!#(B
$B!!F14|!?HsF14|$K4X78$J$/%G%#%9%/$X$N(BWAL$B=q$-9~$_$K<:GT$9$k$H$7$?$i(B
$B!!%l%W%j%1!<%7%g%s$H$OJLLdBj!J%G%#%9%/$N?.Mj ＠ -$d#C#P#UIi2Y$J$I!)!K(B
$B-#(BMaster+Standby1$B!JF14|!K(B+Standby2$B$GF0:n$5$;$l$P(B
$B!!(BStandby2$BJ,%3%9%H%"%C%W$H$J$k$,!"(B
$B!!(BMaster$B$,%@%&%s$7$F$b(BStandby1$B$K$O%@%&%s$9$k@#A0$N%G!<%?$"$j(B
$B!!(BStandby1$B$,%@%&%s$7$F$b(BMaster$B$N%/%i%$%"%s%H$X$N1~Ez$KLdBj$J$7(B
$B$H$$$&$3$H$G$9$h$M!)(B
$BB?J,!"@P66MM$h$j%"%I%P%$%9$7$FD:$1$?FbMF$OM}2r$7$?$D$b$j$G$9!#(B
$BM-Fq$&$4$6$$$^$7$?!#(B

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


On Fri, 10 Jul 2015 10:51:21 +0900
$B ＠ P66(B $BLP@/(B / ISHIBASHI,Shigemasa <shige ＠ kobe.email.ne.jp> wrote:

> $B3$F#$5$s(B
> 
> $B$3$s$K$A$O!#(B
> 
> PostgreSQL$B$N(BStreaming Replication$B$C$F!"(BWAL$B$rAw$C$FF14|$r<h$C$F$$$k$N$O!"$4M}2r$7$F$i$l$^$9$h$M!#(B
> $B:G=i$K<ALd$5$l$F$?!"(B sent_location,write_location,flush_location,replay_location$B$G4IM}$5$l$F$^$9!#=g$K!"%^%9%?$,Aw$C$?(BWAL$BHV9f!"%9%?%s%P%$$,=q$-9~$s$@(BWAL$BHV9f!"%9%?%s%P%$$N%G%#%9%/$K=PNO$5$l$?(BWAL$BHV9f!"%9%?%s%P%$B&$G:F ＠ 8$5$l$?(BWAL$BHV9f$G$9!#(B
> $B$D$^$j!"%9%?%s%P%$B&$K$O!"%^%9%?B&$G$N99?7=g$KJQ99$,Aw$i$l$F%9%?%s%P%$B&$G$=$NJQ99$r:F ＠ 8$7$F$$$k$N$G!"JQ99$NESCf$,H4$1$k$H$$$&$N$O!"$J$$$N$G$9!#(B
> Standby2$B$,=hM}$NESCf$G%(%i!<$K$J$C$F$k$N$@$H$7$?$i!"$=$l$O2sI|$G$-$J$$$+$b$7$l$^$;$s!#$9$G$K!"%l%W%j%1!<%7%g%s$NLdBj$G$O$J$$$N$G$O$J$$$G$7$g$&$+!)(B
> $B%l%W%j%1!<%7%g%s$, ＠ 5$7$/F0:n$7$F$$$?$i!"(B Standby2$B$,(Bsent_location $B$,(B2000$B$G(B replay_location$B$,(B1998$B$N>uBV$G(BStandby1$B$,%@%&%s$7$F$b!"(BStandby2$B$O(B replay_location$B$,(B2000$B$^$GLdBj$J$/?J$_$^$9$h$H$$$&$3$H$r8@$C$F$^$9!#(B
> 
> $B3$F#(B $BW"0l(B <kaidou.hirokazu ＠ jp.panasonic.com>: 
> 
> >$B3$F#$G$9!#(B
> >$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B
> >$B%3%a%s%H$"$j$,$H$&$4$6$$$^$9!#(B
> >
> >$B>/!9%$%l%.%e%i!<E*$JOC$K$J$k$H;W$&$N$G$9$,!"%l%W%j%1!<%7%g%s(B
> >$B$NF0:n$K$D$$$F65$($F$/$@$5$$!#(B
> >$B%5!<%P!<9=@.$r(B
> >$B!&(BMaster
> > $B!J(Bsynchronous_commit=on$B!"(Bsynchronous_standby_names="Standby1,Standby2"$B!K(B
> >$B!&(BStandby1$B!JF14|!K(B
> >$B!&(BStandby2$B!JHsF14|!K(B
> >$B$GF0:nCf$K%/%i%$%"%s%H$+$i$N%G!<%?=q$-9~$_$,?t ＠ i2s$N4V$K(B
> >100$B2sL\$"$?$j$G(BStandby2$B$X$N(BStreaming$B=q$-9~$_$,<:GT$7$F$$$?$H$7$F(B
> >$B!J(BStandby1$B$OF14|$J$N$GEvA3 ＠ .8y$7$F$$$k!K(B2000$B2sL\0L$K(BStandby1$B$,(B
> >$B%@%&%s$9$k$H(BStandby2$B$,HsF14|"MF14|$K%7%U%H$7$F(B2000$B2sA08e$N(B
> >$B=q$-9~$_%G!<%?$OEvA3F14|$5$l$k$b$N$H;W$$$^$9$,!"2a5n$K<:GT(B
> >$B$7$F$$$?(B100$BL\$N%G!<%?$b!I;~4V$NLdBj!I$G!IAL$C$FF14|!I$7$F$/$l(B
> >$B$k$N$G$7$g$&$+!)(B
> >
> >$B>e5-$NDL$j2a5n$KHsF14|$GF0:n$7$F$$$?4V$K<u$1<h$jB;$M$?Kt$O(B
> >WAL$B=q$-9~$_<:GT$7$?%G!<%?$bAL$C$FF14|$7$F$/$l$k$J$i(BStandby2
> >$B$NF3F~$O!IHs>o$KM-8z$J<jCJ!I$K$J$j$^$9$N$G@'Hs8!F$$7$?$$$H(B
> >$B;W$$$^$9!#(B
> >
> >> $B!!%l%W%j%1!<%7%g%s$r$9$kL\E*$O2?$G$9$+!)2?$,0lHVBg;v$+$rL ＠ 3N$K$9$k$3$H$,(B
> >> $BI,MW$@$H;W$$$^$9!#(B
> >
> >Debian+PostgreSQL$B$G%l%W%j%1!<%7%g%s$r9T$&$H$$$&;~E@$G(B
> >$B%3%9%H$rM^$($?Cf$G:GA1:v$rLO:w$7$F$$$k$H$$$&$3$H$O(B
> >$B$4M}2r$$$?$@$1$k$N$G$O$J$$$G$7$g$&$+!)(B
> >
> >> $B!!HsF14|$G%l%W%j%1!<%7%g%s$r9T$&$N$J$i!"%^%9%?$,%@%&%s$7$?$H$-$K!"%9%?%s(B
> >> $B%P%$$,F14|$7$?>uBV$K$"$k$3$H$O4|BT$G$-$J$$$H;W$$$^$9!#(B
> >
> >$B%l%W%j%1!<%7%g%s>uBV$N4F;k$H$$$&4QE@$G$4AjCL$5$;$F$$$?$@$$$F(B
> >$B$*$j$^$9$,!"JLES(BPacemaker+Corosync$B!JKt$O(BHeartbeat$B!K$G%/%i%9%?(B
> >$B%j%s%0$b8!F$$7$F$*$j$^$9!#$3$A$i$G>e<j$/$$$1$P(B
> >$B!{Dj>o>uBV$G$OF14|%l%W%j%1!<%7%g%s(B
> >$B!{%9%?%s%P%$$,%@%&%s$7$?$i%^%9%?!<$OHsF14|$N$D$b$j(B
> >$B!{%^%9%?!<$,%@%&%s$7$?:]$O%9%?%s%P%$$,%^%9%?!<$X$N%U%'%$%k%*!<%P!<(B
> >$B$H$$$&F0:n$r$7$F$/$l$k$b$N$H;W$C$F$^$9!#(B
> >
> >$B$$$:$l$K$7$F$b$I$l$+$,%@%&%s$7$?$i(BASAP$B$GI|5l:n6H$OI,MW$J$N$G(B
> >$B4F;k$9$kI,MW$,$"$j!"%/%i%9%?%j%s%0F3F~A0$KM-8z$J4F;kJ}K!$r(B
> >$B8!F$Cf$H$$$&$N$,8=CJ3,$G$9!#(B
> >
> >$B0J>e$G$9!#(B
> >
> >On Thu, 09 Jul 2015 20:53:17 +0900
> >shige ＠ kobe.email.ne.jp wrote:
> >
> >> $B3$F#$5$s(B
> >> 
> >> $B!!$3$s$P$s$O!#(B
> >> 
> >> > $BF14|%l%W%j%1!<%7%g%s$GF0:nCf$N%9%?%s%P%$%5!<%P$,%@%&%s$7$?(B
> >> > $B>l9g$r9MN8$9$k$HHsF14|$GF0:n$7$F$$$k!J#2BfL\0J9_$N!K%G!<%?(B
> >> > $B$,%^%9%?!<$H0lCW$7$F$$$k$+$I$&$+$,=EMW$K$J$C$F$-$^$9!#(B
> >> $B!!(Bsynchronous_standby_names$B$K%9%?%s%P%$%5!<%P$rNs5s$9$k$H!"(B1$BBfL\$N(Bsync$B%9(B
> >> $B%?%s%P%$%5!<%P$,%@%&%s$7$?@^$K$O!"(B2$BBfL\$N(Bpotential$B%5!<%P$,(Bsync$B%5!<%P$K$J(B
> >> $B$j$^$9!#(Bpotential$B$+$i(Bsync$B$K$J$C$?;~E@$G40A4$KF14|$G$-$F$$$J$/$F$b!";~4V$N(B
> >> $B7P2a$K$h$jF14|$9$k$3$H$K$J$j$^$9!#(B
> >> 
> >> $B!!$I$l$@$1$N%G!<%?$rN/$a9~$s$G!"$I$l$@$1$NIQEY$G%G!<%?$,DI2C!&99?7$9$k$+(B
> >> $BJ,$+$i$J$$$N$G$9$,!"DL>o$N1?MQ$K$*$$$F!"%9%?%s%P%$%5!<%P$,%^%9%?%5!<%P$N(B
> >> $B99?7$KDI$$$D$$$F$J$$>u67$,H/@8$9$k$3$H$O(B($B1?MQ$N;EJ}$K$h$j(B)$B$"$j$($^$9$7!"(B
> >> $B$=$l$O;~4V$,2r7h$9$k(B($B%5!<%P$NIi2Y$,2<$,$j!"F14|$9$k(B)$B$b$N$@$H;W$$$^$9!#(B
> >> 
> >> $B!!%l%W%j%1!<%7%g%s$r$9$kL\E*$O2?$G$9$+!)2?$,0lHVBg;v$+$rL ＠ 3N$K$9$k$3$H$,(B
> >> $BI,MW$@$H;W$$$^$9!#(B
> >> 
> >> $B!!HsF14|$G%l%W%j%1!<%7%g%s$r9T$&$N$J$i!"%^%9%?$,%@%&%s$7$?$H$-$K!"%9%?%s(B
> >> $B%P%$$,F14|$7$?>uBV$K$"$k$3$H$O4|BT$G$-$J$$$H;W$$$^$9!#(B
> >> 
> >> $B3$F#(B $BW"0l(B <kaidou.hirokazu ＠ jp.panasonic.com>$B$5$s!'(B
> >> > $B#T#o!'@P66MM(B
> >> > $B#C#c!'(BPostgreSQL$B%a!<%j%s%0%j%9%H2q0wMM(B
> >> > 
> >> > $B3$F#$G$9!#(B
> >> > $B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B
> >> > $BAaB.$N%3%a%s%H$"$j$,$H$&$4$6$$$^$9!#(B
> >> > 
> >> > $B%9%?%s%P%$%5!<%P$rJ#?t$K$7$?>l9g!"%3%9%H%"%C%W$K$J$k$N$G(B
> >> > $B%3%9%H%"%C%W$rHr$1$?$$$H$$$&$N$,0lHV$NM}M3$G$9$,!"(B
> >> > $BF14|%l%W%j%1!<%7%g%s$GF0:nCf$N%9%?%s%P%$%5!<%P$,%@%&%s$7$?(B
> >> > $B>l9g$r9MN8$9$k$HHsF14|$GF0:n$7$F$$$k!J#2BfL\0J9_$N!K%G!<%?(B
> >> > $B$,%^%9%?!<$H0lCW$7$F$$$k$+$I$&$+$,=EMW$K$J$C$F$-$^$9!#(B
> >> > 
> >> > $B8=:_9M$($F$$$kJ}K!$H$7$F$O(B
> >> > $B-!(Bpg_stat_replication$B%S%e!<Ey$G:9J,8!=P$,3NG'$G$-$k$J$i!"(B
> >> > $B!!<+F0$J$$$7<jF0$G(BBasebackup$B$r<h$jD>$7$F%G!<%?$r0lCW$5$;$k!#(B
> >> > $B-"(Bpg_stat_replication$B%S%e!<Ey$G:9J,$,$J$$$O$:$N>uBV$K$*$$(B
> >> > $B!!$F$b#12s!?7n!JKt$O=5!KDxEY$O%F!<%V%kFbMF$r%A%'%C%/$7$F(B
> >> > $B!!$b$7:9J,$,8!=P$5$l$?$i!JDxEY$K$b$h$j$^$9$,!K(BBasebackup$B$r(B
> >> > $B!!<h$jD>$7$F%G!<%?$r0lCW$5$;$k!#(B
> >> > $B-#%^%9%?!<Kt$O%9%?%s%P%$%5!<%P$N$I$A$i$+$,%@%&%s$7$?:]$K$O(B
> >> > $B!!(BASAP$B!J8=<BE*$K$O#1#W0JFb0L!K$G%@%&%s$7$?%5!<%P$NI|5l:n6H(B
> >> > $B!!$K$"$?$k!#(B
> >> > 
> >> > $B>e5-$KCWL?E*$J$H$3$m!"Kt$O$b$C$H$3$&$7$?J}$,NI$$$H8@$&(B
> >> > $B%"%I%P%$%9$rD:$1$k$H=u$+$j$^$9!#(B
> >> > 
> >> > $B0J>e$G$9!#(B
> >> > 
> >> > 
> >> > On Wed, 08 Jul 2015 18:38:24 +0900
> >> > $B ＠ P66(B $BLP@/(B / ISHIBASHI,Shigemasa <shige ＠ kobe.email.ne.jp> wrote:
> >> > 
> >> > > $B3$F#$5$s!"$3$s$K$A$O!#(B
> >> > > 
> >> > > $BLdBj$J$/F14|$,<h$l$F$$$F$b!"0l;~E*$K$=$3$NCM$,0c$&$3$H$O$"$j$($k$H;W(B
> >> $B$$$^$9!#(B
> >> > > 
> >> > > $B%9%?%s%P%$%5!<%P$rJ#?tBf=`Hw$7$F!"(Bsynchronous_commit=on$B$K$7$F!"(B
> >> synchronous_standby_names$B$KJ#?tBf;XDj$9$k$H$$$&J}K!$O<h$l$J$$$G$9$+!)(B
> >> > > 
> >> > > $B3$F#(B $BW"0l(B <kaidou.hirokazu ＠ jp.panasonic.com>: 
> >> > > 
> >> > > >PostgreSQL$B%a!<%j%s%0%j%9%H2q0wMM(B
> >> > > >
> >> > > >$B3$F#$H?=$7$^$9!#(B
> >> > > >$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B
> >> > > >
> >> > > >$B2<5-4D6-$G(BStreamingReplication$B$K$h$jFs=E2=$7$?(B
> >> > > >$B%G!<%?%Y!<%9$r9=C[$7$h$&$H$7$F$*$j$^$9!#(B
> >> > > >
> >> > > >[$B4D6-(B]
> >> > > >OS:Debain7.8
> >> > > >DB:PostgreSQL 9.1
> >> > > >
> >> > > >$B$=$3$G!"%^%9%?!<B&$G(Bpg_stat_replication$B%S%e!<$r(B
> >> > > >$B3NG'$9$k$3$H$G(Breplication$B>uBV$r3NG'$G$-$k$N$G$9$,!"(B
> >> > > >$B$3$N%S%e!<$G%^%9%?!<$H%9%?%s%P%$$G:90[$,=P$F$$$J$$$+(B
> >> > > >$B3NG'$9$k$3$H$O=PMh$k$N$G$7$g$&$+!)(B
> >> > > >
> >> > > >$BNc$($P(B
> >> > > >sent_location,write_location,flush_location,replay_location
> >> > > >$B$NCM$,A4$FF1$8>l9g$O:90[$,=P$F$$$J$$$H$+!"(B
> >> > > >
> >> > > >$B%9%?%s%P%$B&$N%5!<%P!<$K>c32$,=P$?>l9g$K!"%^%9%?!<B&$,(B
> >> > > >$B0l;~E*$K(BSQL$B$N1~EzITG=$K$J$k$N$rKI$0L\E*$G(B
> >> > > >synchronous_commit = local
> >> > > >$B$GF0:n$5$;$k$3$H$rA[Dj$7$F$$$k0Y!"5U$K%9%?%s%P%$$N%G!<%?$,(B
> >> > > >$B%^%9%?!<$HF1$8$+$I$&$+$r3NG'$9$kI,MW$,=P$F$7$^$C$F$$$^$9!#(B
> >> > > >
> >> > > >$B>o;~4F;k$r$7$?$$$N$G4JC1$K3NG'$G$-$kJ}K!$,$"$j$^$7$?$i(B
> >> > > >$B%"%I%P%$%94j$$$^$9!#(B
> >> > > >
> >> > > >$B0J>e$G$9!#(B
> >> > > >
> >> > > >
> >> > 
> >> > 
> >> > 
> >> > ===================================================
> >> >  $B%Q%J%=%K%C%/(B $B%7%9%F%`%M%C%H%o!<%/%93t<02q<R(B
> >> >  $B%$%s%U%i%7%9%F%`;v6HIt(B
> >> >  $B%7%9%F%`%W%m%@%/%HIt(B  $B%W%m%@%/%H5;=Q2](B
> >> >  $B3$F#(B $BW"0l(B
> >> >  E-mail:kaidou.hirokazu ＠ jp.panasonic.com
> >> >  TEL:050-3686-3682       $BFb@~(B:7-375-8945
> >> > ===================================================
> >> 
> >> 
> >> ---
> >> $B$$$7$P$7!!$7$2$^$5(B
> >
> >
> >
> >===================================================
> > $B%Q%J%=%K%C%/(B $B%7%9%F%`%M%C%H%o!<%/%93t<02q<R(B
> > $B%$%s%U%i%7%9%F%`;v6HIt(B
> > $B%7%9%F%`%W%m%@%/%HIt(B  $B%W%m%@%/%H5;=Q2](B
> > $B3$F#(B $BW"0l(B
> > E-mail:kaidou.hirokazu ＠ jp.panasonic.com
> > TEL:050-3686-3682       $BFb@~(B:7-375-8945
> >===================================================
> >


===================================================
 $B%Q%J%=%K%C%/(B $B%7%9%F%`%M%C%H%o!<%/%93t<02q<R(B
 $B%$%s%U%i%7%9%F%`;v6HIt(B
 $B%7%9%F%`%W%m%@%/%HIt(B  $B%W%m%@%/%H5;=Q2](B
 $B3$F#(B $BW"0l(B
 E-mail:kaidou.hirokazu ＠ jp.panasonic.com
 TEL:050-3686-3682       $BFb@~(B:7-375-8945
===================================================