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

[海藤 廣一]

$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$$$^$9!#(B
> 
> $B%9%?%s%P%$%5!<%P$rJ#?tBf=`Hw$7$F!"(Bsynchronous_commit=on$B$K$7$F!"(Bsynchronous_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
===================================================