Mailing List Archive: Linux-HA: Japanese

Re: PostgreSQL 9.1 $BF1(B$B4|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B

Linux-HA japanese RSS feed

Index | Next | Previous | View Threaded

renayama19661014 at ybb

Sep 6, 2011, 8:06 PM

Post #1 of 16 (593 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B

$B>>Hx$5$s(B

$B$*Hh$lMM$G$9!#;3Fb$G$9!#(B

$B2sEz$"$j$,$H$&$4$6$$$^$7$?!#(B

$B$H$$$&$3$H$G$"$l$P!"LdBj$J$$$H;W$$$^$9!#(B

$B;d$+$i$O!"JQ99$5$l$?(BRA$B$K4X$7$F!"$H$j$"$($:!"$3$l$G;XE&;v9`$O$"$j$^$;$s!#(B

$B0J>e!"59$7$/8f4j$$$$$?$7$^$9!#(B

--- On Wed, 2011/9/7, Takatoshi MATSUO <matsuo.tak [at] gmail> wrote:

> $B;3Fb$5$s(B
>
> $B>>Hx$G$9!#(B
>
> 11/09/07 renayama19661014 [at] ybb <renayama19661014 [at] ybb>:
> > $B>>Hx$5$s(B
> >
> > $B$*Hh$lMM$G$9!#;3Fb$G$9!#(B
> >
> > $B0J2<!":#2s$N%Q%C%A$G85!9$NB0@-$N [at] _D@h$H0c$&@_Dj@h(B($B85!9$O(Bnode$B%;%/%7%g%s$K [at] _D$7$F$$$?B0@-$,!"(Bstatus$B%;%/%7%g%s(B)$B$K$J$j$^$9$,!"LdBj$J$$$N$G$7$g$&$+!)(B
>
> $B$O$$!#$b$H$b$H!"(B$CRM_ATTR_REBOOT $B$O!":F5/F0;~$K>C$($F$b9=$o$J$$(B
> $BB0@-$K;H$&$D$b$j$G!";H$C$F$$$^$7$?!#(B
> $B;3Fb$5$s$N%3%a%s%H$K$h$l$P!":#$^$G$O:F5/F0$7$F$b<B$O>C$($F$$$J$+$C$?(B
> $B$3$H$K$J$j$^$9$,!"$3$l$G0U?^$7$?F0:n$K$J$C$?$H;W$C$F$$$^$9!#(B
>
> > $B%j%V!<%H8e$KB0@-$rGK4~$9$k0Y$K(Bstatus$B%;%/%7%g%s$X0\F0$7$?$H$$$&$3$H$G$"$l$PLdBj$J$$$H;W$$$^$9!"$A$g$C$H5$$K$J$j$^$7$?$N$G!"%3%a%s%H$5$;$F$$$?$@$-$^$7$?!#(B
>
> $B$"$j$,$H$&$4$6$$$^$7$?!#(B
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan
>

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Sep 18, 2011, 12:28 AM

Post #2 of 16 (537 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B@9$G$9!#(B

> $BFMA3$G$9$,!"(BPostgreSQL 9.1 ($B$^$@(Bbeta) $B$NF14|%l%W%j%1!<%7%g%s$KBP1~$7$?(B
> $B%j%=!<%9%(!<%8%'%s%H(B(RA)$B$r=q$$$F$_$^$7$?!#(B

9.1$B%j%j!<%9HG$GMxMQ$7$F$_$^$7$?!#(B

$B$=$N$^$^$G$OF0$+$J$+$C$?$N$G!"0J2<$N=$@5$r9T$C$F$+$iF0:n$r3NG'$7$F$*$j$^$9!#(B
(SQL$B$N7k2L$rBgJ8;z$K$7$?$@$1(B)

-1486 CHECK_REPLICATION_STATE_SQL="select application_name,state,sync_state from pg_stat_replication"
+1468 CHECK_REPLICATION_STATE_SQL="select application_name, upper(state),upper(sync_state) from pg_stat_replication"

> $B!&(B Primary$B8N>c;~!"(BHot Standby $B$N(B Primary $B$X$N>:3J(B (Master$B$N%U%'%$%k%*!<%P(B)

Master$B$N%U%'%$%k%*!<%P$r3NG'$7$^$7$?!#(B
crm$B$h$j(Bdemote&promote$B$r9T$&$3$H$G!"<jF0$G(BPostgreSQL$B$N(BPrimary $B$H(B Hot Standby
$B$N@Z$jBX$($b$G$-$^$7$?!#(B
$B$^$?!"(BHot Standby$BB&$N(BDB$B$,Dd;_$7$?$H$-$K$O!"(BDB$B$rN)$A>e$2D>$7$F$/$l$^$7$?!#(B

$B$?$@(BPrimary$BB&$N(BDB$B$rMn$H$9$H!"%U%'%$%k%*!<%P$,H/@8$7!"5l(BPrimary$BB&$O(B
Hot Standby$B$H$7$FN)$A>e$,$j$^$7$?!#(B(migration_threthold=3$B$G<B83(B)
$B$3$A$i$O$=$&$$$&;EMM$G$9$+!)(B (Primary$BB&$N(BDB$B$@$1$rN)$A>e$2D>$9$3$H$O$7$^$;$s$+!)!)(B)

> $B!&(B DB$B%G!<%?$N?75l$N4IM}!&H=JL(B

xlog$B$N?JD=$r8_$$$N%N!<%I$G3NG'$7$F$$$k$h$&$G$9$M!#(B
$B$3$l$G0BA4$K1?MQ$G$-$^$9!#(B

> $B!&(B $BF14|%l%W%j%1!<%7%g%s!&HsF14|%l%W%j%1!<%7%g%s$N<+F0 [at] ZB(B

$B$3$A$i$N5!G=$O$9$4$$$G$9$M!#(B
PostgreSQL 9.1$B$NF14|%l%W%j%1!<%7%g%s$G$O!"(BHot Standby$BB&$,Mn$A$k$H(B
PRIMARY$BB&$N(BPostgreSQL$B$N [at] _D$r=q$-D>$7$F%j%m!<%I$r9T$o$J$$$H!"(B
$B=q$-9~$_%H%i%s%6%/%7%g%s$,%V%m%C%/$5$l$F$7$^$&$N$G!"1?MQ$,$d$dBgJQ$G$9$,!"(B
$B$3$N(BRA$B$O$=$3$^$GLLE]$r8+$F$/$l$^$9$M!#(B
#$B$3$N(BRA$B$J$7$K(B9.1$B$NF14|%l%W%j%1!<%7%g%s$r;H$$$3$J$9$3$H$OFq$7$=$&!&!&(B

$B$^$?!"(BHot Standby$BB&$N(BDB$BI|5";~$b%-%c%C%A%"%C%W$9$k$^$G>uBV$r4F;k$7$F$$$^$9$M!#(B

> $B!&(B Read$B$NIi2YJ,;6(B (RA$B$N5!G=$G$O$J$$$G$9$,!"2>A[(BIP$B$HO"7H$5$;$F$"$2$k$3$H$G2DG=(B!?)

$B$3$A$i$O [at] h|%j%j!<%9$7$?$P$+$j$N(Bpgpool-II 3.1$B$HAj@-$,NI$5$=$&$G$9!#(B

$B%l%W%j%1!<%7%g%s$O(Bpacemaker$BB&$GLLE]$r8+$F$/$l$k$N$G!"(Bpgpool-II$B$O%/%(%j$N?6$jJ,$1(B
$B$r$9$k$@$1$G$9$_$^$9!#(B
pgpool-II 3.1$B$G$O>c32$,$"$C$?(BDB$B%N!<%I$r(Bpgpool$B$+$i@Z$j$O$J$5$:!"%U%'%$%k%*!<%P$b(B
$BH/@8$5$;$J$$;EAH$_(B(DISALLOW_TO_FAILOVER)$B$,;H$($k$N$G!"$3$N5!G=$H(BPacemaker$B$,(B
$BMQ0U$7$F$/$l$k=q$-9~$_MQ$N2>A[(BIP$B$HIi2YJ,;6MQ$N2>A[(BIP$B$r(Bpgpool-II$B$K [at] _D$9$l$P!">e<j$/(B
$BIi2YJ,;6$H>c32;~$N@Z$jBX$($KO"F0$7$F$/$l$^$7$?!#(B

$B$?$@!"(Bpgpool$B$rMxMQ$9$k>l9g$G$O!"%9%l!<%V$,Mn$A$F$$$k;~$K;2>HMQ$N2>A[(BIP$B$,$J$/$J$C$F$7$^$&$H(B
$B:$$k$N$G!"0l;~E*$K;2>HMQ$N2>A[(BIP$B$r%^%9%?B&$K$D$1$k [at] _D$K$9$k$J$I$N9)IW$r$9$kI,MW$O$"$j$^$9!#(B
($B0J2<$N$h$&$K6/0z$K [at] _D$7$?$iO"F0$7$F$/$l$^$7$?(B)

location rsc_location-1 vip-slave \
rule $id="rsc_location-1-rule" 100: pgsql-status eq PRI \
rule $id="rsc_location-1-rule-1" 200: pgsql-status eq HS:sync \
rule $id="rsc_location-1-rule-2" -inf: pgsql-status eq STOP

$B<!$O!"F14|%l%W%j%1!<%7%g%s(B2$BBf(B+$BHsF14|%l%W%j%1!<%7%g%s(B1$BBf$G;n$7$F$_$^$9!#(B

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

> $B>>Hx$G$9!#(B
>
> $BFMA3$G$9$,!"(BPostgreSQL 9.1 ($B$^$@(Bbeta) $B$NF14|%l%W%j%1!<%7%g%s$KBP1~$7$?(B
> $B%j%=!<%9%(!<%8%'%s%H(B(RA)$B$r=q$$$F$_$^$7$?!#(B
>
> https://github.com/t-matsuo/resource-agents/blob/pgsql91/heartbeat/pgsql
>
> $B<g$J5!G=$O!"(B
>
> $B!&(B Primary$B8N>c;~!"(BHot Standby $B$N(B Primary $B$X$N>:3J(B (Master$B$N%U%'%$%k%*!<%P(B)
> $B!&(B DB$B%G!<%?$N?75l$N4IM}!&H=JL(B
> $B!&(B $BF14|%l%W%j%1!<%7%g%s!&HsF14|%l%W%j%1!<%7%g%s$N<+F0 [at] ZB(B
> $B!&(B Read$B$NIi2YJ,;6(B (RA$B$N5!G=$G$O$J$$$G$9$,!"2>A[(BIP$B$HO"7H$5$;$F$"$2$k$3$H$G2DG=(B!?)
>
> $B$H$$$C$?$H$3$m$G$9!#(B
> $B$J$*!"(BPostgreSQL 9.1 $B$N%$%s%?%U%'!<%9$rA0Ds$K:n$C$F$$$k$N$G!"(B9.0$B$G$OF0$-$^$;$s!#(B
>
> RA$B$OK\2H%3%_%e%K%F%#$+$iDs6!$5$l$F$$$k(BPostgreSQL$BMQ(BRA (pgsql) $B$r%Y!<%9:n$C$F$*$j!"(B
> PostgreSQL 9.1 $B$N@5<0%j%j!<%9F|(B (9$B7n$0$i$$(B?) $B$rL\I8$KK\2H%3%_%e%K%F%#$KDs0F$7$F(B
> $B$_$?$$$H;W$C$F$$$^$9!#(B
>
> $B4JC1$K35MW$d;H$$J}$r0J2<$K5-=R$7$F$$$^$9$N$G!"$46=L#$,$"$kJ}$d!"(B
> Pacemaker$B$d(BPostgreSQL$B$N%l%W%j%1!<%7%g%s$r;H$C$F$_$?$3$H$,$"$kJ}$O!"(B
> $B@'Hs;n$7$F$_$FD:$1$^$;$s$+!#(B
>
> https://github.com/t-matsuo/resource-agents/wiki/PostgreSQL-9.1-$B%9%H%j!<%_%s%0%l%W%j%1!<%7%g%sBP1~(B-$B%j%=!<%9%(!<%8%'%s%H(B
>
> $B$^$@!"$H$j$"$($:F0$/CJ3,$N$b$N$G!":Y$+$J8!F$O3$l!"%P%0$,B??t$"$k$H;W$$$^$9$,!"(B
> $B%3%a%s%H$dF0:n!&%P%0Js9p!"%Q%C%AEyD:$1$k$H=u$+$j$^$9!#(B
> $B;H$$J}$,$o$+$i$J$$>l9g$b!"K\(BML$B08$X$*4j$$$7$^$9!#(B
>
>
> $B"($b$&$92F5Y$_;~4|$N$?$a!"JV?.$,CY$/$J$k$N$O$4N;>5$/$@$5$$!&!&!&(B
>
> $B0J>e$h$m$7$/$*4j$$CW$7$^$9!#(B
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

--
Yoshiharu Mori <y-mori [at] sraoss>
SRA OSS, Inc Japan http://www.sraoss.co.jp
TEL: 03-5979-2701
FAX: 03-5979-2702

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

matsuo.tak at gmail

Sep 19, 2011, 2:47 AM

Post #3 of 16 (536 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

$B>>Hx$G$9!#(B
$BF0:nJs9p$"$j$,$H$&$4$6$$$^$9!#(B

11/09/18 Yoshiharu Mori <y-mori [at] sraoss>:
> $B@9$G$9!#(B
>
>> $BFMA3$G$9$,!"(BPostgreSQL 9.1 ($B$^$@(Bbeta) $B$NF14|%l%W%j%1!<%7%g%s$KBP1~$7$?(B
>> $B%j%=!<%9%(!<%8%'%s%H(B(RA)$B$r=q$$$F$_$^$7$?!#(B
>
> 9.1$B%j%j!<%9HG$GMxMQ$7$F$_$^$7$?!#(B
>
> $B$=$N$^$^$G$OF0$+$J$+$C$?$N$G!"0J2<$N=$@5$r9T$C$F$+$iF0:n$r3NG'$7$F$*$j$^$9!#(B
> (SQL$B$N7k2L$rBgJ8;z$K$7$?$@$1(B)
>
> -1486 CHECK_REPLICATION_STATE_SQL="select application_name,state,sync_state
> from pg_stat_replication"
> +1468 CHECK_REPLICATION_STATE_SQL="select application_name,
> upper(state),upper(sync_state) from pg_stat_replication"

$B%j%j!<%9HG$GHyL/$K;EMM$,JQ$o$C$?$_$?$$$G$9$M!#(B
$BH?1G$5$;$FD:$-$^$9!#(B
# $B;d$N3+H/4D6-$b%"%C%W%G!<%H$7$J$$$H!&!&!&(B

>
>> $B!&(B Primary$B8N>c;~!"(BHot Standby $B$N(B Primary $B$X$N>:3J(B (Master$B$N%U%'%$%k%*!<%P(B)
>
> Master$B$N%U%'%$%k%*!<%P$r3NG'$7$^$7$?!#(B
> crm$B$h$j(Bdemote&promote$B$r9T$&$3$H$G!"<jF0$G(BPostgreSQL$B$N(BPrimary $B$H(B Hot Standby
> $B$N@Z$jBX$($b$G$-$^$7$?!#(B
> $B$^$?!"(BHot Standby$BB&$N(BDB$B$,Dd;_$7$?$H$-$K$O!"(BDB$B$rN)$A>e$2D>$7$F$/$l$^$7$?!#(B

$B:#$N;EMM$G$O!"8N>cDd;_$G$O:F5/F0$O(BRA$B$G<+F0$G9T$o$J$$$G$9$,!"(B
$B$3$l$O2<5-$G=q$$$F$$$k!"(Bmigration_threthold $B$,8z$$$F$$$k$+$i$G$9$h$M!#(B

> $B$?$@(BPrimary$BB&$N(BDB$B$rMn$H$9$H!"%U%'%$%k%*!<%P$,H/@8$7!"5l(BPrimary$BB&$O(B
> Hot Standby$B$H$7$FN)$A>e$,$j$^$7$?!#(B(migration_threthold=3$B$G<B83(B)
> $B$3$A$i$O$=$&$$$&;EMM$G$9$+!)(B (Primary$BB&$N(BDB$B$@$1$rN)$A>e$2D>$9$3$H$O$7$^$;$s$+!)!)(B)

migration_threthold $B$O$^$C$?$/9MN8$7$F$$$^$;$s$G$7$?!#(B
$B$=$b$=$b(BMaster $B%j%=!<%9$N(B migration_threthold $B$C$FF0$/$N$+$,5?Ld$G$9$,!"(B
$B$4B8$8$G$9$+!#(B

>
>> $B!&(B DB$B%G!<%?$N?75l$N4IM}!&H=JL(B
>
> xlog$B$N?JD=$r8_$$$N%N!<%I$G3NG'$7$F$$$k$h$&$G$9$M!#(B
> $B$3$l$G0BA4$K1?MQ$G$-$^$9!#(B
>
>> $B!&(B $BF14|%l%W%j%1!<%7%g%s!&HsF14|%l%W%j%1!<%7%g%s$N<+F0 [at] ZB(B
>
> $B$3$A$i$N5!G=$O$9$4$$$G$9$M!#(B
> PostgreSQL 9.1$B$NF14|%l%W%j%1!<%7%g%s$G$O!"(BHot Standby$BB&$,Mn$A$k$H(B
> PRIMARY$BB&$N(BPostgreSQL$B$N [at] _D$r=q$-D>$7$F%j%m!<%I$r9T$o$J$$$H!"(B
> $B=q$-9~$_%H%i%s%6%/%7%g%s$,%V%m%C%/$5$l$F$7$^$&$N$G!"1?MQ$,$d$dBgJQ$G$9$,!"(B
> $B$3$N(BRA$B$O$=$3$^$GLLE]$r8+$F$/$l$^$9$M!#(B
> #$B$3$N(BRA$B$J$7$K(B9.1$B$NF14|%l%W%j%1!<%7%g%s$r;H$$$3$J$9$3$H$OFq$7$=$&!&!&(B

Hot Standby$BB&$N8N>c$G(BPrimary$B$,D9;~4V;_$^$C$F$7$^$&$N$O!"(BHA$B$H$$$&4QE@>e(B
$BHr$1$?$+$C$?$N$G!"4hD%$C$F$_$^$7$?(B :-)

$B:#$N(BPostgreSQL$B$N;EMM$G$O!"@_Dj%U%!%$%k$r=q$-49$($F$"$2$k$7$+$J$$$N$G!"(B
$B<BAu$H$7$F$O$"$^$j%9%^!<%H$G$O$J$$$G$9$,(B $B!&!&!&(B

> $B$^$?!"(BHot Standby$BB&$N(BDB$BI|5";~$b%-%c%C%A%"%C%W$9$k$^$G>uBV$r4F;k$7$F$$$^$9$M!#(B

$B$O$$!#(B
$B$3$l$O8E$$%G!<%?$N(BHot Standby$B$,(BPrimary$B$K$J$k$3$H$G!"(B
$B%G!<%?$N7gB;$,H/@8$7$J$$$h$&$K$9$k$?$a$G$9!#(B

>> $B!&(B Read$B$NIi2YJ,;6(B (RA$B$N5!G=$G$O$J$$$G$9$,!"2>A[(BIP$B$HO"7H$5$;$F$"$2$k$3$H$G2DG=(B!?)
>
> $B$3$A$i$O [at] h|%j%j!<%9$7$?$P$+$j$N(Bpgpool-II 3.1$B$HAj@-$,NI$5$=$&$G$9!#(B
>
> $B%l%W%j%1!<%7%g%s$O(Bpacemaker$BB&$GLLE]$r8+$F$/$l$k$N$G!"(Bpgpool-II$B$O%/%(%j$N?6$jJ,$1(B
> $B$r$9$k$@$1$G$9$_$^$9!#(B

$B$*$C$7$c$kDL$j!"%/%(%j?6$jJ,$1$O(Bpgpool$B$N$h$&$JB>$N%D!<%k$r$NMxMQ$r(B
$BA[Dj$7$F$$$^$7$?!#(B

> pgpool-II 3.1$B$G$O>c32$,$"$C$?(BDB$B%N!<%I$r(Bpgpool$B$+$i@Z$j$O$J$5$:!"%U%'%$%k%*!<%P$b(B
> $BH/@8$5$;$J$$;EAH$_(B(DISALLOW_TO_FAILOVER)$B$,;H$($k$N$G!"$3$N5!G=$H(BPacemaker$B$,(B
> $BMQ0U$7$F$/$l$k=q$-9~$_MQ$N2>A[.(BIP$B$HIi2YJ,;6MQ$N2>A[.(BIP$B$r(Bpgpool-II$B$K [at] _D$9$l$P!">e<j$/(B
> $BIi2YJ,;6$H>c32;~$N@Z$jBX$($KO"F0$7$F$/$l$^$7$?!#(B
>
> $B$?$@!"(Bpgpool$B$rMxMQ$9$k>l9g$G$O!"%9%l!<%V$,Mn$A$F$$$k;~$K;2>HMQ$N2>A[.(BIP$B$,$J$/$J$C$F$7$^$&$H(B
> $B:$$k$N$G!"0l;~E*$K;2>HMQ$N2>A[.(BIP$B$r%^%9%?B&$K$D$1$k [at] _D$K$9$k$J$I$N9)IW$r$9$kI,MW$O$"$j$^$9!#(B
> ($B0J2<$N$h$&$K6/0z$K [at] _D$7$?$iO"F0$7$F$/$l$^$7$?(B)
>
> location rsc_location-1 vip-slave \
> rule $id="rsc_location-1-rule" 100: pgsql-status eq PRI \
> rule $id="rsc_location-1-rule-1" 200: pgsql-status eq HS:sync \
> rule $id="rsc_location-1-rule-2" -inf: pgsql-status eq STOP

pgpool$B$r;H$C$?$3$H$J$$$N$G!">pJsBgJQ=u$+$j$^$9!#(B
$BAH$_9g$o$;$G;H$&>l9g$K$OM-MQ$J%N%&%O%&$G$9$M!*(B

> $B<!$O!"F14|%l%W%j%1!<%7%g%s(B2$BBf(B+$BHsF14|%l%W%j%1!<%7%g%s(B1$BBf$G;n$7$F$_$^$9!#(B

$B$3$N>l9g$O!"(Brep_mode = sync $B$G(B3$BBfF0:n$5$;$l$P!"(B
PostgreSQL$B$N;EMM>e(B1$BBf$,HsF14|(B(potential$B$H$$$&>uBV(B)$B$K$J$k$O$:$G$9!#(B
$BF0:nJs9p$*BT$A$7$F$$$^$9!#(B

---------------
$B$3$3$+$i$O!";d$N(BTODO$B%a%b$J$N$G$9$,!"0lE@4{CN$NLdBj$,$"$k$N$G!"(B
$B;29M$N$?$a$K5-=R$7$F$*$-$^$9!#(B

$B<B$O:#$N(BRA$B$G$b!"F14|%b!<%I$G%G!<%?7gB;$,H/@8$9$k2DG=@-$,$"$k$H(B
$B%3%a%s%HD:$-$^$7$?!#(B

$B!|LdBj;v>](B

$B%9%$%C%A%*!<%P!<;~$N(BPriamry$B$N(Bdemote $BF0:n$O!"(B
$BDL>o$O(Bfast shutdown$B$r<B9T$7!"$3$l$G(BPostgreSQL$B$,(B
$BDd;_$7$J$1$l$P!"(Bimmediate shutdown $B$K@Z$jBX$o$j$^$9!#(B
$B$=$N8e?7(BPrimary$B5/F08e$K5l(BPrimary$B$O(BHot Standby$B$G5/F0$5$l$^$9(B

$B$3@Z$jBX$o$C$?>l9g$,LdBj$G!"(Bimmediate shutdown$B;~$OF14|%b!<%I$H8@$($I$b!"(B
$B%l%W%j%1!<%7%g%s$5$l$F$$$J$$%G!<%?$,5l(BPrimary$B$K;D$C$F$7$^$&2DG=@-$,$"$k$h$&$G$9!#(B
$B$D$^$j!"$"$k%G!<%?$,!"5l(BPrimary$B$K$O$"$k$,!"?7(BPrimary$B$K$O$J$$$H$$$&IT [at] 09$,(B
$BH/@8$7$F$7$^$&$h$&$G$9!#(B
$B$5$i$K!"$3$N>uBV$O;DG0$J$,$i(BPostgreSQL$B$G$O8!CN$G$-$^$;$s!#(B

$B!|BP:v0F(B($B8!F$Cf(B)

Hot Standby$B$H$7$F5/F0$9$k>l9g$K!"(B
pg_controldata $B%3%^%s%I$G%G!<%?$N>uBV$r3NG'$7!"(B
$B%G!<%?>uBV$,(B "in production" or "shutting down" $B$N>l9g$O(B
$B5/F0<:GT$K$7$h$&$+$H;W$C$F$$$k$H$3$m$G$9!#(B

$B$?$@$7!"$3$l$@$H%*%s%i%$%s%P%C%/%"%C%W%G!<%?$r%j%9%H%"$7$F!"(BHot Standby$B$H$7$F(B
$B5/F0$9$k>l9g$b!"%G!<%?$N>uBV$,(B"in production" $B$J$N$G!"DL>o$NI|5lA`:n$K$b(B
$B1F6A$,$G$F$7$^$$$^$9!#(B
$B$h$C$F$5$i$K%P%C%/%"%C%W%i%Y%k$NB8:_M-L5$b8+$h$&$+$H;W$C$F$$$^$9$,!"(B
$B:#EY$O%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F$7$^$C$?>l9g$O!"%i%Y%k$,;D$C$F$7$^$$!"(B
$BF1MM$NLdBj$,H/@8$7$F$$$^$&$N$,!"G:$_=j$G$9!#(B

$B:G0-!"0J2<$N$h$&$J1?MQBP=h$r$*4j$$$9$k$7$+$J$$$+$H;W$C$F$$$^$9$,!"(B
$B$J$K$+L/0F$,$"$l$P%3%a%s%HD:$1$k$H=u$+$j$^$9!#(B

$B!V%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F%U%'%$%*!<%P!<$7$?>l9g!"(B
$B5l(BPrimary$B$N%G!<%?$r3NG'$7!"I,MW$K1~$8$F?7(BPrimary$B$+$i%G!<%?$r(B
$B%j%9%H%"$9$kI,MW$,$"$k!W(B

$B$A$J$_$K!"(Bimmediate shutdown$B$r;H$o$J$$$H$$$&0F$b9M$($^$7$?$,!"(B
$B$3$l$O!"(BSTONITH$B$GMn$H$5$l$k$HF1MM$NLdBj$,H/@8$7$F$7$^$$$^$9$M!#(B

$B0J>e$G$9!#(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Sep 20, 2011, 2:12 AM

Post #4 of 16 (530 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$^(B

$B@9$G$9!#(B

> > Master$B$N%U%'%$%k%*!<%P$r3NG'$7$^$7$?!#(B
> > crm$B$h$j(Bdemote&promote$B$r9T$&$3$H$G!"<jF0$G(BPostgreSQL$B$N(BPrimary $B$H(B Hot Standby
> > $B$N@Z$jBX$($b$G$-$^$7$?!#(B

$B<j=g4V0c$($^$7$?!#<jF0$G$N@Z$jBX$($O(Bmove(migrate$B!K$G$7$?!#(B

> > $B$^$?!"(BHot Standby$BB&$N(BDB$B$,Dd;_$7$?$H$-$K$O!"(BDB$B$rN)$A>e$2D>$7$F$/$l$^$7$?!#(B
>
> $B:#$N;EMM$G$O!"8N>cDd;_$G$O:F5/F0$O(BRA$B$G<+F0$G9T$o$J$$$G$9$,!"(B
> $B$3$l$O2<5-$G=q$$$F$$$k!"(Bmigration_threthold $B$,8z$$$F$$$k$+$i$G$9$h$M!#(B

$B$O$$$=$&$G$9!#(B

> migration_threthold $B$O$^$C$?$/9MN8$7$F$$$^$;$s$G$7$?!#(B
> $B$=$b$=$b(BMaster $B%j%=!<%9$N(B migration_threthold $B$C$FF0$/$N$+$,5?Ld$G$9$,!"(B
> $B$4B8$8$G$9$+!#(B

$B$3$A$i$O!";d$bJ,$+$i$J$+$C$?$N$G;n$7$K [at] _D$7$F$_$?$i!"%9%l!<%V$O(B
migration_threthold$B$,8z$$$F$/$l$^$7$?!#(B
$B%^%9%?$O(Bpromotion score$B$,(B-1000000$B$K$J$C$F$7$^$&$N$G!"$=$b$=$bL5M}(B(?)$B$J$N$+$b(B
$B$7$l$^$;$s!#(B

> $B!|LdBj;v>](B
>
> $B%9%$%C%A%*!<%P!<;~$N(BPriamry$B$N(Bdemote $BF0:n$O!"(B
> $BDL>o$O(Bfast shutdown$B$r<B9T$7!"$3$l$G(BPostgreSQL$B$,(B
> $BDd;_$7$J$1$l$P!"(Bimmediate shutdown $B$K@Z$jBX$o$j$^$9!#(B
> $B$=$N8e?7(BPrimary$B5/F08e$K5l(BPrimary$B$O(BHot Standby$B$G5/F0$5$l$^$9(B

$B$3$A$i$NBP:v$G$9$,!"0J2<$N%Q%i%a!<%?$rD9$a$K$H$k(B
$B$GNI$$$N$G$O$J$$$+$H;W$$$^$9$,!#!#(B

<parameter name="stop_escalate" unique="0" required="0">
<longdesc lang="en">
Number of shutdown retries (using -m fast) before resorting to -m immediate
</longdesc>
<shortdesc lang="en">stop escalation</shortdesc>
<content type="integer" default="${OCF_RESKEY_stop_escalation}" />
</parameter>

$B$=$b$=$b(Bfast shutdown$B$GDd;_$7$J$$>l9g$H$$$&$H!"%P%C%/%"%C%WCf$^$?$O(B
$B2?$+$7$i$N>c32;~$G$O$J$$$G$9$+!)(B

$B8e<T$N>l9g$K$O!"$=$l$O$=$l$GLdBj$J$N$G!"@Z$jN%$7$F$bNI$$$+$H;W$$$^$7$?!#(B

$BA0<T$N>l9g$K$O!"0J2<$N1?MQBP1~$G$bNI$$$+$H(B..

> $B!V%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F%U%'%$%*!<%P!<$7$?>l9g!"(B
> $B5l(BPrimary$B$N%G!<%?$r3NG'$7!"I,MW$K1~$8$F?7(BPrimary$B$+$i%G!<%?$r(B
> $B%j%9%H%"$9$kI,MW$,$"$k!W(B

On Mon, 19 Sep 2011 18:47:35 +0900
Takatoshi MATSUO <matsuo.tak [at] gmail> wrote:

> $B>>Hx$G$9!#(B
> $BF0:nJs9p$"$j$,$H$&$4$6$$$^$9!#(B
>
> 11/09/18 Yoshiharu Mori <y-mori [at] sraoss>:
> > $B@9$G$9!#(B
> >
> >> $BFMA3$G$9$,!"(BPostgreSQL 9.1 ($B$^$@(Bbeta) $B$NF14|%l%W%j%1!<%7%g%s$KBP1~$7$?(B
> >> $B%j%=!<%9%(!<%8%'%s%H(B(RA)$B$r=q$$$F$_$^$7$?!#(B
> >
> > 9.1$B%j%j!<%9HG$GMxMQ$7$F$_$^$7$?!#(B
> >
> > $B$=$N$^$^$G$OF0$+$J$+$C$?$N$G!"0J2<$N=$@5$r9T$C$F$+$iF0:n$r3NG'$7$F$*$j$^$9!#(B
> > (SQL$B$N7k2L$rBgJ8;z$K$7$?$@$1(B)
> >
> > -1486 CHECK_REPLICATION_STATE_SQL="select application_name,state,sync_state
> > from pg_stat_replication"
> > +1468 CHECK_REPLICATION_STATE_SQL="select application_name,
> > upper(state),upper(sync_state) from pg_stat_replication"
>
> $B%j%j!<%9HG$GHyL/$K;EMM$,JQ$o$C$?$_$?$$$G$9$M!#(B
> $BH?1G$5$;$FD:$-$^$9!#(B
> # $B;d$N3+H/4D6-$b%"%C%W%G!<%H$7$J$$$H!&!&!&(B
>
> >
> >> $B!&(B Primary$B8N>c;~!"(BHot Standby $B$N(B Primary $B$X$N>:3J(B (Master$B$N%U%'%$%k%*!<%P(B)
> >
> > Master$B$N%U%'%$%k%*!<%P$r3NG'$7$^$7$?!#(B
> > crm$B$h$j(Bdemote&promote$B$r9T$&$3$H$G!"<jF0$G(BPostgreSQL$B$N(BPrimary $B$H(B Hot Standby
> > $B$N@Z$jBX$($b$G$-$^$7$?!#(B
> > $B$^$?!"(BHot Standby$BB&$N(BDB$B$,Dd;_$7$?$H$-$K$O!"(BDB$B$rN)$A>e$2D>$7$F$/$l$^$7$?!#(B
>
> $B:#$N;EMM$G$O!"8N>cDd;_$G$O:F5/F0$O(BRA$B$G<+F0$G9T$o$J$$$G$9$,!"(B
> $B$3$l$O2<5-$G=q$$$F$$$k!"(Bmigration_threthold $B$,8z$$$F$$$k$+$i$G$9$h$M!#(B
>
> > $B$?$@(BPrimary$BB&$N(BDB$B$rMn$H$9$H!"%U%'%$%k%*!<%P$,H/@8$7!"5l(BPrimary$BB&$O(B
> > Hot Standby$B$H$7$FN)$A>e$,$j$^$7$?!#(B(migration_threthold=3$B$G<B83(B)
> > $B$3$A$i$O$=$&$$$&;EMM$G$9$+!)(B (Primary$BB&$N(BDB$B$@$1$rN)$A>e$2D>$9$3$H$O$7$^$;$s$+!)!)(B)
>
> migration_threthold $B$O$^$C$?$/9MN8$7$F$$$^$;$s$G$7$?!#(B
> $B$=$b$=$b(BMaster $B%j%=!<%9$N(B migration_threthold $B$C$FF0$/$N$+$,5?Ld$G$9$,!"(B
> $B$4B8$8$G$9$+!#(B
>
> >
> >> $B!&(B DB$B%G!<%?$N?75l$N4IM}!&H=JL(B
> >
> > xlog$B$N?JD=$r8_$$$N%N!<%I$G3NG'$7$F$$$k$h$&$G$9$M!#(B
> > $B$3$l$G0BA4$K1?MQ$G$-$^$9!#(B
> >
> >> $B!&(B $BF14|%l%W%j%1!<%7%g%s!&HsF14|%l%W%j%1!<%7%g%s$N<+F0 [at] ZB(B
> >
> > $B$3$A$i$N5!G=$O$9$4$$$G$9$M!#(B
> > PostgreSQL 9.1$B$NF14|%l%W%j%1!<%7%g%s$G$O!"(BHot Standby$BB&$,Mn$A$k$H(B
> > PRIMARY$BB&$N(BPostgreSQL$B$N [at] _D$r=q$-D>$7$F%j%m!<%I$r9T$o$J$$$H!"(B
> > $B=q$-9~$_%H%i%s%6%/%7%g%s$,%V%m%C%/$5$l$F$7$^$&$N$G!"1?MQ$,$d$dBgJQ$G$9$,!"(B
> > $B$3$N(BRA$B$O$=$3$^$GLLE]$r8+$F$/$l$^$9$M!#(B
> > #$B$3$N(BRA$B$J$7$K(B9.1$B$NF14|%l%W%j%1!<%7%g%s$r;H$$$3$J$9$3$H$OFq$7$=$&!&!&(B
>
> Hot Standby$BB&$N8N>c$G(BPrimary$B$,D9;~4V;_$^$C$F$7$^$&$N$O!"(BHA$B$H$$$&4QE@>e(B
> $BHr$1$?$+$C$?$N$G!"4hD%$C$F$_$^$7$?(B :-)
>
> $B:#$N(BPostgreSQL$B$N;EMM$G$O!"@_Dj%U%!%$%k$r=q$-49$($F$"$2$k$7$+$J$$$N$G!"(B
> $B<BAu$H$7$F$O$"$^$j%9%^!<%H$G$O$J$$$G$9$,(B $B!&!&!&(B
>
> > $B$^$?!"(BHot Standby$BB&$N(BDB$BI|5";~$b%-%c%C%A%"%C%W$9$k$^$G>uBV$r4F;k$7$F$$$^$9$M!#(B
>
> $B$O$$!#(B
> $B$3$l$O8E$$%G!<%?$N(BHot Standby$B$,(BPrimary$B$K$J$k$3$H$G!"(B
> $B%G!<%?$N7gB;$,H/@8$7$J$$$h$&$K$9$k$?$a$G$9!#(B
>
> >> $B!&(B Read$B$NIi2YJ,;6(B (RA$B$N5!G=$G$O$J$$$G$9$,!"2>A[(BIP$B$HO"7H$5$;$F$"$2$k$3$H$G2DG=(B!?)
> >
> > $B$3$A$i$O [at] h|%j%j!<%9$7$?$P$+$j$N(Bpgpool-II 3.1$B$HAj@-$,NI$5$=$&$G$9!#(B
> >
> > $B%l%W%j%1!<%7%g%s$O(Bpacemaker$BB&$GLLE]$r8+$F$/$l$k$N$G!"(Bpgpool-II$B$O%/%(%j$N?6$jJ,$1(B
> > $B$r$9$k$@$1$G$9$_$^$9!#(B
>
> $B$*$C$7$c$kDL$j!"%/%(%j?6$jJ,$1$O(Bpgpool$B$N$h$&$JB>$N%D!<%k$r$NMxMQ$r(B
> $BA[Dj$7$F$$$^$7$?!#(B
>
> > pgpool-II 3.1$B$G$O>c32$,$"$C$?(BDB$B%N!<%I$r(Bpgpool$B$+$i@Z$j$O$J$5$:!"%U%'%$%k%*!<%P$b(B
> > $BH/@8$5$;$J$$;EAH$_(B(DISALLOW_TO_FAILOVER)$B$,;H$($k$N$G!"$3$N5!G=$H(BPacemaker$B$,(B
> > $BMQ0U$7$F$/$l$k=q$-9~$_MQ$N2>A[.(BIP$B$HIi2YJ,;6MQ$N2>A[.(BIP$B$r(Bpgpool-II$B$K [at] _D$9$l$P!">e<j$/(B
> > $BIi2YJ,;6$H>c32;~$N@Z$jBX$($KO"F0$7$F$/$l$^$7$?!#(B
> >
> > $B$?$@!"(Bpgpool$B$rMxMQ$9$k>l9g$G$O!"%9%l!<%V$,Mn$A$F$$$k;~$K;2>HMQ$N2>A[.(BIP$B$,$J$/$J$C$F$7$^$&$H(B
> > $B:$$k$N$G!"0l;~E*$K;2>HMQ$N2>A[.(BIP$B$r%^%9%?B&$K$D$1$k [at] _D$K$9$k$J$I$N9)IW$r$9$kI,MW$O$"$j$^$9!#(B
> > ($B0J2<$N$h$&$K6/0z$K [at] _D$7$?$iO"F0$7$F$/$l$^$7$?(B)
> >
> > location rsc_location-1 vip-slave \
> > rule $id="rsc_location-1-rule" 100: pgsql-status eq PRI \
> > rule $id="rsc_location-1-rule-1" 200: pgsql-status eq HS:sync \
> > rule $id="rsc_location-1-rule-2" -inf: pgsql-status eq STOP
>
> pgpool$B$r;H$C$?$3$H$J$$$N$G!">pJsBgJQ=u$+$j$^$9!#(B
> $BAH$_9g$o$;$G;H$&>l9g$K$OM-MQ$J%N%&%O%&$G$9$M!*(B
>
> > $B<!$O!"F14|%l%W%j%1!<%7%g%s(B2$BBf(B+$BHsF14|%l%W%j%1!<%7%g%s(B1$BBf$G;n$7$F$_$^$9!#(B
>
> $B$3$N>l9g$O!"(Brep_mode = sync $B$G(B3$BBfF0:n$5$;$l$P!"(B
> PostgreSQL$B$N;EMM>e(B1$BBf$,HsF14|(B(potential$B$H$$$&>uBV(B)$B$K$J$k$O$:$G$9!#(B
> $BF0:nJs9p$*BT$A$7$F$$$^$9!#(B
>
> ---------------
> $B$3$3$+$i$O!";d$N(BTODO$B%a%b$J$N$G$9$,!"0lE@4{CN$NLdBj$,$"$k$N$G!"(B
> $B;29M$N$?$a$K5-=R$7$F$*$-$^$9!#(B
>
> $B<B$O:#$N(BRA$B$G$b!"F14|%b!<%I$G%G!<%?7gB;$,H/@8$9$k2DG=@-$,$"$k$H(B
> $B%3%a%s%HD:$-$^$7$?!#(B
>
> $B!|LdBj;v>](B
>
> $B%9%$%C%A%*!<%P!<;~$N(BPriamry$B$N(Bdemote $BF0:n$O!"(B
> $BDL>o$O(Bfast shutdown$B$r<B9T$7!"$3$l$G(BPostgreSQL$B$,(B
> $BDd;_$7$J$1$l$P!"(Bimmediate shutdown $B$K@Z$jBX$o$j$^$9!#(B
> $B$=$N8e?7(BPrimary$B5/F08e$K5l(BPrimary$B$O(BHot Standby$B$G5/F0$5$l$^$9(B
>
> $B$3@Z$jBX$o$C$?>l9g$,LdBj$G!"(Bimmediate shutdown$B;~$OF14|%b!<%I$H8@$($I$b!"(B
> $B%l%W%j%1!<%7%g%s$5$l$F$$$J$$%G!<%?$,5l(BPrimary$B$K;D$C$F$7$^$&2DG=@-$,$"$k$h$&$G$9!#(B
> $B$D$^$j!"$"$k%G!<%?$,!"5l(BPrimary$B$K$O$"$k$,!"?7(BPrimary$B$K$O$J$$$H$$$&IT [at] 09$,(B
> $BH/@8$7$F$7$^$&$h$&$G$9!#(B
> $B$5$i$K!"$3$N>uBV$O;DG0$J$,$i(BPostgreSQL$B$G$O8!CN$G$-$^$;$s!#(B
>
> $B!|BP:v0F(B($B8!F$Cf(B)
>
> Hot Standby$B$H$7$F5/F0$9$k>l9g$K!"(B
> pg_controldata $B%3%^%s%I$G%G!<%?$N>uBV$r3NG'$7!"(B
> $B%G!<%?>uBV$,(B "in production" or "shutting down" $B$N>l9g$O(B
> $B5/F0<:GT$K$7$h$&$+$H;W$C$F$$$k$H$3$m$G$9!#(B
>
> $B$?$@$7!"$3$l$@$H%*%s%i%$%s%P%C%/%"%C%W%G!<%?$r%j%9%H%"$7$F!"(BHot Standby$B$H$7$F(B
> $B5/F0$9$k>l9g$b!"%G!<%?$N>uBV$,(B"in production" $B$J$N$G!"DL>o$NI|5lA`:n$K$b(B
> $B1F6A$,$G$F$7$^$$$^$9!#(B
> $B$h$C$F$5$i$K%P%C%/%"%C%W%i%Y%k$NB8:_M-L5$b8+$h$&$+$H;W$C$F$$$^$9$,!"(B
> $B:#EY$O%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F$7$^$C$?>l9g$O!"%i%Y%k$,;D$C$F$7$^$$!"(B
> $BF1MM$NLdBj$,H/@8$7$F$$$^$&$N$,!"G:$_=j$G$9!#(B
>
> $B:G0-!"0J2<$N$h$&$J1?MQBP=h$r$*4j$$$9$k$7$+$J$$$+$H;W$C$F$$$^$9$,!"(B
> $B$J$K$+L/0F$,$"$l$P%3%a%s%HD:$1$k$H=u$+$j$^$9!#(B
>
> $B!V%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F%U%'%$%*!<%P!<$7$?>l9g!"(B
> $B5l(BPrimary$B$N%G!<%?$r3NG'$7!"I,MW$K1~$8$F?7(BPrimary$B$+$i%G!<%?$r(B
> $B%j%9%H%"$9$kI,MW$,$"$k!W(B
>
> $B$A$J$_$K!"(Bimmediate shutdown$B$r;H$o$J$$$H$$$&0F$b9M$($^$7$?$,!"(B
> $B$3$l$O!"(BSTONITH$B$GMn$H$5$l$k$HF1MM$NLdBj$,H/@8$7$F$7$^$$$^$9$M!#(B
>
> $B0J>e$G$9!#(B
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan
>

--
Yoshiharu Mori <y-mori [at] sraoss>

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

matsuo.tak at gmail

Sep 20, 2011, 4:31 AM

Post #5 of 16 (530 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

$B@9$5$^(B
$B>>Hx$G$9!#(B

>> migration_threthold $B$O$^$C$?$/9MN8$7$F$$$^$;$s$G$7$?!#(B
>> $B$=$b$=$b(BMaster $B%j%=!<%9$N(B migration_threthold $B$C$FF0$/$N$+$,5?Ld$G$9$,!"(B
>> $B$4B8$8$G$9$+!#(B
>
> $B$3$A$i$O!";d$bJ,$+$i$J$+$C$?$N$G;n$7$K [at] _D$7$F$_$?$i!"%9%l!<%V$O(B
> migration_threthold$B$,8z$$$F$/$l$^$7$?!#(B
> $B%^%9%?$O(Bpromotion score$B$,(B-1000000$B$K$J$C$F$7$^$&$N$G!"$=$b$=$bL5M}(B(?)$B$J$N$+$b(B
> $B$7$l$^$;$s!#(B

$B$=$N$h$&$G$9$M!#(B
Master $B$b(B migration_threthold $B$G:F5/F0$7$?$$$H$$$&MWK>$O(B
$B=P$F$-$=$&$G$9$,!"I,?\5!G=$G$O$J$$$H;W$C$F$$$k$N$G!"(B
$B>-Mh$N%(%s%O%s%9%a%s%H$H$7$F%a%b$C$F$*$-$^$9!#(B

>> $B!|LdBj;v>](B
>>
>> $B%9%$%C%A%*!<%P!<;~$N(BPriamry$B$N(Bdemote $BF0:n$O!"(B
>> $BDL>o$O(Bfast shutdown$B$r<B9T$7!"$3$l$G(BPostgreSQL$B$,(B
>> $BDd;_$7$J$1$l$P!"(Bimmediate shutdown $B$K@Z$jBX$o$j$^$9!#(B
>> $B$=$N8e?7(BPrimary$B5/F08e$K5l(BPrimary$B$O(BHot Standby$B$G5/F0$5$l$^$9(B
>
> $B$3$A$i$NBP:v$G$9$,!"0J2<$N%Q%i%a!<%?$rD9$a$K$H$k(B
> $B$GNI$$$N$G$O$J$$$+$H;W$$$^$9$,!#!#(B
>
> <parameter name="stop_escalate" unique="0" required="0">
> <longdesc lang="en">
> Number of shutdown retries (using -m fast) before resorting to -m immediate
> </longdesc>
> <shortdesc lang="en">stop escalation</shortdesc>
> <content type="integer" default="${OCF_RESKEY_stop_escalation}" />
> </parameter>

immediate shutdown $BL58z$K$9$k$@$1$J$i!"D9$/$9$k$@$1$G$h$$$N$G$9$,!"(B
$B$3$l$O$3$l$G%U%'%$%k%*!<%P!<$K;~4V$,$+$+$C$F$7$^$&$H$$$&7gE@$,(B
$B=P$F$7$^$$$^$9$7!"D9$/$7$F$b(BSTONITH$B$GMn$H$5$l$?$j$9$k$H7k6IF1$8;v>]$,(B
$BH/@8$7$F$7$^$$$^$9!#(B

$B$A$J$_$K!"%U%'%$%*!<%P!<;~4V$O$J$k$Y$/C;$/$7$?$$$H$$$&(B
$BMWK>$b8D?ME*$KJ9$/$3$H$,7k9=$"$j$^$9!#(B

> $B$=$b$=$b(Bfast shutdown$B$GDd;_$7$J$$>l9g$H$$$&$H!"%P%C%/%"%C%WCf$^$?$O(B
> $B2?$+$7$i$N>c32;~$G$O$J$$$G$9$+!)(B

$B%U%'%$%k%;!<%U$N4QE@$G8@$($P!"$3$&$$$C$?>u67$GDd;_$7$?IT [at] 09$J%G!<%?$G$N(B
$B5/F0$bAK;_$9$kI,MW$J$$$G$9$+!)(B

> $B8e<T$N>l9g$K$O!"$=$l$O$=$l$GLdBj$J$N$G!"@Z$jN%$7$F$bNI$$$+$H;W$$$^$7$?!#(B
>
> $BA0<T$N>l9g$K$O!"0J2<$N1?MQBP1~$G$bNI$$$+$H(B..
>
>> $B!V%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F%U%'%$%*!<%P!<$7$?>l9g!"(B
>> $B5l(BPrimary$B$N%G!<%?$r3NG'$7!"I,MW$K1~$8$F?7(BPrimary$B$+$i%G!<%?$r(B
>> $B%j%9%H%"$9$kI,MW$,$"$k!W(B

$B%3%a%s%H$"$j$,$H$&$4$6$$$^$9!#(B

$B$=$N8e!"$$$m$$$m$H9M$($F$$$?$N$G$9$,!"(B
$B1?MQ$G<+F0%P%C%/%"%C%W$7$F$$$?>l9g!"(B
$B%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$?$3$H$K5$$E$/$N$OFq$7$$$N$+$J$H(B
$B;W$$$^$7$?!#(B

Primary$B$N8N>c$GMn$A$?>l9g$OBg>fIW$J$N$G$9$,!"(B
NW$B8N>c$J$I$K0z$-$:$i$l$FMn$A$k$H!"(BNW$B2sI|;~$K<+F0$G5/F0$7$F$7$^$$$^$9$7!#(B

$B$h$C$F!"$H$j$"$($:0J2<$N;EMM$G<BAu$7$F$_$?$$$H;W$$$^$9!#(B

$B!&(B cluster state $B$,!"(Bshutting down $B$^$?$O(B in production $B$N>l9g$O5/F0$G$-$J$$!#(B
$B!&(B $B<jF0$G2?$+%U%i%0%U%!%$%k$N$h$&$JJ*$r:n$l$P!"6/@)E*$K5/F02DG=(B
$B"*(B $B%*%s%i%$%s%P%C%/%"%C%W$N%G!<%?%j%9%H%";~$O!"$D$$$G$K$3$N%U%!%$%k:n@.$,(B
$BI,?\$K$J$j$^$9(B

$B$b$7!"$3$l$@$1$OHr$1$FM_$7$$$H$$$&%3%a%s%H$b$"$l$P!"(B
$B$h$m$7$/$*4j$$$7$^$9!#(B

$B0J>e$G$9(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Sep 20, 2011, 7:38 PM

Post #6 of 16 (534 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$^(B

$B@9$G$9!#(B

> $B!&(B cluster state $B$,!"(Bshutting down $B$^$?$O(B in production $B$N>l9g$O5/F0$G$-$J$$!#(B

$B;d$NM}2r$r [at] 0}$9$k$H!"(B

Primary$B$,@5>o$K5/F0$7$F$$$k>l9g$K$O!"(Bpg_controldata$B$N(B
Database cluster state$B$O(B "in production"$B$K$J$C$F$$$k$O$:$G$"$k!#(B
Primary$B$,@5>o$K=*N;$7$?>l9g$K$O!"(BDatabase cluster state
$B$O(B"shut down"$B$K$J$C$F$$$k$O$:$G$"$k!#(B
$B$3$3$G!"(BPrimary$B$,0[.>o=*N;$7$?>l9g$K$O!"%W%m%;%9$O=*N;$7$?$O$:$G$"$k$,!"(B
Dabatase cluster state$B$O(B"in production"$B$K$J$C$F$$$k2DG=@-$,$"$k!#(B
$B$3$N>l9g$K$OL@$i$+$K@5>o$K=*N;$G$-$J$+$C$?$HH=CG$G$-$k!#(B
$B$^$?!"F1MM$JM}M3$G(B"shutting down"$B$b@5>o$K=*N;$5$l$J$+$C$?$3$H$,(B
$BM=A[.$5$l$k!#(B

$B$H$$$&M}2r$r$7$^$7$?$,!"$3$A$i$NM}2r$,@5$7$1$l$PG<F@$7$^$7$?!#(B

$B$7$+$7(B
postgresql-9.1.0/src/bin/pg_controldata/pg_controldata.c
$B$N(B50$B9TL\IU6a$rFI$`$H(Bcluster state$B$O0J2<$N>uBV$,$"$k$h$&$G$7$?!#(B

1 "starting up"
2 "shut down"
3 "shut down in recovery"
4 "shutting down"
5 "in crash recovery"
6 "in archive recovery"
7 "in production"
8 "unrecognized status code"

$B$3$3$G!"(B4,7$B0J30$K$b(BPrimary$B$r@5>o$K=*N;$G$-$J$+$C$?$G$"$m$&$H(B
$B;W$o$l$k>uBV$O!"(B1,5,8$B$b$"$j$=$&$G$9$,$3$A$i$b9MN8$9$k$N$O$$$+$,$G$7$g$&$+!)(B

$B$^$?(BStandby$B$,0[>o=*N;$7$F$7$^$C$?>l9g$K!"<!2s$N5/F0$GF1MM$K(B
pg_controldata$B$O8+$J$$$N$G$9$+!)(B
(Standby$B$OLdBj$H$J$i$J$$$+$b$7$l$^$;$s$,!#(B)

> $B!&(B $B<jF0$G2?$+%U%i%0%U%!%$%k$N$h$&$JJ*$r:n$l$P!"6/@)E*$K5/F02DG=(B
> $B"*(B $B%*%s%i%$%s%P%C%/%"%C%W$N%G!<%?%j%9%H%";~$O!"$D$$$G$K$3$N%U%!%$%k:n@.$,(B
> $BI,?\$K$J$j$^$9(B

$B$"!<$J$k$[$I!"%Y!<%9%P%C%/%"%C%W$r$H$k$H(B$PGDATA/global/pg_control
$B$b$=$N$^$^%3%T!<$5$l$k$N$G%U%i%0$,I,MW$J$N$G$9$M!#(B

$BJY6/$K$J$j$^$7$?!#(B

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

> $B@9$5$^(B
> $B>>Hx$G$9!#(B
>
> >> migration_threthold $B$O$^$C$?$/9MN8$7$F$$$^$;$s$G$7$?!#(B
> >> $B$=$b$=$b(BMaster $B%j%=!<%9$N(B migration_threthold $B$C$FF0$/$N$+$,5?Ld$G$9$,!"(B
> >> $B$4B8$8$G$9$+!#(B
> >
> > $B$3$A$i$O!";d$bJ,$+$i$J$+$C$?$N$G;n$7$K [at] _D$7$F$_$?$i!"%9%l!<%V$O(B
> > migration_threthold$B$,8z$$$F$/$l$^$7$?!#(B
> > $B%^%9%?$O(Bpromotion score$B$,(B-1000000$B$K$J$C$F$7$^$&$N$G!"$=$b$=$bL5M}(B(?)$B$J$N$+$b(B
> > $B$7$l$^$;$s!#(B
>
> $B$=$N$h$&$G$9$M!#(B
> Master $B$b(B migration_threthold $B$G:F5/F0$7$?$$$H$$$&MWK>$O(B
> $B=P$F$-$=$&$G$9$,!"I,?\5!G=$G$O$J$$$H;W$C$F$$$k$N$G!"(B
> $B>-Mh$N%(%s%O%s%9%a%s%H$H$7$F%a%b$C$F$*$-$^$9!#(B
>
>
> >> $B!|LdBj;v>](B
> >>
> >> $B%9%$%C%A%*!<%P!<;~$N(BPriamry$B$N(Bdemote $BF0:n$O!"(B
> >> $BDL>o$O(Bfast shutdown$B$r<B9T$7!"$3$l$G(BPostgreSQL$B$,(B
> >> $BDd;_$7$J$1$l$P!"(Bimmediate shutdown $B$K@Z$jBX$o$j$^$9!#(B
> >> $B$=$N8e?7(BPrimary$B5/F08e$K5l(BPrimary$B$O(BHot Standby$B$G5/F0$5$l$^$9(B
> >
> > $B$3$A$i$NBP:v$G$9$,!"0J2<$N%Q%i%a!<%?$rD9$a$K$H$k(B
> > $B$GNI$$$N$G$O$J$$$+$H;W$$$^$9$,!#!#(B
> >
> > <parameter name="stop_escalate" unique="0" required="0">
> > <longdesc lang="en">
> > Number of shutdown retries (using -m fast) before resorting to -m immediate
> > </longdesc>
> > <shortdesc lang="en">stop escalation</shortdesc>
> > <content type="integer" default="${OCF_RESKEY_stop_escalation}" />
> > </parameter>
>
> immediate shutdown $BL58z$K$9$k$@$1$J$i!"D9$/$9$k$@$1$G$h$$$N$G$9$,!"(B
> $B$3$l$O$3$l$G%U%'%$%k%*!<%P!<$K;~4V$,$+$+$C$F$7$^$&$H$$$&7gE@$,(B
> $B=P$F$7$^$$$^$9$7!"D9$/$7$F$b(BSTONITH$B$GMn$H$5$l$?$j$9$k$H7k6IF1$8;v>]$,(B
> $BH/@8$7$F$7$^$$$^$9!#(B
>
> $B$A$J$_$K!"%U%'%$%*!<%P!<;~4V$O$J$k$Y$/C;$/$7$?$$$H$$$&(B
> $BMWK>$b8D?ME*$KJ9$/$3$H$,7k9=$"$j$^$9!#(B
>
> > $B$=$b$=$b(Bfast shutdown$B$GDd;_$7$J$$>l9g$H$$$&$H!"%P%C%/%"%C%WCf$^$?$O(B
> > $B2?$+$7$i$N>c32;~$G$O$J$$$G$9$+!)(B
>
> $B%U%'%$%k%;!<%U$N4QE@$G8@$($P!"$3$&$$$C$?>u67$GDd;_$7$?IT [at] 09$J%G!<%?$G$N(B
> $B5/F0$bAK;_$9$kI,MW$J$$$G$9$+!)(B
>
>
> > $B8e<T$N>l9g$K$O!"$=$l$O$=$l$GLdBj$J$N$G!"@Z$jN%$7$F$bNI$$$+$H;W$$$^$7$?!#(B
> >
> > $BA0<T$N>l9g$K$O!"0J2<$N1?MQBP1~$G$bNI$$$+$H(B..
> >
> >> $B!V%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$F%U%'%$%*!<%P!<$7$?>l9g!"(B
> >> $B5l(BPrimary$B$N%G!<%?$r3NG'$7!"I,MW$K1~$8$F?7(BPrimary$B$+$i%G!<%?$r(B
> >> $B%j%9%H%"$9$kI,MW$,$"$k!W(B
>
> $B%3%a%s%H$"$j$,$H$&$4$6$$$^$9!#(B
>
> $B$=$N8e!"$$$m$$$m$H9M$($F$$$?$N$G$9$,!"(B
> $B1?MQ$G<+F0%P%C%/%"%C%W$7$F$$$?>l9g!"(B
> $B%P%C%/%"%C%WCf$K(BPrimary$B$,Mn$A$?$3$H$K5$$E$/$N$OFq$7$$$N$+$J$H(B
> $B;W$$$^$7$?!#(B
>
> Primary$B$N8N>c$GMn$A$?>l9g$OBg>fIW$J$N$G$9$,!"(B
> NW$B8N>c$J$I$K0z$-$:$i$l$FMn$A$k$H!"(BNW$B2sI|;~$K<+F0$G5/F0$7$F$7$^$$$^$9$7!#(B
>
> $B$h$C$F!"$H$j$"$($:0J2<$N;EMM$G<BAu$7$F$_$?$$$H;W$$$^$9!#(B
>
> $B!&(B cluster state $B$,!"(Bshutting down $B$^$?$O(B in production $B$N>l9g$O5/F0$G$-$J$$!#(B
> $B!&(B $B<jF0$G2?$+%U%i%0%U%!%$%k$N$h$&$JJ*$r:n$l$P!"6/@)E*$K5/F02DG=(B
> $B"*(B $B%*%s%i%$%s%P%C%/%"%C%W$N%G!<%?%j%9%H%";~$O!"$D$$$G$K$3$N%U%!%$%k:n@.$,(B
> $BI,?\$K$J$j$^$9(B
>
> $B$b$7!"$3$l$@$1$OHr$1$FM_$7$$$H$$$&%3%a%s%H$b$"$l$P!"(B
> $B$h$m$7$/$*4j$$$7$^$9!#(B
>
>
> $B0J>e$G$9(B
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

--
Yoshiharu Mori <y-mori [at] sraoss>
SRA OSS, Inc Japan http://www.sraoss.co.jp
TEL: 03-5979-2701
FAX: 03-5979-2702

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

matsuo.tak at gmail

Sep 20, 2011, 8:08 PM

Post #7 of 16 (536 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

$B@9$5$s(B
$B>>Hx$G$9!#(B

>> $B!&(B cluster state $B$,!"(Bshutting down $B$^$?$O(B in production $B$N>l9g$O5/F0$G$-$J$$!#(B
>
> $B;d$NM}2r$r [at] 0}$9$k$H!"(B
>
> Primary$B$,@5>o$K5/F0$7$F$$$k>l9g$K$O!"(Bpg_controldata$B$N(B
> Database cluster state$B$O(B "in production"$B$K$J$C$F$$$k$O$:$G$"$k!#(B
> Primary$B$,@5>o$K=*N;$7$?>l9g$K$O!"(BDatabase cluster state
> $B$O(B"shut down"$B$K$J$C$F$$$k$O$:$G$"$k!#(B
> $B$3$3$G!"(BPrimary$B$,0[.>o=*N;$7$?>l9g$K$O!"%W%m%;%9$O=*N;$7$?$O$:$G$"$k$,!"(B
> Dabatase cluster state$B$O(B"in production"$B$K$J$C$F$$$k2DG=@-$,$"$k!#(B
> $B$3$N>l9g$K$OL@$i$+$K@5>o$K=*N;$G$-$J$+$C$?$HH=CG$G$-$k!#(B
> $B$^$?!"F1MM$JM}M3$G(B"shutting down"$B$b@5>o$K=*N;$5$l$J$+$C$?$3$H$,(B
> $BM=A[$5$l$k!#(B
>
> $B$H$$$&M}2r$r$7$^$7$?$,!"$3$A$i$NM}2r$,@5$7$1$l$PG<F@$7$^$7$?!#(B

$B$O$$!#;d$NG'<1$H$"$C$F$$$^$9!#(B

> $B$7$+$7(B
> postgresql-9.1.0/src/bin/pg_controldata/pg_controldata.c
> $B$N(B50$B9TL\IU6a$rFI$`$H(Bcluster state$B$O0J2<$N>uBV$,$"$k$h$&$G$7$?!#(B
>
> 1 "starting up"
> 2 "shut down"
> 3 "shut down in recovery"
> 4 "shutting down"
> 5 "in crash recovery"
> 6 "in archive recovery"
> 7 "in production"
> 8 "unrecognized status code"
>
> $B$3$3$G!"(B4,7$B0J30$K$b(BPrimary$B$r@5>o$K=*N;$G$-$J$+$C$?$G$"$m$&$H(B
> $B;W$o$l$k>uBV$O!"(B1,5,8$B$b$"$j$=$&$G$9$,$3$A$i$b9MN8$9$k$N$O$$$+$,$G$7$g$&$+!)(B

$B$4;XE&$"$j$,$H$&$4$6$$$^$9!#(B

$B$3$s$J$K>uBV$,$"$k$s$G$9$M!&!&!&(B
# $B$9$_$^$;$s!#(BPostgreSQL$B<+BN$K$D$$$F$O=i?4<T$J$b$s$G!&!&!&(B

$B9M$($H$7$F$O!"(BPrimary$B$,%G!<%?$r%m!<%+%k$K$O%3%_%C%H$7$?$,!"(B
$B%l%W%j%1!<%7%g%s$G$-$J$$$^$^Mn$A$?>l9g$NIT [at] 09$rKI$0$N$,L\E*$G$9!#(B

$B$3$l$r9MN8$9$k$H!"(B8 $B$O$I$s$J>uBV$+$o$+$i$J$$$N$G!"(B
$BKI$$$@J}$,$h$5$=$&$G$9$M!#(B

1, 5 $B$N>\$7$$F0:n$,$o$+$i$J$$$N$G$9$,!"(B
$B$3$N>uBV$N;~$O!"%/%i%$%"%s$+$iFI$_=q$-$G$-$k>uBV$J$N$G$7$g$&$+!)(B
$B$=$&$J$i$P!"KI$0BP>]$K$7$?$[$&$,$h$5$=$&$G$9$M!#(B

> $B$^$?(BStandby$B$,0[>o=*N;$7$F$7$^$C$?>l9g$K!"<!2s$N5/F0$GF1MM$K(B
> pg_controldata$B$O8+$J$$$N$G$9$+!)(B
> (Standby$B$OLdBj$H$J$i$J$$$+$b$7$l$^$;$s$,!#(B)

$B$$$(!#8+$h$&$H;W$C$F$$$^$9!#(B
Slave$B$O=q$-9~$_$,$G$-$J$$$N$G!"(Bshutting down $B>uBV$GMn$A$?$H$7$F$b(B
$BKI$0I,MW$O$J$$$H;W$C$F$$$k$N$G$9$,!"5/F0;~$KA02s(BMaster / Slave $B$I$A$i$G(B
$BF0$$$F$$$?$+$O(BPostgreSQL$B$N%G!<%?>uBV$+$iH=JL$G$-$J$$$N$G!#(B

$B0J>e$G$9!#(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Sep 20, 2011, 10:54 PM

Post #8 of 16 (524 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$s(B

$B@9$G$9!#(B

> $B9M$($H$7$F$O!"(BPrimary$B$,%G!<%?$r%m!<%+%k$K$O%3%_%C%H$7$?$,!"(B
> $B%l%W%j%1!<%7%g%s$G$-$J$$$^$^Mn$A$?>l9g$NIT [at] 09$rKI$0$N$,L\E*$G$9!#(B

$BN;2r$G$9!#(B

> $B$3$l$r9MN8$9$k$H!"(B8 $B$O$I$s$J>uBV$+$o$+$i$J$$$N$G!"(B
> $BKI$$$@J}$,$h$5$=$&$G$9$M!#(B

$B$=$&$G$9$M!#(B

> 1, 5 $B$N>\$7$$F0:n$,$o$+$i$J$$$N$G$9$,!"(B
> $B$3$N>uBV$N;~$O!"%/%i%$%"%s$+$iFI$_=q$-$G$-$k>uBV$J$N$G$7$g$&$+!)(B

$B>e5-$N<q;]$+$i$9$k$H%/%i%$%"%s%H$+$i@\B3$G$-$J$$$N$GI,MW$G$O$J$5$=$&$G$9$M!#(B

> # $B$9$_$^$;$s!#(BPostgreSQL$B<+BN$K$D$$$F$O=i?4<T$J$b$s$G!&!&!&(B

$B$$$($$$(!#>-MhE*$K(BPostgreSQL$BMxMQ<T$K$H$C$FHs>o$K=EMW$J%/%i%9%?%D!<%k(B
$B$K$J$k;W$$$^$9!#;d$b1F$J$,$i1~1g$5$;$FD:$-$^$9(B

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

> $B@9$5$s(B
> $B>>Hx$G$9!#(B
>
> >> $B!&(B cluster state $B$,!"(Bshutting down $B$^$?$O(B in production $B$N>l9g$O5/F0$G$-$J$$!#(B
> >
> > $B;d$NM}2r$r [at] 0}$9$k$H!"(B
> >
> > Primary$B$,@5>o$K5/F0$7$F$$$k>l9g$K$O!"(Bpg_controldata$B$N(B
> > Database cluster state$B$O(B "in production"$B$K$J$C$F$$$k$O$:$G$"$k!#(B
> > Primary$B$,@5>o$K=*N;$7$?>l9g$K$O!"(BDatabase cluster state
> > $B$O(B"shut down"$B$K$J$C$F$$$k$O$:$G$"$k!#(B
> > $B$3$3$G!"(BPrimary$B$,0[.>o=*N;$7$?>l9g$K$O!"%W%m%;%9$O=*N;$7$?$O$:$G$"$k$,!"(B
> > Dabatase cluster state$B$O(B"in production"$B$K$J$C$F$$$k2DG=@-$,$"$k!#(B
> > $B$3$N>l9g$K$OL@$i$+$K@5>o$K=*N;$G$-$J$+$C$?$HH=CG$G$-$k!#(B
> > $B$^$?!"F1MM$JM}M3$G(B"shutting down"$B$b@5>o$K=*N;$5$l$J$+$C$?$3$H$,(B
> > $BM=A[$5$l$k!#(B
> >
> > $B$H$$$&M}2r$r$7$^$7$?$,!"$3$A$i$NM}2r$,@5$7$1$l$PG<F@$7$^$7$?!#(B
>
> $B$O$$!#;d$NG'<1$H$"$C$F$$$^$9!#(B
>
> > $B$7$+$7(B
> > postgresql-9.1.0/src/bin/pg_controldata/pg_controldata.c
> > $B$N(B50$B9TL\IU6a$rFI$`$H(Bcluster state$B$O0J2<$N>uBV$,$"$k$h$&$G$7$?!#(B
> >
> > 1 "starting up"
> > 2 "shut down"
> > 3 "shut down in recovery"
> > 4 "shutting down"
> > 5 "in crash recovery"
> > 6 "in archive recovery"
> > 7 "in production"
> > 8 "unrecognized status code"
> >
> > $B$3$3$G!"(B4,7$B0J30$K$b(BPrimary$B$r@5>o$K=*N;$G$-$J$+$C$?$G$"$m$&$H(B
> > $B;W$o$l$k>uBV$O!"(B1,5,8$B$b$"$j$=$&$G$9$,$3$A$i$b9MN8$9$k$N$O$$$+$,$G$7$g$&$+!)(B
>
> $B$4;XE&$"$j$,$H$&$4$6$$$^$9!#(B
>
> $B$3$s$J$K>uBV$,$"$k$s$G$9$M!&!&!&(B
> # $B$9$_$^$;$s!#(BPostgreSQL$B<+BN$K$D$$$F$O=i?4<T$J$b$s$G!&!&!&(B
>
> $B9M$($H$7$F$O!"(BPrimary$B$,%G!<%?$r%m!<%+%k$K$O%3%_%C%H$7$?$,!"(B
> $B%l%W%j%1!<%7%g%s$G$-$J$$$^$^Mn$A$?>l9g$NIT [at] 09$rKI$0$N$,L\E*$G$9!#(B
>
> $B$3$l$r9MN8$9$k$H!"(B8 $B$O$I$s$J>uBV$+$o$+$i$J$$$N$G!"(B
> $BKI$$$@J}$,$h$5$=$&$G$9$M!#(B
>
> 1, 5 $B$N>\$7$$F0:n$,$o$+$i$J$$$N$G$9$,!"(B
> $B$3$N>uBV$N;~$O!"%/%i%$%"%s$+$iFI$_=q$-$G$-$k>uBV$J$N$G$7$g$&$+!)(B
> $B$=$&$J$i$P!"KI$0BP>]$K$7$?$[$&$,$h$5$=$&$G$9$M!#(B
>
> > $B$^$?(BStandby$B$,0[>o=*N;$7$F$7$^$C$?>l9g$K!"<!2s$N5/F0$GF1MM$K(B
> > pg_controldata$B$O8+$J$$$N$G$9$+!)(B
> > (Standby$B$OLdBj$H$J$i$J$$$+$b$7$l$^$;$s$,!#(B)
>
> $B$$$(!#8+$h$&$H;W$C$F$$$^$9!#(B
> Slave$B$O=q$-9~$_$,$G$-$J$$$N$G!"(Bshutting down $B>uBV$GMn$A$?$H$7$F$b(B
> $BKI$0I,MW$O$J$$$H;W$C$F$$$k$N$G$9$,!"5/F0;~$KA02s(BMaster / Slave $B$I$A$i$G(B
> $BF0$$$F$$$?$+$O(BPostgreSQL$B$N%G!<%?>uBV$+$iH=JL$G$-$J$$$N$G!#(B
>
>
> $B0J>e$G$9!#(B
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

--
Yoshiharu Mori <y-mori [at] sraoss>
SRA OSS, Inc Japan http://www.sraoss.co.jp
TEL: 03-5979-2701
FAX: 03-5979-2702

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

matsuo.tak at gmail

Sep 21, 2011, 6:10 PM

Post #9 of 16 (521 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

$B@9$5$s(B
$B>>Hx$G$9!#(B

$B5/F0M^;_$N%m%8%C%/<BAu$7$^$7$?!#(B

https://github.com/t-matsuo/resource-agents/commit/0e4ea2a9644f23096865a002d350f08c487637bf

$B?7$7$$%Q%i%a!<%?(B (force_start_file) $B$rDI2C$7$F$$$^$9!#(B
$B$3$N%Q%i%a!<%?$G!"6/@)5/F0$5$;$?$$>l9g$K:n$k%U%i%0%U%!%$%k$N>l=j$r(B
$BJQ99$G$-$^$9!#(B
$B@5>o5/F08e!"%U%i%0%U%!%$%k$O<+F0:o=|$5$l$^$9!#(B

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

11/09/21 Yoshiharu Mori <y-mori [at] sraoss>:
> $B>>Hx$5$s(B
>
> $B@9$G$9!#(B
>
>> $B9M$($H$7$F$O!"(BPrimary$B$,%G!<%?$r%m!<%+%k$K$O%3%_%C%H$7$?$,!"(B
>> $B%l%W%j%1!<%7%g%s$G$-$J$$$^$^Mn$A$?>l9g$NIT [at] 09$rKI$0$N$,L\E*$G$9!#(B
>
> $BN;2r$G$9!#(B
>
>> $B$3$l$r9MN8$9$k$H!"(B8 $B$O$I$s$J>uBV$+$o$+$i$J$$$N$G!"(B
>> $BKI$$$@J}$,$h$5$=$&$G$9$M!#(B
>
> $B$=$&$G$9$M!#(B
>
>> 1, 5 $B$N>\$7$$F0:n$,$o$+$i$J$$$N$G$9$,!"(B
>> $B$3$N>uBV$N;~$O!"%/%i%$%"%s$+$iFI$_=q$-$G$-$k>uBV$J$N$G$7$g$&$+!)(B
>
> $B>e5-$N<q;]$+$i$9$k$H%/%i%$%"%s%H$+$i@\B3$G$-$J$$$N$GI,MW$G$O$J$5$=$&$G$9$M!#(B
>
>> # $B$9$_$^$;$s!#(BPostgreSQL$B<+BN$K$D$$$F$O=i?4<T$J$b$s$G!&!&!&(B
>
> $B$$$($$$(!#>-MhE*$K(BPostgreSQL$BMxMQ<T$K$H$C$FHs>o$K=EMW$J%/%i%9%?%D!<%k(B
> $B$K$J$k;W$$$^$9!#;d$b1F$J$,$i1~1g$5$;$FD:$-$^$9(B
>
> $B0J>e$G$9!#(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Sep 24, 2011, 5:23 AM

Post #10 of 16 (510 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$s(B

$B@9$G$9!#(B

> https://github.com/t-matsuo/resource-agents/wiki/PostgreSQL-9.1-$B%9%H%j!<%_%s%0%l%W%j%1!<%7%g%sBP1~(B-$B%j%=!<%9%(!<%8%'%s%H(B

$B>e5-$N%I%-%e%a%s%H$N1Q8lHG$,=q$-$+$1$N$h$&$J$N$G:n$C$F$_$^$7$?!#(B
$B;29M$^$G$K$I$&$>(B

*$B2~$a$F%I%-%e%a%s%H$r8+D>$9$H!"(BPostgreSQL$B$K47$l$F$$$J$$?M$K$O(B
$B%;%C%H%"%C%W$,Fq$7$$$+$b$7$l$^$;$s$M!#(B
$B%;%C%H%"%C%W$K$D$$$F$b$&>/$7>\$7$$<j=g$r;d$NJ}$G=q$$$F$b$h$$$G$9$+!)(B
--
Yoshiharu Mori <y-mori [at] sraoss>
SRA OSS, Inc Japan http://www.sraoss.co.jp
TEL: 03-5979-2701
FAX: 03-5979-2702

Attachments:

pacemaker-pgra-en.txt (13.0 KB)

matsuo.tak at gmail

Sep 24, 2011, 6:00 AM

Post #11 of 16 (516 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

盛さん
松尾です。

2011年9月24日21:23 Yoshiharu Mori <y-mori [at] sraoss>:
> 松尾さん
>
> 盛です。
>
>> https://github.com/t-matsuo/resource-agents/wiki/PostgreSQL-9.1-ストリーミングレプリケーション対応-リソースエージェント
>
> 上記のドキュメントの英語版が書きかけのようなので作ってみました。
> 参考までにどうぞ
>
> 改めてドキュメントを見直すと、PostgreSQLに慣れていない人には
> セットアップが難しいかもしれませんね。

そうですね。
あくまでRA仕様メインのドキュメントなので、
初心者向けではないと自分でも認識しています。

きれいにドキュメント書くなら、やっぱりLinux-HA Japan のサイト上ですかね・・・

> セットアップについてもう少し詳しい手順を私の方で書いてもよいですか？

はい。ありがとうございます！！
あまり時間がとれないのと、英語があまり得意ではないので、大変助かります。
RAの仕様が少し変わったので日本語の方も書き換えたいと思いますが、その時は連絡させて
頂きます。

頂いたテキストをWiki形式に整形して反映させて頂きたいと思いますが、
もしご自身のgithubアカウントや他のサーバ上などで書かれた方が効率がよいなら、
そちらにリンクしますのでご連絡ください。

※ githubのWikiを共有できたら便利そうですができそうにないですね
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Sep 27, 2011, 4:23 AM

Post #12 of 16 (498 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$s(B

$B@9$G$9!#(B

> $BK]Lu$7$FD:$$$?$b$N$r!"0J2<$N(BWiki$B$KH?1G$7$^$7$?!#(B
> https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication
>

$B$"$j$,$H$&$4$6$$$^$9!#(B
$B8eF|!"=$@5$K<h$j$+$+$j$^$9$,!"7nKv$G%P%?%P%?$7$F$$$^$9(B($BN^(B)
$B=5Kv:"$KCe<j$7$?$$$H9M$($F$$$^$9!#(B

$B0l1~!"2<5-!"D>6a$N;d$,$d$C$F$*$-$?$$$H$3$m$G$9!#(B
($B<+J,$,8@$$=P$7$?$H$3$m62=L$G$9$,!#!#<jEA$C$F$/$l$kJ}$,$$$l$P@'Hs!*!K(B

-3$B%N!<%I!JF14|(B+$BHsF14|:.:_9=@.$N%F%9%H(B)
-$B?7%Q%i%a!<%?$N%F%9%H(B
-$BF|K\8l%I%-%e%a%s%H$N=$@5$H$=$l$K9g$o$;$F1Q8l%I%-%e%a%s%H$N=$@5(B
-PostgreSQL$B%Q%o!<%f!<%60J30$G$b9=C[$G$-$kDxEY$N%I%-%e%a%s%H$r:n$k(B
-$B$I$5$/$5$KJ6$l$F$K(Bpgpool-II 3.1$B$HAH$_9g$o$;$?Ii2YJ,;6 [at] _DjN$b(B
$B%I%-%e%a%s%H$K=q$$$F$7$^$&$H$+!#(B

$B$D$$$G$K<ALd$H$J$j$^$9$,!"HsF14|%b!<%I(B(2$BBf9=@.(B async$B [at] _D(B)
$B$N<jF0(BPRI$B@Z$jBX$($O4pK\E*$K$G$-$J$$$H$$$&G'<1$G$h$m$7$$$G$7$g$&$+!)(B

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

--
Yoshiharu Mori <y-mori [at] sraoss>

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Oct 10, 2011, 1:36 AM

Post #13 of 16 (466 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$s(B

$B@9$G$9!#(B

$B$9$4!<$/%l%9$,CY$/$J$j$^$7$?!#?=$7Lu$"$j$^$;$s!#(B

> $B?7$7$$%Q%i%a!<%?(B (force_start_file) $B$rDI2C$7$F$$$^$9!#(B

$B$3$A$i$K4X$7$F%3%a%s%H$G$9!#(B

$B9=C[.;~$K$O!"%Y!<%9%P%C%/%"%C%W<hF@$7$F%9%?%s%P%$%5!<%P$K(B
$BE>Aw$9$k$3$H$K$J$j$^$9!#(B
$B$=$N$H$-%9%?%s%P%$%5!<%P$N(Bpg_controldata$B$G<hF@$9$k%G!<%?>uBV$O(B
in production$B$H$J$j$^$9!#(B(primary$B$N%G!<%?>uBV$,$=$N$^$^%3%T!<$5$l$k$?$a(B)

$B<jF0$K$F%9%?%s%P%$$N5/F03NG'$r$7$J$$!"$+$D!"(Bforce_start_file$B$r:n@.$;$:(B
$B$K(Bpacemaker$B$+$i(BPostgreSQL$B$N [at] _D$r9T$C$F5/F0$9$k$H!"?7%Q%i%a!<%?$N5!G=$G!"(B
$BI,$:%9%?%s%P%$$N5/F0$K<:GT$7$F$7$^$&$3$H$K$J$C$F$7$^$$$^$9$h$M!)(B

$B$3$3$G%O%^$C$F$7$^$&?M$,B?$$$h$&$J5$$,$7$^$9!#!#(B

$B$J$K$+%Y!<%9%P%C%/%"%C%W$+$i$N=i2s5/F0$H>c328e$N5/F0$G6hJL$,(B
$B$D$1$P$h$$$O$:$G$9$,!#(B

$B$?$H$($P!"(B
$B=i4|9=C[;~$K%Y!<%9%P%C%/%"%C%W$r<hF@$9$k:]$K$O!"(B
pg_basebackup$B%3%^%s%I$r;H$&J}$,B?$$$H;W$$$^$9!#(B
pg_basebackup$B$G%Y!<%9%P%C%/%"%C%W$r<hF@$9$k$H$-$K%G%U%)%k%H$@$H(B
pg_xlog$B$O6u$H$J$j$^$9!#(B
$B$=$3$G(Bpg_xlog$B$,6u$N>l9g$K$O!"(Bin production$B$G$"$C$F$bL5;k$7$F(B
$B5/F0$7$F$_$k$N$O$$$+$,$G$7$g$&$+!)(B

On Thu, 22 Sep 2011 10:10:42 +0900
Takatoshi MATSUO <matsuo.tak [at] gmail> wrote:

> $B@9$5$s(B
> $B>>Hx$G$9!#(B
>
> $B5/F0M^;_$N%m%8%C%/<BAu$7$^$7$?!#(B
>
> https://github.com/t-matsuo/resource-agents/commit/0e4ea2a9644f23096865a002d350f08c487637bf
>
> $B?7$7$$%Q%i%a!<%?(B (force_start_file) $B$rDI2C$7$F$$$^$9!#(B
> $B$3$N%Q%i%a!<%?$G!"6/@)5/F0$5$;$?$$>l9g$K:n$k%U%i%0%U%!%$%k$N>l=j$r(B
> $BJQ99$G$-$^$9!#(B
> $B@5>o5/F08e!"%U%i%0%U%!%$%k$O<+F0:o=|$5$l$^$9!#(B
>
> $B0J>e$G$9!#(B
>
> 11/09/21 Yoshiharu Mori <y-mori [at] sraoss>:
> > $B>>Hx$5$s(B
> >
> > $B@9$G$9!#(B
> >
> >> $B9M$($H$7$F$O!"(BPrimary$B$,%G!<%?$r%m!<%+%k$K$O%3%_%C%H$7$?$,!"(B
> >> $B%l%W%j%1!<%7%g%s$G$-$J$$$^$^Mn$A$?>l9g$NIT [at] 09$rKI$0$N$,L\E*$G$9!#(B
> >
> > $BN;2r$G$9!#(B
> >
> >> $B$3$l$r9MN8$9$k$H!"(B8 $B$O$I$s$J>uBV$+$o$+$i$J$$$N$G!"(B
> >> $BKI$$$@J}$,$h$5$=$&$G$9$M!#(B
> >
> > $B$=$&$G$9$M!#(B
> >
> >> 1, 5 $B$N>\$7$$F0:n$,$o$+$i$J$$$N$G$9$,!"(B
> >> $B$3$N>uBV$N;~$O!"%/%i%$%"%s$+$iFI$_=q$-$G$-$k>uBV$J$N$G$7$g$&$+!)(B
> >
> > $B>e5-$N<q;]$+$i$9$k$H%/%i%$%"%s%H$+$i@\B3$G$-$J$$$N$GI,MW$G$O$J$5$=$&$G$9$M!#(B
> >
> >> # $B$9$_$^$;$s!#(BPostgreSQL$B<+BN$K$D$$$F$O=i?4<T$J$b$s$G!&!&!&(B
> >
> > $B$$$($$$(!#>-MhE*$K(BPostgreSQL$BMxMQ<T$K$H$C$FHs>o$K=EMW$J%/%i%9%?%D!<%k(B
> > $B$K$J$k;W$$$^$9!#;d$b1F$J$,$i1~1g$5$;$FD:$-$^$9(B
> >
> > $B0J>e$G$9!#(B
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

--
Yoshiharu Mori <y-mori [at] sraoss>

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

matsuo.tak at gmail

Oct 11, 2011, 9:53 PM

Post #14 of 16 (466 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

$B@9$5$s(B
$B>>Hx$G$9(B

2011$BG/(B10$B7n(B10$BF|(B17:36 Yoshiharu Mori <y-mori [at] sraoss>:
> $B>>Hx$5$s(B
>
> $B@9$G$9!#(B
>
> $B$9$4!<$/%l%9$,CY$/$J$j$^$7$?!#?=$7Lu$"$j$^$;$s!#(B

$B$$$($$$(!#(B
$B%3%a%s%HD:$1$k$@$1$G$b=u$+$j$^$9!#(B

>> $B?7$7$$%Q%i%a!<%?(B (force_start_file) $B$rDI2C$7$F$$$^$9!#(B
>
> $B$3$A$i$K4X$7$F%3%a%s%H$G$9!#(B
>
> $B9=C[.;~$K$O!"%Y!<%9%P%C%/%"%C%W<hF@$7$F%9%?%s%P%$%5!<%P$K(B
> $BE>Aw$9$k$3$H$K$J$j$^$9!#(B
> $B$=$N$H$-%9%?%s%P%$%5!<%P$N(Bpg_controldata$B$G<hF@$9$k%G!<%?>uBV$O(B
> in production$B$H$J$j$^$9!#(B(primary$B$N%G!<%?>uBV$,$=$N$^$^%3%T!<$5$l$k$?$a(B)
>
> $B<jF0$K$F%9%?%s%P%$$N5/F03NG'$r$7$J$$!"$+$D!"(Bforce_start_file$B$r:n@.$;$:(B
> $B$K(Bpacemaker$B$+$i(BPostgreSQL$B$N [at] _D$r9T$C$F5/F0$9$k$H!"?7%Q%i%a!<%?$N5!G=$G!"(B
> $BI,$:%9%?%s%P%$$N5/F0$K<:GT$7$F$7$^$&$3$H$K$J$C$F$7$^$$$^$9$h$M!)(B

$B$=$&$G$9$M!#(B

> $B$3$3$G%O%^$C$F$7$^$&?M$,B?$$$h$&$J5$$,$7$^$9!#!#(B

$BK\2H%3%_%e%K%F%#$J$i!"%m%08+$m$C$F8@$o$l$=$&$G$9$,!&!&!&(B

> $B$J$K$+%Y!<%9%P%C%/%"%C%W$+$i$N=i2s5/F0$H>c328e$N5/F0$G6hJL$,(B
> $B$D$1$P$h$$$O$:$G$9$,!#(B
>
> $B$?$H$($P!"(B
> $B=i4|9=C[;~$K%Y!<%9%P%C%/%"%C%W$r<hF@$9$k:]$K$O!"(B
> pg_basebackup$B%3%^%s%I$r;H$&J}$,B?$$$H;W$$$^$9!#(B
> pg_basebackup$B$G%Y!<%9%P%C%/%"%C%W$r<hF@$9$k$H$-$K%G%U%)%k%H$@$H(B
> pg_xlog$B$O6u$H$J$j$^$9!#(B
> $B$=$3$G(Bpg_xlog$B$,6u$N>l9g$K$O!"(Bin production$B$G$"$C$F$bL5;k$7$F(B
> $B5/F0$7$F$_$k$N$O$$$+$,$G$7$g$&$+!)(B

pg_basebackup $B$G$H$C$?%G!<%?$O(Bpg_xlog$B$O6u$+$b$7$l$^$;$s$,!"(B
$B:#2s$N(BRA$B$r;H$&>l9g!"(Bxlog $B$O2?$i$+$N7A$G6&M-$7$F$$$k2DG=@-$,9b$$$N$G!"(B
$B7k6I5/F0;~$O6u$G$O$J$$2DG=@-$,9b$$$N$G$O$J$$$G$7$g$&$+!#(B

$B$b$7%f!<%6$,%O%^$i$J$$$h$&$K$7$?$$$H$$$&$N$,L\E*$J$i!"(B
pgsql-status $B$NB0@-$r(B STOP:invalid $B$N$h$&$JI=<($K$7$F$"$2$F$b$h$$$+$J$H(B
$B;W$$$^$9!#(B

$B$5$i$K!"(BSTOP:invalid $B$K$J$C$?$i!"FCJL$J%j%=!<%9$r5/F0$7!"$=$NCf$G(Brsync $B$G%G!<%?:FF14|$r;O$a!"(B
$BF14|40N;8e$K%U%'%$%k%+%&%s%H%/%j%"$9$k$H$$$&@_7W$bLLGr$$$+$b$7$l$^$;$s!#(B
$B"($*8_$$2u$l$?%G!<%?$r(Brsync$B$9$k$HHa;4$J$3$H$K$J$k$N$G$3$3$^$G%U%k%*!<%H2=$9$k$N$O7k9=62$$$G$9$,!&!&!&(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

y-mori at sraoss

Oct 11, 2011, 10:19 PM

Post #15 of 16 (460 views)
Permalink

Re: PostgreSQL 9.1 $BF1(B$B4\|%l%W%j%1!<%7%g%sBP1~(BRA$B:n$C$F(B$B$_$^$7$?(B [In reply to]

$B>>Hx$5$s(B

$B@9$G$9!#(B

> $B$7$+$7!"8D?ME*$J463P$G$O$d$O$j(B rsync $B%3%^%s%I$J$N$G%G!<%?A4BN$r%P%C%/%"%C%W$9$k(B
> $B?M$b7k9=$$$i$C$7$c$k5$$,$7$^$9$N$G(B($B;d$b$d$C$F$^$9!&!&(B)$B!"$d$O$j(B pg_xlog $B$,6u$+$I$&$+$GH=CG$9$k$N$O(B
> $B$"$^$j4r$7$/$J$$<BAu$+$J$H;W$$$^$9!#(B

$B$?$7$+$K!"(Bxlog$B$G$N3NG'$O$A$g$C$H$I$&$+$J!<$H$$$&46$8$,$7$^$9$M!#(B
force_start_file$B$r5U$KMxMQ$9$k$N$O$$$+$,$G$7$g$&$+!)(B

-$B=i2s$O(Bforce_start_file$B$,B8:_$7$J$$$N$GI,$:N)$A>e$2$r;n$_$k(B
-$B5/F08e$K(Bforce_start_file$B$r:n@.$7(Bforce_start_file$B$r;D$7$F$*$/(B
-force_start_file$B$,$"$k8B$j!"(Bpg_controldata$B$NCM$,@5>o$G$J$$$H5/F0$7$J$$(B
-force_start_file$B$r:o=|$9$k$H>o$KN)$A>e$2$r;n$_$k(B

$B%U%!%$%kL>$H5U$N4X78$G(B($B [at] b@$b(B)$BJ6$i$o$7$$$G$9$,!#!#(B

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

> $B@9$5$s(B
> $B>>Hx$G$9!#(B
>
> > pg_basebackup $B$G$H$C$?%G!<%?$O(Bpg_xlog$B$O6u$+$b$7$l$^$;$s$,!"(B
> > $B:#2s$N(BRA$B$r;H$&>l9g!"(Bxlog $B$O2?$i$+$N7A$G6&M-$7$F$$$k2DG=@-$,9b$$$N$G!"(B
> > $B7k6I5/F0;~$O6u$G$O$J$$2DG=@-$,9b$$$N$G$O$J$$$G$7$g$&$+!#(B
>
> $B<:Ni$$$?$7$^$7$?!#(B
> Primary$B$H(BHot Standby$B$G6&M-$7$F$$$k$N$O!"(Bpg_xlog$B$G$O$J$/!"%"!<%+%$%V$G$7$?$M!#(B
>
> $B$7$+$7!"8D?ME*$J463P$G$O$d$O$j(B rsync $B%3%^%s%I$J$N$G%G!<%?A4BN$r%P%C%/%"%C%W$9$k(B
> $B?M$b7k9=$$$i$C$7$c$k5$$,$7$^$9$N$G(B($B;d$b$d$C$F$^$9!&!&(B)$B!"$d$O$j(B pg_xlog $B$,6u$+$I$&$+$GH=CG$9$k$N$O(B
> $B$"$^$j4r$7$/$J$$<BAu$+$J$H;W$$$^$9!#(B
>
> $B0J>e$G$9!#(B
>
>
> 2011$BG/(B10$B7n(B12$BF|(B13:53 Takatoshi MATSUO <matsuo.tak [at] gmail>:
> > $B@9$5$s(B
> > $B>>Hx$G$9(B
> >
> > 2011$BG/(B10$B7n(B10$BF|(B17:36 Yoshiharu Mori <y-mori [at] sraoss>:
> >> $B>>Hx$5$s(B
> >>
> >> $B@9$G$9!#(B
> >>
> >> $B$9$4!<$/%l%9$,CY$/$J$j$^$7$?!#?=$7Lu$"$j$^$;$s!#(B
> >
> > $B$$$($$$(!#(B
> > $B%3%a%s%HD:$1$k$@$1$G$b=u$+$j$^$9!#(B
> >
> >>> $B?7$7$$%Q%i%a!<%?(B (force_start_file) $B$rDI2C$7$F$$$^$9!#(B
> >>
> >> $B$3$A$i$K4X$7$F%3%a%s%H$G$9!#(B
> >>
> >> $B9=C[.;~$K$O!"%Y!<%9%P%C%/%"%C%W<hF@$7$F%9%?%s%P%$%5!<%P$K(B
> >> $BE>Aw$9$k$3$H$K$J$j$^$9!#(B
> >> $B$=$N$H$-%9%?%s%P%$%5!<%P$N(Bpg_controldata$B$G<hF@$9$k%G!<%?>uBV$O(B
> >> in production$B$H$J$j$^$9!#(B(primary$B$N%G!<%?>uBV$,$=$N$^$^%3%T!<$5$l$k$?$a(B)
> >>
> >> $B<jF0$K$F%9%?%s%P%$$N5/F03NG'$r$7$J$$!"$+$D!"(Bforce_start_file$B$r:n@.$;$:(B
> >> $B$K(Bpacemaker$B$+$i(BPostgreSQL$B$N [at] _D$r9T$C$F5/F0$9$k$H!"?7%Q%i%a!<%?$N5!G=$G!"(B
> >> $BI,$:%9%?%s%P%$$N5/F0$K<:GT$7$F$7$^$&$3$H$K$J$C$F$7$^$$$^$9$h$M!)(B
> >
> > $B$=$&$G$9$M!#(B
> >
> >> $B$3$3$G%O%^$C$F$7$^$&?M$,B?$$$h$&$J5$$,$7$^$9!#!#(B
> >
> > $BK\2H%3%_%e%K%F%#$J$i!"%m%08+$m$C$F8@$o$l$=$&$G$9$,!&!&!&(B
> >
> >> $B$J$K$+%Y!<%9%P%C%/%"%C%W$+$i$N=i2s5/F0$H>c328e$N5/F0$G6hJL$,(B
> >> $B$D$1$P$h$$$O$:$G$9$,!#(B
> >>
> >> $B$?$H$($P!"(B
> >> $B=i4|9=C[;~$K%Y!<%9%P%C%/%"%C%W$r<hF@$9$k:]$K$O!"(B
> >> pg_basebackup$B%3%^%s%I$r;H$&J}$,B?$$$H;W$$$^$9!#(B
> >> pg_basebackup$B$G%Y!<%9%P%C%/%"%C%W$r<hF@$9$k$H$-$K%G%U%)%k%H$@$H(B
> >> pg_xlog$B$O6u$H$J$j$^$9!#(B
> >> $B$=$3$G(Bpg_xlog$B$,6u$N>l9g$K$O!"(Bin production$B$G$"$C$F$bL5;k$7$F(B
> >> $B5/F0$7$F$_$k$N$O$$$+$,$G$7$g$&$+!)(B
> >
> > pg_basebackup $B$G$H$C$?%G!<%?$O(Bpg_xlog$B$O6u$+$b$7$l$^$;$s$,!"(B
> > $B:#2s$N(BRA$B$r;H$&>l9g!"(Bxlog $B$O2?$i$+$N7A$G6&M-$7$F$$$k2DG=@-$,9b$$$N$G!"(B
> > $B7k6I5/F0;~$O6u$G$O$J$$2DG=@-$,9b$$$N$G$O$J$$$G$7$g$&$+!#(B
> >
> > $B$b$7%f!<%6$,%O%^$i$J$$$h$&$K$7$?$$$H$$$&$N$,L\E*$J$i!"(B
> > pgsql-status $B$NB0@-$r(B STOP:invalid $B$N$h$&$JI=<($K$7$F$"$2$F$b$h$$$+$J$H(B
> > $B;W$$$^$9!#(B
> >
> > $B$5$i$K!"(BSTOP:invalid $B$K$J$C$?$i!"FCJL$J%j%=!<%9$r5/F0$7!"$=$NCf$G(Brsync $B$G%G!<%?:FF14|$r;O$a!"(B
> > $BF14|40N;8e$K%U%'%$%k%+%&%s%H%/%j%"$9$k$H$$$&@_7W$bLLGr$$$+$b$7$l$^$;$s!#(B
> > $B"($*8_$$2u$l$?%G!<%?$r(Brsync$B$9$k$HHa;4$J$3$H$K$J$k$N$G$3$3$^$G%U%k%*!<%H2=$9$k$N$O7k9=62$$$G$9$,!&!&!&(B
> >
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

--
Yoshiharu Mori <y-mori [at] sraoss>
SRA OSS, Inc Japan http://www.sraoss.co.jp
TEL: 03-5979-2701
FAX: 03-5979-2702

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

matsuo.tak at gmail

Oct 17, 2011, 3:22 AM

Post #16 of 16 (459 views)
Permalink

Re: PostgreSQL 9.1 同期レプリケーション対応RA作ってみました [In reply to]

$B@9$5$s(B
$B>>Hx$G$9!#(B

$BJV?.CY$/$J$C$F$9$_$^$;$s!#(B

2011$BG/(B10$B7n(B12$BF|(B14:19 Yoshiharu Mori <y-mori [at] sraoss>:
> $B>>Hx$5$s(B
>
> $B@9$G$9!#(B
>
>> $B$7$+$7!"8D?ME*$J463P$G$O$d$O$j(B rsync $B%3%^%s%I$J$N$G%G!<%?A4BN$r%P%C%/%"%C%W$9$k(B
>> $B?M$b7k9=$$$i$C$7$c$k5$$,$7$^$9$N$G(B($B;d$b$d$C$F$^$9!&!&(B)$B!"$d$O$j(B pg_xlog $B$,6u$+$I$&$+$GH=CG$9$k$N$O(B
>> $B$"$^$j4r$7$/$J$$<BAu$+$J$H;W$$$^$9!#(B
>
> $B$?$7$+$K!"(Bxlog$B$G$N3NG'$O$A$g$C$H$I$&$+$J!<$H$$$&46$8$,$7$^$9$M!#(B
> force_start_file$B$r5U$KMxMQ$9$k$N$O$$$+$,$G$7$g$&$+!)(B
>
> -$B=i2s$O(Bforce_start_file$B$,B8:_$7$J$$$N$GI,$:N)$A>e$2$r;n$_$k(B
> -$B5/F08e$K(Bforce_start_file$B$r:n@.$7(Bforce_start_file$B$r;D$7$F$*$/(B
> -force_start_file$B$,$"$k8B$j!"(Bpg_controldata$B$NCM$,@5>o$G$J$$$H5/F0$7$J$$(B
> -force_start_file$B$r:o=|$9$k$H>o$KN)$A>e$2$r;n$_$k(B
>
> $B%U%!%$%kL>$H5U$N4X78$G(B($B [at] b@$b(B)$BJ6$i$o$7$$$G$9$,!#!#(B

$B%U%!%$%kL>$OJQ$($k$H$7$F!">e5-0F$NJ}$,3N$+$K$h$5$=$&$G$9$M!#(B
$B>e5-$N$h$&$K5/F0;~$K%U%i%0$r:n$k$J$i!"@5>o%7%c%C%H%@%&%s;~(B(fast)$B$K!":o=|$7$F$"$2$k$3$H$G!"(B
$B%G!<%?%Y!<%9$N>uBV$r8+$kI,MW$b$J$/$J$j$=$&$G$9!#(B

$B6qBNE*$K$O!"(B

$B@5>o;~(B
$B5/F040N;8e%U%i%0:n@.(B
fast shutdown$B@.8y;~$K%U%i%0:o=|(B
$B<!2s5/F0;~%U%i%0$,$J$$$N$G5/F02DG=(B

$B0[>o;~(B
$B5/F040N;8e%U%i%0:n@.(B
$B0[>o(Bshutdown$B$G%U%i%0;DN1(B
$B<!2s5/F0;~$K%U%i%0$,$"$k$N$G5/F0(BNG
$B"*(B $B%G!<%?%j%9%H%"8e%U%i%0$r:o=|$9$k$3$H$G5!G=2DG=(B

$B$3$l$G:FEY<BAu8!F$$7$F$_$?$$$H;W$$$^$9!#(B

# $B$3$NHyL/$J%G!<%?$NIT [at] 09gLdB$ON>7ODd;_;~$K$b@x$s$G$=$&$G$9(B
# $B>\:Y$o$+$j$^$7$?$^$?O"Mm$7$^$9(B PG$B62$$!&!&!&(B

$B0J>e$G$9!#(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan

Linux-HA japanese RSS feed

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads

& Powered by Gossamer Threads Inc.