海藤 廣一
kaido****@jp*****
2015年 9月 7日 (月) 14:07:40 JST
$B$R$,$7MM(B $B3$F#$G$9!#(B $B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B $B$4;XF3M-Fq$&$4$6$$$^$9!#(B > $B%m%0$rGR8+$7$?$H$3$m!"(BDBS-PRI$BB&$G(BPostgreSQL$B$,(BPacemaker$B$K(B > $B$h$C$F5/F0$5$l$?:]$K!"%m%C%/%U%!%$%k$G$"$k(B > /var/lib/pgsql/tmp/PGSQL.lock > $B$,B8:_$7$F$$$?$?$a$K5/F0$K<:GT$7$?$h$&$G$9!#(B > > Sep 3 10:44:40 DBS-PRI lrmd: [5595]: info: rsc:pgsql:0 start[9] (pid 5921) > $B!!"*(BPacemaker$B$K$h$j(BPostgreSQL$B$N5/F0$,;n$_$i$l$?$,!&!&(B > > Sep 3 10:44:40 DBS-PRI pgsql(pgsql:0)[5921]: ERROR: My data may be inconsistent. You have to remove /var/lib/pgsql/tmp/PGSQL.lock file to force start. > $B!!"*%m%C%/%U%!%$%k$,B8:_$N$?$a5/F0<:GT(B $B$3$N$"$?$j$r=EE ＠ E*$K3NG'$7$^$9!#(B $B$=$l$+$i(BPG-REX$B$N7o!"M-Fq$&$4$6$$$^$9!#(B $B%^%K%e%"%k$OAaB.%@%&%s%m!<%I$7$^$7$?!#(B $B;29M$K$5$;$FD:$-$^$9!#(B $B$H$3$m$G!";d$N$H$3$m$G$O(BPG-REX$B$h$j$b%7%s%W%k$J9=@.$r9M$($F$$$^$9!#(B $BJ*M}(BNIC$B$N#2Kg0J>e;HMQ!J(BS-LAN$B$H(BD-LAN$B$NJ,3d!K$OA[Dj$7$F$$$^$;$s!#(B $BJD$8$?(BLAN$B$J$N$G%M%C%H%o!<%/$NIi2Y$OHs>o$KDc$$0Y$G$9!#(B $B$^$?!"JD$8$?(BLAN$B$G$"$k$?$a%k!<%?!<$NMM$J8GDj(BIP$B$G(BPing$B1~Ez$9$k(B $BAj<j$,$$$^$;$s!#(B $B$d$j$?$$$3$H$O(B $B-!#2Bf$N%[%9%H$G(BPostgresql$B$r%l%W%j%1!<%7%g%s$GFs=E2=$7$I$A$i$+$,(B $B!!%@%&%s$7$?$i%U%'%$%k%*!<%P!<$5$;$F$7$P$i$/JRB&$GF0:n$5$;$k!#(B $B-"%/%i%$%"%s%H$+$i$O%^%9%?!<B&$+$i%9%l!<%VB&(BIP$B$K ＠ ZBX$rI,MW$5$;$J$$(B $B!!$?$a$K%^%9%?!<$N2>A[(BIP$B$K%"%/%;%9$5$;$k!#(B $B-#F14|%l%W%j%1!<%7%g%s$r;HMQ$7$?$$!#(B $B-$%U%'%$%k%*!<%P!<8e$N%a%s%F%J%s%9$rHQ;($J$b$N$K$7$?$/$J$$(B $B!!!J?7%[%9%H$rMQ0U$7$F@\B3$7$F%U%'%$%k%P%C%/$G$-$l$PNI$$!K(B $B>e5-$N-!-"$,(BMUST$B!&!&!&$3$l$i$@$1$J$iBP1~J}K!$O8!F$:Q$G$9!#(B $B-#-$$O$G$-$l$P!&!&!&$J$N$G$9$,!"$3$N$?$a$K6lO+$7$F$$$^$9!#(B $B>e5-9=@.$GLd9g$;$9$k ＠ h$H$7$F$O(BPG-REX$B$N%3%_%e%K%F%#!<$NJ}$,(B $B$h$m$7$$$N$G$7$g$&$+!)(B On Mon, 7 Sep 2015 12:09:39 +0900 (JST) kazuh****@goo***** wrote: > $B3$F#MM(B > > $B$R$,$7$H?=$7$^$9!#(B > $B$*@$OC$K$J$C$F$*$j$^$9!#(B > > $B%m%0$rGR8+$7$?$H$3$m!"(BDBS-PRI$BB&$G(BPostgreSQL$B$,(BPacemaker$B$K(B > $B$h$C$F5/F0$5$l$?:]$K!"%m%C%/%U%!%$%k$G$"$k(B > /var/lib/pgsql/tmp/PGSQL.lock > $B$,B8:_$7$F$$$?$?$a$K5/F0$K<:GT$7$?$h$&$G$9!#(B > > Sep 3 10:44:40 DBS-PRI lrmd: [5595]: info: rsc:pgsql:0 start[9] (pid 5921) > $B!!"*(BPacemaker$B$K$h$j(BPostgreSQL$B$N5/F0$,;n$_$i$l$?$,!&!&(B > > Sep 3 10:44:40 DBS-PRI pgsql(pgsql:0)[5921]: ERROR: My data may be inconsistent. You have to remove /var/lib/pgsql/tmp/PGSQL.lock file to force start. > $B!!"*%m%C%/%U%!%$%k$,B8:_$N$?$a5/F0<:GT(B > > $B$3$N%U%!%$%k$O!"Ev3:%N!<%I$N(BPostgreSQL$B$,0lEY(BPacemaker$B$K(B > $B$h$j5/F0$5$l$?8e!"M=4|$;$L%(%i!<Ey$G ＠ 5>o$KDd;_$G$-$J$+$C$?(B > $B>l9g$K;DB8$7!"(BPostgreSQL$B$N%G!<%?$,8E$$$+$b$7$l$J$$$3$H$r(B > $B%f!<%6$K5$$E$$$F$b$i$&$?$a$N$b$N$G$9!#(B > pgsql RA$B$,:n ＠ .!":o=|!J ＠ 5>oDd;_;~$K!K$r$7$F$$$^$9!#(B > > $B$3$N%N!<%I$N%G!<%?$KLdBj$,L5$$>l9g!"N>7O$N(BPacemaker$B$rDd;_$7!"(B > $B$3$N%U%!%$%k$r<jF0$G:o=|$7!"(BPacemaker$B$r5/F0$9$l$P!"(BPostgreSQL$B$O(B > $B5/F0$9$k$H;W$$$^$9!#(B > > $B$J$*!"%m%0$+$i!"(BMaster$BB&$H(BSlave$BB&$N(BPacemaker$B$rF1;~$K(B > $BN)$A>e$2$F$$$k$H$*8+<u$1$7$^$7$?$,!"$3$N9=@.$N>l9g!"(B > $B$^$:(BMaster$B$N$_$rN)$A>e$2!"(BPostgreSQL$B$,(BMaster$B$H$7$F5/F0$7$?(B > $B$3$H$r3NG'$7!":G?7%G!<%?$r(BSlave$B$K%3%T!<$7$F$+$i(BSlave$BB&$r(B > $BN)$A>e$2$k$3$H$r$*4+$a$7$^$9!#(B > pgsql RA$B$O!"F1;~$K5/F0$7$?>l9g!"$I$A$i$r(BMaster$B$K$9$k$+$N(B > $BH=CG$r$G$-$J$$!J$I$A$i$N(BDB$B%G!<%?$r?.Mj$9$Y$-$+$O%f!<%6$N$_$,(B > $BH=CG$G$-$k$3$H$G(BRA$B$K$O$o$+$i$J$$!K$?$a$G$9!#(B > > > > $B$J$*!"3$F#MM$,9=C[$7$F$$$k$h$&$J(BPostgreSQL$B$N%9%H%j(B-$B%_%s%0(B > $B%l%W%j%1!<%7%g%s$H(BPacemaker$B$N(BMaster/Slave$B5!G=$rAH$_9g$o$;$?(B > $B9=@.$r!"(BLinux-HA Japan$B$G$O!V(BPG-REX$B!W!J$T!<$8!<$l$C$/$9!K$H(B > $B8F$S!"FHN)$7$?%3%_%e%K%F%#$bN)$A>e$2$F$$$^$9!#(B > > https://osdn.jp/projects/pg-rex/ > > $B$=$3$K!"(BPG-REX$B$N9=C[!A1?MQ$NF|K\8l%I%-%e%a%s%H$rMQ0U$7$F$$$^$9(B > $B$N$G!"$h$1$l$P$4;29M$/$@$5$$!#(B > $B!t$?$@$7!"0J2<:G?7HG$O(BCentOS6+Pacemaker1.1.12+PostgreSQL9.4$B$rA0Ds$H(B > $B!!$7$F$$$^$9!#(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!t!V1?MQJd=u%D!<%k!W$K$h$k<j=g$,5-:\$5$l$F$$$^$9$,!"(BDebian$B$G$O(B > $B!!F0:n$7$J$$$H;W$$$^$9!#(B > $B!!%D!<%k$rMQ$$$J$$<j=g$,(BP161$B$N!VIUO?(BA$B!W$K7G:\$5$l$F$$$k$N$G(B > $B!!$=$A$i$r;2>H$7$F$/$@$5$$!#(B > > > $B0J>e$G$9!#(B > $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B > > ----- $B85$N%a%C%;!<%8(B ----- > From: "$B3$F#(B $BW"0l(B" <kaido****@jp*****> > $B08 ＠ h(B: linux****@lists***** > $BAw?.:Q$_(B: 2015$BG/(B9$B7n(B3$BF|(B, $BLZMKF|(B $B8aA0(B 11:04:24 > $B7oL>(B: Re: [Linux-ha-jp] pacemaker$B$+$i(Bpostgresql$B$r5/F0=PMh$J$$7o(B > > $B>>EgMM(B > > $B3$F#$G$9!#(B > $B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B > > corosync$B$r%j%9%?!<%H$5$;$?$i(Bpostgresql$B$,JRB&$N$_$N5/F0$K$J$C$F$7$^$$(B > $B860x$NFCDj$9$i=PMh$J$$$G$*$j$^$9!#(B > > postgresql.conf$B$N%m%0 ＠ _DjItJ,$rJQ99$7$?7k2L!"5/F0$7$?B&$O%m%0$,=PNO(B > $B$5$l$k$h$&$K$J$j$^$7$?!#(B > $B$7$+$7!"5/F0$7$J$+$C$?B&$+$i$K$D$$$F$O(Bsyslog$B$N$_$H$J$C$F$7$^$$$^$9!#(B > > resource-agents$B0J30$K%P!<%8%g%s$,8E$$$HIT6q9g$,$G$k$b$N$O(B > $B$J$$$N$G$7$g$&$+!)(B > > libpils2_1.0.12$B$H(Blibplumbgpl2_1.0.12$B$r0MB84X78L5;k$7$F6/@)%$%s%9%H!<%k(B > $B$7$?$H$3$m!"(Bcorosync$B$N%W%m%;%9$,$$$D$N4V$K$+%@%&%s$7$F$$$k$3$H$,$"$j(B > $B$d$`$rF@$:La$7$^$7$?!#(B > > > > $B8!:w$7$F$b2?$b=P$F$-$^$;$s$G$7$g$&$+(B... > > # find -name 'postgresql-*.log' > > > > $B5/F0$G$3$1$F$$$k$h$&$J>l9g$K$O!"(Bpg_startup.log$B$b$7$/$O(Bpgstartup.log$B$N$h$&$JL>A0$N%m%0%U%!%$%k$K=P$F$$$k$+$b$7$l$^$;$s!#(B > > $B$3$i$i$N%m%0%U%!%$%k$O ＠ _DjJQ99$7$?8e$bB8:_$7$F$$$^$;$s$G$7$?!#(B > > > $B%"%I%P%$%959$7$/$*4j$$$7$^$9!#(B > > > On Tue, 1 Sep 2015 17:17:55 +0900 > Takehiro Matsushima <takeh****@gmail*****> wrote: > > > $B3$F#(B $B$5$s(B > > > > $B>>Eg$G$9!#(B > > > > > Postgresql$B$N(BMaster/Slave$B4V$GDL?.$G$-$J$$$3$H$,LdBj$H$$$&;v(B > > > $B$G$9$h$M!)(B > > $B%m%0$rGR8+$7$F$$$J$$$N$G2?$H$b8@$($^$;$s$,!"$=$&$G$O$J$$$+$H;d$O9M$($F$$$^$9!#(B > > > > > > > $B$3$3$,;DG0$J$N$G$9$,!"(B/etc/init.d/postgresql start$B$G5/F0$9$k$H%m%0$,(B > > > $B;D$k$N$G$9$,!"(Bcorosync$B$+$i5/F0$9$k$H(B/var/log/postgresql$B$K%m%0$,A4$/(B > > > $B;D$C$F$$$^$;$s!#(B > > > > $B8!:w$7$F$b2?$b=P$F$-$^$;$s$G$7$g$&$+(B... > > # find -name 'postgresql-*.log' > > > > $B5/F0$G$3$1$F$$$k$h$&$J>l9g$K$O!"(Bpg_startup.log$B$b$7$/$O(Bpgstartup.log$B$N$h$&$JL>A0$N%m%0%U%!%$%k$K=P$F$$$k$+$b$7$l$^$;$s!#(B > > > > $B0J>e$43NG'$/$@$5$$!#(B > > > > ---- > > Takehiro Matsushima > > _______________________________________________ > > Linux-ha-japan mailing list > > Linux****@lists***** > > http://lists.osdn.me/mailman/listinfo/linux-ha-japan > > > > =================================================== > $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:kaido****@jp***** > ($B9)5;78BeI=(B) $B30@~(B:050-3686-1872 > ($B9)5;78BeI=(B) $BFb@~(B:7-375-8639 > =================================================== > > _______________________________________________ > Linux-ha-japan mailing list > Linux****@lists***** > http://lists.osdn.me/mailman/listinfo/linux-ha-japan =================================================== $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:kaido****@jp***** ($B9)5;78BeI=(B) $B30@~(B:050-3686-1872 ($B9)5;78BeI=(B) $BFb@~(B:7-375-8639 ===================================================
Fork