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

[Yoshiyuki Asaba]

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

From: shimada_yuu ＠ tdc.co.jp
Subject: [pgcluster: 836] Re: $B%j%+%P%j$,40N;$7$?$+H=CG$9$k$K$O!)(B
Date: Mon, 21 Nov 2005 09:15:33 +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(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$O$$!"$=$&$G$9!#(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$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!<(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

pgreplicate <--> postmaster $B4V$N%W%m%H%3%k$,7k9=JQ$o$C$F$$$^$9$N$G!"A4(B
$BItF~$lD>$9I,MW$,$"$j$^$9!#%G!<%?%Y!<%9$r:n$jD>$9(B(initdb $B$+$i$d$j$J$*$9(B)
$BI,MW$O$"$j$^$;$s!#(B

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