$B0KF#MM(B
$B$R$,$7$H?=$7$^$9!#(B
$B$*@$OC$K$J$j$^$9!#(B
>PostgreSQL$B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7!"(B
>$B$5$i$K!"(BMaster$B#1Bf!\(BSlave$B#2Bf9=@.$K$7$?>l9g$G$b(BPacemaker$B$G@)8f2DG=$G$7$g$&$+!)(B
$B;DG0$J$,$i!"(BPacemaker($B$H$$$&$+(Bpgsql RA)$B$O!"(B3$BBf$N(BPostgreSQL$B$G%l%W%j%1!<%7%g%s$N(B
$B@)8f$r$9$k$3$H$O$G$-$^$;$s!#(B
3$B=E2=$9$k>l9g!"$^$:(B2$BBf$G(BPacemaker$B$rMQ$$(BMaster-Slave$B9=@.$rAH$_!"(B
$B$=$N(BSlave$B$K#3BfL\$r(BPacemaker$B$r;H$o$:$K@\B3$5$;$k!"$H$$$&J}K!$,(B
$B9M$($i$l$^$9!#(B
Master <--- Slave(1) <--- Slave(2)
$B",(B $B",(B $B",(B
Pacemaker$B$G4IM}(B $B<jF0$G(BSlave(1)$B$K@\B3(B
($B$$$o$f$k(BPG-REX)
Master$B$*$h$S(BSlave(1)$B$O(BPacemaker$B$G4IM}$7$F$$$k$N$G!"(BMaster$B$^$?$O(BSlave(1)$B$,(B
$B8N>c$7$?>l9g$O!"<+F0E*$K%U%'%$%k%*!<%P$7%5!<%S%9$,7QB3$7$^$9!#(B
Slave(2)(3$BBfL\(B)$B$O(BPacemaker$B$,4IM}$7$F$$$J$$$N$G!"(BMaster$B$H(BSlave(1)$B$,8N>c$7$?>l9g$O!"(B
$B<jF0$G(Bpg_ctl promote $B%3%^%s%I$r<B9T$7!"(BMaster$B2=$9$kI,MW$,$"$j$^$9!#(B
Slave(2)$B$K$O<jF0$G(Brecovery.conf$B$r:n@.$7!"(BSlave(1)$B$G2TF/$7$F$$$k2>A[.(BIP$B%"%I%l%9(B
(vip-slave)$B$K@\B3$5$;$^$9!#(B
$B$3$&$9$k$3$H$G!"(BMaster$B$^$?$O(BSlave(1)$B$,8N>c$7$?>l9g$G$b!"(BPacemaker$B$,2>A[.(BIP$B$r(B
$BF0$+$9$3$H$G(BSlave(2)$B$N%l%W%j%1!<%7%g%s@\B3$O<+F0E*$K7QB3$7$^$9!#(B
$B$J$*!"$3$NF0:n$N$?$a!"K\9=@.$K$O!"(BPostgreSQL9.3$B0J>e$,I,?\$G$9!#(B
Slave(2)$B$O!"D>@\(BMaster$B$K@\B3$9$k$3$H$b$G$-$^$9$,!"$=$N>l9g!"(BSlave(1)$B$h$j$b(B
$B%G!<%?$,?J$s$G$7$^$&>l9g$,$"$j!"$=$N=V4V$K%U%'%$%k%*!<%P$,H/@8$9$k$H!"(B
$B?7(BMaster($B5l(BSlave(1))$B$K@\B3$G$-$J$/$J$k!"$H$$$&LdBj$,H/@8$9$k2DG=@-$,$"$k$?$a(B
$B$*4+$a$7$^$;$s!#(B
$B>e5-$N$h$&$K?t<n$D$J$.(B($B%+%9%1!<%I(B)$B$K$9$k$3$H$r$*4+$a$7$^$9!#(B
$B$J$*!"(BPG-REX$B$*$h$S(BPostgreSQL$B$K$D$$$F$O0J2<%5%$%H$J$I$b;29M$K$J$k$H;W$$$^$9!#(B
$B"#(BJPUG $BBh(B24$B2s$7$/$_(B+$B%"%W%j%1!<%7%g%sJY6/2q(B $B%;%_%J!<;qNA(B
$B!!(B
http://linux-ha.osdn.jp/wp/archives/3404 $B"#(BOSC 2015 Fukuoka$B9V1i(B
$B!!(B
http://linux-ha.osdn.jp/wp/archives/4137 $B!!"*(BPG-REX$B$G3X$V(BPacemaker$B1?MQ$N<BNc(B
$B"#(BPG-REX$B8x<0%5%$%H!':G?7%^%K%e%"%k(B
$B!!(B
https://osdn.jp/projects/pg-rex/releases/63003 $B!!"*(BPG-REX9.4$BMxMQ%^%K%e%"%k(B_$BBh(B1.0$BHG(B($B8x3+MQMxMQ<T%^%K%e%"%k(B).docx
$B"#(BPostgreSQL$B8x<0%^%K%e%"%k!'%+%9%1!<%I%l%W%j%1!<%7%g%s(B
$B!!(B
https://www.postgresql.jp/document/9.4/html/warm-standby.html#CASCADING-REPLICATION $B0J>e$G$9!#(B
$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
----- $B85$N%a%C%;!<%8(B -----
From: "itohysh" <itohysh@yahoo.co.jp>
$B08@h(B: kazuh@goo.jp, linux-ha-japan@lists.osdn.me
$BAw?.:Q$_(B: 2016$BG/(B3$B7n(B17$BF|(B, $BLZMKF|(B $B8aA0(B 5:38:41
$B7oL>(B: Re: [Linux-ha-jp] $B$*Ld$$9g$o$;(B
$B$R$,$7MM(B
$B$42sEz$"$j$,$H$&$4$6$$$^$9!#(B
$B$$$?$@$$$?>pJs$G;n$7$F$_$^$9!#(B
$BDI2C$G<ALd$J$N$G$9$,!"(B
PostgreSQL$B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7!"(B
$B$5$i$K!"(BMaster$B#1Bf!\(BSlave$B#2Bf9=@.$K$7$?>l9g$G$b(B
Pacemaker$B$G@)8f2DG=$G$7$g$&$+!)(B
$B2?$+CN8+$,$"$j$^$7$?$i!"$465<x$$$?$@$1$k$H9,$$$G$9!#(B
$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
----- Original Message -----
From: "kazuh@goo.jp" <kazuh@goo.jp>
To: $B0KF#(B $B9/90(B <itohysh@yahoo.co.jp>; linux-ha-japan@lists.osdn.me
Date: 2016/3/14, Mon 15:03
Subject: Re: [Linux-ha-jp] $B$*Ld$$9g$o$;(B
$B0KF#MM(B
$B$R$,$7$H?=$7$^$9!#(B
$B$*@$OC$K$J$j$^$9!#(B
>PostgreSQL $B$H(B Pacemaker $B$rMQ$$$F(B HA $B%/%i%9%?4D6-$r9=C[$7!"(B
>PostgreSQL $B$N%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$G%G!<%?F14|$7$h$&$H$7$F$$$^$9$,!"(B
>PostgreSQL $B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7$?>l9g$G$b(B
>Pacemaker $B$G(B HA $B%/%i%9%?4D6-$r9=C[2DG=$J$N$G$7$g$&$+!)(B
$B<B:]$K9=C[$7$?$3$H$OL5$$$N$G$9$,!"M}O@E*$K$O(B
$B2DG=$J$O$:$G$9!#(B
$B6qBNE*$K$O!"(BPGDATA$BNN0h$d%]!<%HEy$r$-$A$s$H(B
$B8DJL$N$b$N$KJ,$1$F$$$?$@$1$l$PBg>fIW$H;W$$$^$9!#(B
pgsql RA$B$N%Q%i%a!<%?$G$$$&$H!"0J2<$O:GDc8B!"(B
$B$7$C$+$jJ,$1$kI,MW$,$"$k$H;W$$$^$9!#(B
start_opt$B!'%]!<%H$r5-:\$7$F$$$k>l9g%]!<%H(B
pgdata$B!'(BPGDATA$BNN0h(B
pgport$B!'%]!<%H(B
restore_command$B!'%"!<%+%$%VG[.CV%G%#%l%/%H%j(B
$B!tB>$b4D6-$K1~$8E,59E,@Z$K@_Dj$7$F$/$@$5$$!#(B
$B0J>e$G$9!#(B
$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
----- $B85$N%a%C%;!<%8(B -----
From: "$B0KF#(B $B9/90(B" < itohysh@yahoo.co.jp >
$B08@h(B: linux-ha-japan@lists.osdn.me
$BAw?.:Q$_(B: 2016$BG/(B3$B7n(B11$BF|(B, $B6bMKF|(B $B8a8e(B 3:12:38
$B7oL>(B: [Linux-ha-jp] $B$*Ld$$9g$o$;(B
$B0KF#$H?=$7$^$9!#(B
$B<ALd$5$;$F$$$?$@$-$^$9!#(B
PostgreSQL $B$H(B Pacemaker $B$rMQ$$$F(B HA $B%/%i%9%?4D6-$r9=C[$7!"(B
PostgreSQL $B$N%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$G%G!<%?F14|$7$h$&$H$7$F$$$^$9$,!"(B
PostgreSQL $B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7$?>l9g$G$b(B
Pacemaker $B$G(B HA $B%/%i%9%?4D6-$r9=C[2DG=$J$N$G$7$g$&$+!)(B
$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan _______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan