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

2015年 7月 10日 (金) 10:16:34 JST

$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
===================================================