[pgcluster: 834] Re: リカバリが完了したか判断するには？

[Yoshiyuki Asaba]

$B$3$s$P$s$O!#(B
$B ＠ u1)$H$$$$$^$9!#(B

From: shimada_yuu ＠ tdc.co.jp
Subject: [pgcluster: 833] $B%j%+%P%j$,40N;$7$?$+H=CG$9$k$K$O!)(B
Date: Fri, 18 Nov 2005 23:41:23 +0900

> $B"#<j=g(B
> $B-!>e5-$N9=@.$rN)$A>e$2!"JRB&$N%/%i%9%?%5!<%P!J<B:]$K$O%5!<%P(BA$B!K$KBP$7$F%G!<(B
> $B%?$N%j%9%H%"$r9T$C$?(B
> $B-"%G!<%?$N%j%9%H%"$,40N;$7$?8e$K!"%m!<%I%P%i%s%5$G(Bpsql -l$B$N%3%^%s%I$r$&$C$?(B
> $B$H$3$m%l%W%j%1!<%?$N(B
> $B!!%m%0(B(pgreplicate.sts)$B$K(Berror$B$NJ8;z$,I=<($5$l$?(B
> $B-#%m!<%I%P%i%s%5(B(pglb.sts)$B$K$O(Berror$B$O=PNO$5$l$J$+$C$?(B
> $B-$$3$3$G%m!<%I%P%i%s%5!"%/%i%9%?%5!<%P!"%l%W%j%1!<%?$N=g$KDd;_$5$;$?(B

$B%j%+%P%j$r<B9T$9$k:]$K;_$a$kI,MW$O$"$j$^$;$s$N$G!"(B4 $B$O$d$i$J$/$F$b$h$$(B
$B$+$H;W$$$^$9!#(B

> $B-%%G!<%?$N%P%C%/%"%C%W$r3+;O$9$k$?$a$K!"%l%W%j%1!<%?$N%^%9%?$r%m%0=PNO$GN)$A(B
> $B>e$2$?(B
> $B-&%9%l!<%V$N%l%W%j%1!<%?$rN)$A>e$2$?(B
> $B-'%j%9%H%"$7$?%/%i%9%?%5!<%P$rN)$A>e$2$?(B
> $B-(%G!<%?$,8E$$%/%i%9%?%5!<%P$r%j%+%P%j%b!<%I$GN)$A>e$2$?(B
> 
> 
> $B"#7k2L(B
> $B-!%j%+%P%j%b!<%I$GN)$A>e$2$?$H$-$O0J2<$N%a%C%;!<%8$,I=<($5$l$?(B
> [postgres ＠ testB postgres]$ /usr/local/pgsql/bin/pg_ctl start -D
> /usr/local/pgsql/data -o "-i -R"
> /usr/local/pgsql/bin/postmaster: Assert checking is not compiled in.
> postmaster successfully started
> [postgres ＠ testB postgres]$ Start in recovery mode!
> Please wait until a data synchronization finishes from Master DB...
> 1st recovery step of [global] directory...OK
> 1st recovery step of [base] directory...OK
> 1st recovery step of [pg_clog] directory...OK
> 1st recovery step of [pg_xlog] directory...OK
> 2nd recovery step of [global] directory...OK
> 2nd recovery step of [base] directory...OK
> 2nd recovery step of [pg_clog] directory...OK
> 2nd recovery step of [pg_xlog] directory...OK

$B$3$3$G(B postmaster $B$O5/F0$5$l$F$$$^$9$G$7$g$&$+!)(B


> $B"#<ALdFbMF(B
> $B-!8=:_$N%P!<%8%g%s$G$b%j%+%P%j$,40N;$9$l$P%l%W%j%1!<%?$N%m%0$K(B"can use"$B$H$$(B
> $B$&(B
> $B%a%C%;!<%8$,I=<($5$l$^$9$+!)(B

$B$=$N=q ＠ R$O:#<j85$K$J$$$+$i$o$+$i$J$$$N$G$9$,!"3N$+%j%+%P%j$+$iI|5"$7$?(B
$B$i(B "can use" $B$G$O$J$/$F(B "start use" $B$,=P$?$H;W$$$^$9!#<j85$K$"$k%=!<%9(B
$B%3!<%I$r(B grep $B$7$F$_$^$7$?$,!"(B"can use" $B$O%^%C%A$7$^$;$s$G$7$?!#(B


> $B-"L\E*$rC#@.$9$k$?$a$K;d$,$H$C$?<j=g$O ＠ 5$7$$$N$G$7$g$&$+!)(B

$B>e$G$b=q$-$^$7$?$,!"%j%+%P%j$O;_$a$J$/$F$b$G$-$^$9$,!";_$a$F$d$k>l9g$O!"(B
$B$?$@C1$K(B rsync $B$G%3%T!<$9$k$@$1$G(B OK $B$G$9!#5/F0$7$?>uBV$G(B rsync $B$r<B9T(B
$B$9$k$N$O$^$:$$$G$9!#(B


> $B-#(BFQDN$B7A<0$r0U<1$7$F%5!<%PL>$r?6$j$J$*$7$?$N$G$9$,7k2L$H$7$F%/%i%9%?%5!<%P$N(B
> $B%m%0$K=P$?(BERROR$B$NItJ,$,JQ$o$j$^$;$s$G$7$?!#(B
> $B%/%i%9%?!<%5!<%P$N$H$3$m$G=P$k(BERROR$B$N0UL#$O2?$G$7$g$&$+!)(B

$B8=:_(B 1.0.x $B7O$N:G?7$O(B 1.0.10rc1 $B$,$"$j$^$9$N$G!"$3$A$i$r;H$C$F$_$k$H$$(B
$B$&$N$O$$$+$,$G$7$g$&$+!)(B

--
Yoshiyuki Asaba
y-asaba ＠ sraoss.co.jp