Mailing List Archive

$BJV(B: $BJV(B: PG-REX$B:F5/F0;~$NF0:n$K$D$$$F(B
$B#T#o!'$R$,$7MM(B

$B3$F#$G$9!#(B
$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B

> $B$A$J$_$K(BPostgreSQL$B$N%P!<%8%g%s$O$$$/$D$G$7$g$&$+!)(B

OS$B$K(BDebian7.8$B$r;HMQ$7$F$$$kET9g>e(B
PostgreSQL 9.1 $B$r;HMQ$7$F$$$^$9!#(B

> $B$?$7$+!"(BPostgreSQL9.2$B$^$G$O!"0lC6Dd;_$7$?(BMaster$B$X(B
> Slave$B$r@\B3$9$k:]$O!"(Bpg_basebackup$B$,I,?\$@$C$?$H(B
> $B;W$$$^$9!#(B
> (PostgreSQL$BFbIt$N$N(Btimeline ID$B$H$$$&CM$,$:$l$k$?$a!#(B
> $B;29M!'(Bhttp://www.slideshare.net/takmatsuo/postgre-sql-day2012$B!!(B)

$BKhEY$465<xM-Fq$&$4$6$$$^$9!#(B

$B%/%i%9%?%j%s%0MW0x$G$O$J$/(BPostgreSQL$B$N(BVer$BMW0x$J$i(B
PostgreSQL$B$N99?7$r8!F$$7$^$9!#(B

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

-----Original Message-----
From: linux-ha-japan-bounces@lists.osdn.me [mailto:linux-ha-japan-bounces@lists.osdn.me] On Behalf Of kazuh@goo.jp
Sent: Thursday, December 03, 2015 5:14 PM
To: linux-ha-japan@lists.osdn.me
Subject: Re: [Linux-ha-jp] $BJV(B: PG-REX$B:F5/F0;~$NF0:n$K$D$$$F(B

$B3$F#MM(B

$B$R$,$7$H?=$7$^$9!#$*@$OC$K$J$C$F$*$j$^$9!#(B

$B$A$J$_$K(BPostgreSQL$B$N%P!<%8%g%s$O$$$/$D$G$7$g$&$+!)(B

$B$?$7$+!"(BPostgreSQL9.2$B$^$G$O!"0lC6Dd;_$7$?(BMaster$B$X(B
Slave$B$r@\B3$9$k:]$O!"(Bpg_basebackup$B$,I,?\$@$C$?$H(B
$B;W$$$^$9!#(B
(PostgreSQL$BFbIt$N$N(Btimeline ID$B$H$$$&CM$,$:$l$k$?$a!#(B
$B;29M!'(Bhttp://www.slideshare.net/takmatsuo/postgre-sql-day2012$B!!(B)

PostgreSQL$B$,?7$7$$>l9g$G$b!"(BWAL$BJ]4INL$,>/$J$$$J$I$G(B
Slave$B$KI,MW$J(BWAL$B$,:o=|$5$l$?$j$9$k$H!"(Bpg_basebackup$B$,I,?\(B
$B$H$J$j$^$9!#(B


$B$$$?$@$$$?%m%0$rJ,@O$9$k$H!"0J2<$N$h$&$JN.$l$@$C$?$h$&$G$9$M!#(B

Dec 2 11:36:25 DBS02 crmd: [2568]: info: process_lrm_event: LRM operation pgsql:1_start_0 (call=5, rc=0, cib-update=10, confirmed=true) ok
$B"*(B1$B2sL\$N(BSlave$B5/F0$KH<$$!"(Bpgsql$B$N(Bstart$B$O(B(Pacemaker$BE*$K$O(B)$B@.8y(B
$B!!$7$+$7!"3$F#MM?=9p$G$O!"(BMaster$B$K$D$J$,$i$J$+$C$?$H$N$3$H!#(B

Dec 2 11:37:12 DBS02 corosync[2540]: [pcmk ] notice: pcmk_shutdown: Shuting down Pacemaker
$B"*!V$7$+$7!"(BSlave$B$,<+F0E*$K$O%/%i%9%?%j%s%0$K;22C$G$-$J$+$C$?$N$G(B
$B!!(BSlave$BB&$G(BPg_basebackup$B<B;\8e!"(Bcorosync$B:F5/F0$7$?$H$3$m!W(B
$B!!$G(BPacemaker$B$r0lC6Dd;_!#(B

Dec 2 11:37:28 DBS02 crmd: [5844]: info: process_lrm_event: LRM operation pgsql:1_start_0 (call=5, rc=0, cib-update=10, confirmed=true) ok
$B"*$=$N8e!"(Bpg_basebackup$B$r<B;\$7!":FEY(BPacemaker$B5/F0!#(B
$B!!$3$3$G$b!"$d$O$j(Bpgsql$B$N(Bstart$B$O(B(Pacemaker$BE*$K$O(B)$B@.8y!#(B

Dec 2 11:37:30 DBS02 attrd: [5842]: notice: attrd_perform_update: Sent update 14: pgsql-status=HS:sync
$B"*$=$N8e!"(Bpgsql-status$BB0@-CM$,(BHS:sync$B$K$J$C$?!#(B
$B!!!a(BPostgreSQL$BE*$K$b$-$A$s$H(BMaster$B$K$D$J$,$C$?!#(B


1$B2sL\$N(BSlave$B5/F0;~$K(BMaster$B$K$D$J$,$i$J$+$C$?$N$O!"(B
timeline$B$N$:$lEy$G(BPostgreSQL$BE*$K@\B3$G$-$J$+$C$?(B
$B$b$N$N$h$&$G$9!#(B

$BEv3:;~4VBS$N(BPostgreSQL$B$N%m%0$r8+$k$H!"860x$,$o$+$k(B
$B$+$H;W$$$^$9!#(B


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

----- $B85$N%a%C%;!<%8(B -----
From: "kaidou hirokazu" <kaidou.hirokazu@jp.panasonic.com>
$B08@h(B: linux-ha-japan@lists.osdn.me
$BAw?.:Q$_(B: 2015$BG/(B12$B7n(B2$BF|(B, $B?eMKF|(B $B8a8e(B 12:54:17
$B7oL>(B: [Linux-ha-jp] $BJV(B: PG-REX$B:F5/F0;~$NF0:n$K$D$$$F(B

$B#T#o!'$R$,$7MM(B

$B3$F#$G$9!#(B
$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B

> $B!V%7%c%C%H%@%&%s!W!V:F5/F0!W!V%j%V!<%H!W$O(B
> $B$9$Y$F(BOS$B$N$3$H$G$7$g$&$+!#(B

$B$O$$!"A4$F#O#S$N$3$H$G$9!#(B

> $B$$$:$l$K$;$h!"(BPG-REX$B$H$7$F!"(BOS$B$N:F5/F0$r$9$k$3$H$K(B
> $B$h$C$F5/F0$9$k!?$7$J$$$,JQ$o$k$H$$$&$3$H$O$J$$$H(B
> $B;W$$$^$9!#(B

$BN;2r$7$^$7$?!#(B

> $B0lHLO@$H$7$F!"(BSlave$BB&$N%G!<%?$,(BMaster$B$h$jHs>o$K8E$$>l9g(B
> $B$d!"%m%C%/%U%!%$%k$,;D$C$F$$$k>l9g$K(BSlave$B$,5/F0$7$J$$(B
> $B$3$H$O$"$j$^$9!#(B
>
> $B0J2<$K!"(BPG-REX$B$N8x<0%^%K%e%"%k$r8x3+$7$F$$$^$9$N$G!"(B
> $B<j=g$N3NG'$r$*4j$$$$$?$7$^$9!#(B
> $BK\%^%K%e%"%k$G$O!"(BPG-REX$B%3%_%e%K%F%#$,:n@.$7$?%D!<%k$r(B
> $B;HMQ$7$F5/F0$9$k<j=g$K$J$C$F$$$^$9$,!"!VIUO?(BA$B!W$K<jF0(B
> $B$K$h$k5/F0J}K!$b7G:\$7$F$$$^$9$N$G!"$=$A$i$r;29M$K$5$l$k$H(B
> $B$h$$$H;W$$$^$9!#(B

$B$465<xM-Fq$&$4$6$$$^$9!#(B
$B<jF0$N<j=g$r3NG'$7$F!"4|BTDL$j$N7k2L$,F@$i$l$k$h$&$J$i(B
$B$$$D$G$bF1$8<j=g$K$J$k$h$&$K%9%/%j%W%H$G$b:n@.$7$?$$$H(B
$B;W$$$^$9!#(B

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


-----Original Message-----
From: linux-ha-japan-bounces@lists.osdn.me [mailto:linux-ha-japan-bounces@lists.osdn.me] On Behalf Of kazuh@goo.jp
Sent: Wednesday, December 02, 2015 9:35 AM
To: linux-ha-japan@lists.osdn.me
Subject: Re: [Linux-ha-jp] PG-REX$B:F5/F0;~$NF0:n$K$D$$$F(B

$B3$F#MM(B

$B$R$,$7$H?=$7$^$9!#$*@$OC$K$J$C$F$*$j$^$9!#(B

$B!V%7%c%C%H%@%&%s!W!V:F5/F0!W!V%j%V!<%H!W$O(B
$B$9$Y$F(BOS$B$N$3$H$G$7$g$&$+!#(B

$B$$$:$l$K$;$h!"(BPG-REX$B$H$7$F!"(BOS$B$N:F5/F0$r$9$k$3$H$K(B
$B$h$C$F5/F0$9$k!?$7$J$$$,JQ$o$k$H$$$&$3$H$O$J$$$H(B
$B;W$$$^$9!#(B

$B0lHLO@$H$7$F!"(BSlave$BB&$N%G!<%?$,(BMaster$B$h$jHs>o$K8E$$>l9g(B
$B$d!"%m%C%/%U%!%$%k$,;D$C$F$$$k>l9g$K(BSlave$B$,5/F0$7$J$$(B
$B$3$H$O$"$j$^$9!#(B

$B0J2<$K!"(BPG-REX$B$N8x<0%^%K%e%"%k$r8x3+$7$F$$$^$9$N$G!"(B
$B<j=g$N3NG'$r$*4j$$$$$?$7$^$9!#(B
$BK\%^%K%e%"%k$G$O!"(BPG-REX$B%3%_%e%K%F%#$,:n@.$7$?%D!<%k$r(B
$B;HMQ$7$F5/F0$9$k<j=g$K$J$C$F$$$^$9$,!"!VIUO?(BA$B!W$K<jF0(B
$B$K$h$k5/F0J}K!$b7G:\$7$F$$$^$9$N$G!"$=$A$i$r;29M$K$5$l$k$H(B
$B$h$$$H;W$$$^$9!#(B

https://osdn.jp/projects/pg-rex/releases/64071


$B$^$?!"<jA0L#A9$K$J$j$^$9$,!"0J2<$G(BPG-REX$B$N1?MQ$K$D$$$F(B
$B%N%&%O%&$r$^$H$a$F$_$^$7$?!#(B

http://linux-ha.osdn.jp/wp/archives/4137
$B!V(BPG-REX$B$G3X$V(BPacemaker$B1?MQ$N<BNc!W(B


$B8N>c8e$N5sF0$*$h$SI|5l$K$D$$$F$^$H$a$?$N$G!"$3$A$i$b(B
$B;29M$K$J$l$P9,$$$G$9!#(B


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

----- $B85$N%a%C%;!<%8(B -----
From: "kaidou hirokazu" <kaidou.hirokazu@jp.panasonic.com>
$B08@h(B: linux-ha-japan@lists.osdn.me
$BAw?.:Q$_(B: 2015$BG/(B11$B7n(B27$BF|(B, $B6bMKF|(B $B8a8e(B 4:37:42
$B7oL>(B: [Linux-ha-jp] PG-REX$B:F5/F0;~$NF0:n$K$D$$$F(B

$B3$F#$H?=$7$^$9!#(B
$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B

PG-REX$B=L>.%P!<%8%g%s$G8+@Z$jH/<V>uBV$G1?MQ$r3+;O$7$?$N$G$9$,!"(B
$BN>(Bnode$B$r%7%c%C%H%@%&%s$7$J$1$l$P$J$i$J$$:]$K:$$C$F$^$9!#(B

Slave$B"M(BMaster$B$N=g$KN>(Bnode$B$r%7%c%C%H%@%&%s$7$?8e!"(B
Master(node)$B$r@h$K5/F0$7!"(BPostgreSQL$B5Z$S2>A[(BIP$B$,F0:n$7;O$a$F$+$i(B
Slave(node)$B$r5/F0$7$F$b(BSlave$B$H$7$F%/%i%9%?%j%s%0$K;22C$7$^$;$s!#(B

$B$7$+$7!"(BSlave$B$r%7%c%C%H%@%&%s8e:F5/F0Kt$O%j%V!<%H$N>l9g$O(B
Slave$B$H$7$F%/%i%9%?%j%s%0$KI|5"$7$^$9!#(B

PG-REX$B$NF0:n$O$b$H$b$H$3$&$$$&$b$N$J$N$G$7$g$&$+!)(B
$B2?J}$+%"%I%P%$%9$r$*4j$$$7$^$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
($B9)5;78BeI=(B) $B30@~(B:050-3686-1872
($B9)5;78BeI=(B) $BFb@~(B:7-375-8639
===================================================

_______________________________________________
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

_______________________________________________
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

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan