[prev in list] [next in list] [prev in thread] [next in thread] 

List:       linux-ha-jp
Subject:    [Linux-ha-jp] =?iso-2022-jp?b?IFJlOiAgMhskQjduGyhCMjA=?= =?iso-2022-jp?b?GyRCRnwlaiVqITwlOSROGyhCUG9
From:       kazuh () goo ! jp
Date:       2014-02-27 8:03:29
Message-ID: e88e7e4b-3125-381a-9f88-05fea4fd269b () api101
[Download RAW message or body]

$B>>Eg$5$s(B

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


PostgreSQL$BC1BN$G$N:F8=J}K!$,$o$+$j$^$7$?!#(B

== $B:F8=<j=g(B ==
 1. recovery.conf$B$J$7$G(BPG$B5/F0(B
    $B"*(BPostgreSQl$B$,IaDL$K(B($B99?72DG=>uBV(B)$B5/F0(B

     $ ls $PGDATA/recovery.conf
     ls: cannot access /var/lib/pgsql/9.3/data/recovery.conf: \
$B$=$N$h$&$J%U%!%$%k$d%G%#%l%/%H%j$O$"$j$^$;$s(B  $ pg_ctl start

 2. immediate$B$GDd;_(B

     $ pg_ctl stop -m i

 3. recovery.conf$B$r:n@.$7(BPG$B5/F0(B

     $ ls $PGDATA/recovery.conf
     /var/lib/pgsql/9.3/data/recovery.conf
     $ cat $PGDATA/recovery.conf
     standby_mode = 'on'
     primary_conninfo = 'host=192.168.30.100 port=5432 user=repuser \
application_name=pm01 keepalives_idle=60 keepalives_interval=5 keepalives_count=5'  \
restore_command = '/bin/cp /var/lib/pgsql/9.3/data/pg_arch/%f %p'  \
recovery_target_timeline = 'latest'  $ pg_ctl start

    $B"*(BSlave$B$G5/F0$9$k$O$:$@$,$$$D$^$G$?$C$F$b5/F0$7$J$$!*!*(B
    $B"*(Bpsql -l$B$r<B9T$9$k$H0J2<%(%i!<$H$J$k(B
       psql: FATAL:  the database system is starting up
===========


$B0lEY",$3$&$J$k$H(Brecovery.conf$B$"$j$N$^$^$G$O(B
PostgreSQL$B:F5/F0$r$7$F$b5/F0$7$J$$$h$&$G$9(B
$B0lEY(Brecovery.conf$B$J$7$G5/F0$7!"@5>oDd;_(B(pg_ctl stop)$B$r(B
$B$9$k$H!":F$S(Brecovery.conf$B$"$j$G5/F0$9$k$h$&$K$J$j$^$9!#(B


PG-REX$B$N>l9g(B(Pacemaker$B$r;HMQ$7$?>l9g(B)$B!"(Brestart_on_promote$B$,(Btrue$B$+$D(B
 stop_escalate$B$,(B0$B$N>l9g$K!"0J2<$NA`:n$,<B;\$5$l$k$?$a!">e5-:F8=<j=g$r(B
$BF'$s$G$7$^$&$h$&$G$9!#(B
($B;d$N4D6-(BPM1.0+Heartbeat3$B$G$b(Brestart_on_promote$B$r(Btrue$B$K$7$?$i:F8=$7$^$7$?(B)


 1. Master$BB&(B Pacemaker$B5/F0(B
    $BFbItE*$K$O(B
     recovery.conf$B$"$j$G(BPG$B5/F08e!"(Bpromote$B$N$?$a(BPG$B$r(Bimmediate$B$GDd;_$7(B
  recovery.con$B$J$7$G5/F0$9$k(B
      $B"*$3$l$,:F8=<j=g(B1$B$K$"$?$k(B

 2. Master$BB&(B Pacemaker$BDd;_(B
    $BFbItE*$K$O(B
     immediate$B$G(BPG$BDd;_(B
      $B"*$3$l$,:F8=<j=g(B2$B$K$"$?$k(B

 3. $B:FEY(BMaster$BB&(B Pacemaker$B5/F0(B
    $BFbItE*$K$O(B
     recovery.conf$B$"$j$G(BPG$B5/F0(B
      $B"*$3$l$,:F8=<j=g(B3$B$K$"$?$k!#(BPG$B$,5/F0$7$J$$$N$G%?%$%`%"%&%H%(%i!<H/@8!#(B



> $B5$$K$J$k$N$O!"(BPacemaker 1.0$B$H(BCorosync \
> 1.4$B$NAH$_9g$o$;$@$HLdBj$,$G$J$$$3$H$G$9!#(B \
> $BA4$/F1$8(BRA$B$r;H$C$F$$$k$N$G$9$,(B... \
> $B%?%$%_%s%0$H$+6vA3$H$+!"$=$&$$$C$?$b$N$@$H5$;}$A$,0-$$$G$9$M!#(B
$B>e5-:F8=<j=g$K$h$k$H!"(Brestart_on_promote$B$NCM$d!"(BPG$B$NA`:n$r<j$G9T$C$?$+$I$&$+$,(B
 $B%+%.$K$J$j$=$&$G$9!#(B



$B<h$j5^$.0J>e$G$9!#(B


2014/02/27 (Thu) 15:53, "Takehiro Matsushima" <takehiro.dreamizm@gmail.com> wrote:
> $B$R$,$7$5$s(B
> 
> $B>>Eg$G$9!#(B
> $B$*K;$7$$$H$3$m$"$j$,$H$&$4$6$$$^$9!#(B
> 
> immediate stop$B$,80$H$$$&$3$H$G$7$?$N$G!";n$7$F$_$^$7$?$H$3$m!"(B
> $B;d$N4D6-$G$O$[$\3N<B$K%@%a$K$J$j$^$7$?!#(B
> 
> $B0[>o7O$N%m%0$N$_:N<h$7$F$_$^$7$?!#(B
> 
> $B$^$:@5>o$KN)$A>e$,$k$h$&!"0lC6DL>oDL$j$K(Brecovery.conf$B$r:o=|$7$F(B
> service postgresql-9.3 \
> start/stop$B$r$7!"(B($BF0$+$J$$4D6-$r:n$j=P$;$k(B)Pacemaker$B$G(Bstart/stop$B$7$^$7$?!#(B
>  $B$G$9$N$G!":G=i$O(BSlave$B$G>e$,$C$F$=$N8e(Bpromote$B!"$7$P$i$/8e$K(Bstop$B$7$F$$$^$9!#(B($BE:IU(Btar$BFb(B1st--($BN,(B).log)
>  
> $BB3$$$F(Bpacemaker$B$r$b$&0lEYN)$A>e$2$F$$$^$9$,!"7o$N%(%i!<$G(Bstart$B$,<:GT$7$F$$$k%m%0$G$9(B($BE:IU(Btar$BFb(B2nd--($BN,(B).log)
>  
> 
> $B$R$,$7$5$s$N%"%I%P%$%9$I$*$j(Bstop_escalate$B$r$H$j$"$($:(B1$B$K$7$F$_$^$7$?$H$3$m!"IT6q9g$O2sHr$5$l$k$h$&$K$J$j$^$7$?!#(B
>  $B$R$H$^$:$O$3$l$GJL$N:n6H$b?J$a$i$l$=$&$G$9!#$"$j$,$H$&$4$6$$$^$9!#(B
> 
> 
> $B5$$K$J$k$N$O!"(BPacemaker 1.0$B$H(BCorosync \
> 1.4$B$NAH$_9g$o$;$@$HLdBj$,$G$J$$$3$H$G$9!#(B \
> $BA4$/F1$8(BRA$B$r;H$C$F$$$k$N$G$9$,(B... \
> $B%?%$%_%s%0$H$+6vA3$H$+!"$=$&$$$C$?$b$N$@$H5$;}$A$,0-$$$G$9$M!#(B 
> 
> $B$*K;$7$$$H$3$m$*;~4V$r3d$$$F$$$?$@$-$^$7$F!"$"$j$,$H$&$4$6$$$^$9!#(B
> $B;d$N$[$&$G$b0z$-B3$-D4::$r$7$F$_$^$9!#(B
> 
> 
> 2014$BG/(B2$B7n(B27$BF|(B 15:02  <kazuh@goo.jp>:
> > $B>>Eg$5$s(B
> > 
> > $B$R$,$7$G$9!#$*@$OC$K$J$C$F$*$j$^$9!#(B
> > 
> > $B;d$N4D6-$G!"(BPostgreSQL$BC1BN$G:F8=$7$^$7$?!#(B
> > PostgreSQL$BC1BN$G$b:F8=$7$?$3$H$+$i!"$*$=$i$/(BPostgreSQL$B$N%P%0$G$O$J$$$+$H(B
> >  $B;W$$$^$9!#(B
> > 
> > 
> > $B0J2<<j=g$G(BPostgreSQL$B$r%j%+%P%j%b!<%I5/F0"*(Bpromote$B"*(Bimmediate$BDd;_$r7+$jJV$9$H(B
> >  $B>>Eh$5$s4D6-$HF1MM$N;v>](B(PostgreSQL$B$,5/F0$7$J$$(B)$B$,H/@8$7$^$7$?!#(B
> >  
> > $ vim /var/lib/pgsql/9.3/data/recovery.conf $B"*<jF0$G%j%+%P%j%b!<%I$K(B
> > $ pg_ctl start     $B"*%j%+%P%j%b!<%I$G5/F0(B
> > $ pg_ctl promote   $B"*(BMaster$B$K>:3J(B
> > $ pg_ctl stop -m i $B"*(Bimmediate$B$GDd;_(B
> > $ mv recovery.done recovery.conf $B"*(B $B:F$S<jF0$G%j%+%P%j%b!<%I$K(B
> > $ pg_ctl start $B"*5/F0$7$J$$>l9g$"$j!*!*(B
> > 
> > $B5/F0$7$J$$>l9g$O!"(Bpsql$B$G@\B3$7$h$&$H$9$k$H0J2<$N$h$&$J%a%C%;!<%8$G%(%i!<$K$J$j$^$9!#(B
> >                 
> > psql: FATAL:  the database system is starting up
> > $B$$$D$^$GBT$C$F$b$3$N>uBV$,B3$-$^$9!#(B
> > 
> > $B$?$@$7!"I,$::F8=$9$k$o$1$G$O$J$/!"@5>o$K5/F0$9$k>l9g$b$"$j$^$7$?!#(B
> > ($B2?2s$b7+$jJV$7$F$$$k$&$A$K:#8=:_$O:F8=$7$J$/$J$C$F$7$^$$$^$7$?!#(B
> > debug$B%m%0$r<h$j$?$+$C$?$N$G$9$,!&!&!&(B)
> > 
> > 
> > PostgreSQL$B$N4QE@$+$iD4::$7$?$$$N$G!"$b$7!"2DG=$G$7$?$i!"(BPostgreSQL$B$N%m%0%l%Y%k$r(B
> >  debug5$B$K$7$F:F8=$5$;$F$$$?$@$1$J$$$G$7$g$&$+!)(B
> > (log_min_messages$B$r(Bdebug5$B$K@_Dj$7(BPostgreSQL$B:F5/F0(B)
> > 
> > 
> > 
> > $B$J$*!"?dB,$G$9$,!"(Bimmediate$B$K$h$k(BPG$BDd;_8e$KH/@8$9$k$h$&$J$N$G!"(B
> > pgsql RA$B$N(Bstop_escalate$B$r(B10$B$J$I!"(B1$B0J>e$NCM$K$7(Bimmediate$B$G$NDd;_$rHr$1$k$H!"(B
> >  $B;CDjE*$K2sHr$G$-$k$+$b$7$l$^$;$s!#(B
> > (immediate$B$K$h$kDd;_$NA0$K(Bfast$B$K$h$kDd;_$r$7!"(Bstop_escalate$BIC(B
> > $BBT$D$h$&$K$J$j$^$9!#(B)
> > 
> > $B$^$?$O(BPostgreSQL9.2$B7O$r$4;HMQ$$$?$@$/$N$b<j$+$H;W$$$^$9!#(B
> > 
> > 
> > $B:#8e$bD4::$rB3$1$^$9$,!"8=;~E@$G$O0J>e$G$9!#(B
> > $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> > 
> > 
> > 2014/02/27 (Thu) 10:41, "Takehiro Matsushima" <takehiro.dreamizm@gmail.com> \
> > wrote:
> > > $B>>Eg$G$9!#99$KO"Ej?=$7Lu$4$6$$$^$;$s!#(B
> > > 
> > > $BAa$H$A$j$@$C$?$h$&$G$9!#(B
> > > Pacemaker stop$B$+(Bstart$B$+$OL54X78$G$7$?!#(B
> > > $B%3%_%e%K%F%#HG$r;H$C$F(Binitdb$B$7$?$i$=$N8e$OH/@8$7$^$;$s!#(B
> > > 
> > > Nightly(2$B7n(B20$BF|HG(B)$B$N(BPacemaker+Corosync$B$r;H$&$H$=$N8e$+$iF0$+$J$/$J$j$^$7$?!#(B
> > >  $B%3%_%e%K%F%#HG$KLa$7$F$b!"(Binitdb$B$7$F:n$j$J$*$5$J$$$HF0$-$^$;$s$G$7$?!#(B
> > >  
> > > resource-agents$B$@$1$O(BNightly$B$r6&DL$7$F;H$C$F$$$^$9$N$G!"(BRA$B$N$;$$$G$O$J$$$H;W$$$^$9$,(B...
> > >  
> > > #$BK\HV4D6-$K$O%3%_%e%K%F%#HG$r;HMQ$7$F$$$/$D$b$j$G$O$$$^$9!#(B
> > > 
> > > 
> > > 2014$BG/(B2$B7n(B27$BF|(B 7:45 Takehiro Matsushima \
> > > <takehiro.dreamizm@gmail.com>:
> > > > $B$*@$OC$K$J$C$F$*$j$^$9!">>Eg$G$9!#(B
> > > > $BO"Ej?=$7Lu$4$6$$$^$;$s!#(B
> > > > 
> > > > $B99$KDI;n$7$^$7$?!#(B
> > > > Nightly$BHG$+$i%3%_%e%K%F%#HG$KJQ99$7$F$b8=>]$KJQ2=$O$"$j$^$;$s$G$7$?!#(B
> > > > $B0J2<%3%_%e%K%F%#HG$G!"$+$DC10l%N!<%I$N$_$r;H$C$F<B83$7$F$$$^$9!#(B
> > > > 
> > > > 1. Pacemaker stop$B$N>uBV$G(B...
> > > > 1.1. PostgreSQL9.3.3$B$G(Binitdb$B$7$F%P%C%/%"%C%W$7$F$$$?%G!<%?$rCmF~(B(150MB$B$/$i$$$N(BSQL)
> > > >  1.2. Pacemaker start/stop$B$r7+$jJV$9(B
> > > > 1.3. $B8=>]$N:F8=(B
> > > > 
> > > > 2. Pacemaker start$B$N>uBV$G(B...
> > > > 2.1. (1.1.)$B$HF1$8:n6H(B
> > > > 2.2. (1.2.)$B$HF1$8:n6H(B
> > > > 2.3. $B8=>]:F8=$;$:(B
> > > > 2.4. 2$B%N!<%I9=@.$G%U%'%$%k%*!<%P!<"*40A4Dd;_"*(B1$B%N!<%I1?E>"*(B2$B%N!<%I1?E>$r7+$jJV$9(B
> > > >  2.4. $B8=>]:F8=$;$:(B
> > > > 
> > > > $B$H$$$&7k2L$H$J$j$^$7$?!#(B
> > > > $B<h$j5^$.Js9p$H$5$;$F$$$?$@$-$^$9!#(B
> > > > 
> > > > --
> > > > Regards,
> > > > Takehiro Matsushima
> > > 
> > > 
> > > 
> > > --
> > > Regards,
> > > Takehiro Matsushima
> > > 
> > > _______________________________________________
> > > Linux-ha-japan mailing list
> > > Linux-ha-japan@lists.sourceforge.jp
> > > http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan
> > > 
> 
> 
> 
> -- 
> Regards,
> Takehiro Matsushima
> 

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


[prev in list] [next in list] [prev in thread] [next in thread]