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

[shimada_yuu ＠ tdc.co.jp]

$B ＠ u1)MM(B

$BJV?.@?$K$"$j$,$H$&$4$6$$$^$9!#!!EgED$G$9(B

>> $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(B
$B%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$?(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$G(B
$BN)$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%j%+%P%j$r$9$k:]$K$H$a$kI,MW$,$J$$$H$$$&$3$H$O!"-%!A-'$b$d$kI,MW$,$J$$$H$$$&(B
$B$3$H$G$7$g$&$+!)(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
>
postmaster$B$O(Bpsql$B%3%^%s%I$G1~Ez$,$"$j$^$9$N$G!"5/F0$7$F$$$k$H;W$$$^$9(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$&(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
>
rsync$B$r<B9T$9$k$H$$$&$N$O0J2<$N%3%^%s%I$r<B9T$9$k$H$$$&$3$H$G$7$g$&$+!)(B
rsync -auzr -e "ssh -1" dual:/usr/local/pgsql/data /usr/local/pgsql

>
>> $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!<(B
$B%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
>
$B!!(Bpgcluster$B$N%Z!<%8$K$O(B1.0.9a$B$,:G?7$H$"$C$?$N$G$9$,!"(BpgFoundry$B$N%Z!<%8$r$_(B
$B$?$i$"$j$^$7$?!#(B
$B=PMh$l$P!"K\2H$N%Z!<%8$b:9$7BX$($i$l$?$[$&$,%f!<%6$K$O$o$+$j$d$9$$$+$H9M$((B
$B$^$9!#(B

$B2>$K!"(B1.0.9a$B$+$i:9$7BX$($k>l9g$O0l2s!"(Bpgcluster$B$rF~$lBX$($J$1$l$P$J$i$J$$$N(B
$B$G$7$g$&$+!)(B


$B0J>e!"$*<j?t$r$*3]$1$$$?$7$^$9$,!!59$7$/$*4j$$CW$7$^$9(B