[pgpool-general-jp: 542] Re: rsyncでデータ復旧後のpg_dumpエラー

[sugimoto kei]

$B ＠ P0fMM(B

$B$*@$OC$K$J$j$^$9!#(B
$BAaB.$N$4JV?.@?$K$"$j$,$H$&$4$6$$$^$9!#(B

pgpool$B$,860x$G$O$J$$$H$$$&7o!">pJs$4Ds6!$"$j$,$H$&$4$6$$$^$9!#(B
rsync$B$N>c32$N@~$G?J$a$5$;$F$$$?$@$-$^$9!#(B

$B0J>e$G$9!#(B

> Date: Fri, 6 Feb 2009 12:27:38 +0900
> To: pgpool-general-jp ＠ sraoss.jp; kei_wings ＠ hotmail.com
> Subject: Re: [pgpool-general-jp: 540] rsync$B$G%G!<%?I|5l8e$N(Bpg_dump$B%(%i!<(B
> From: ishii ＠ sraoss.co.jp
> 
> $B ＠ P0f$G$9!%(B
> 
> > pgpool-II  2.1$B$K$*$$$F(B $B%l%W%j%1!<%7%g%s%b!<%I$G(BDB$B#2Bf1?MQ$r<B;\$7$F$*$j$^$9!#(B
> > $B ＠ hF|(BDB$B4V$KIT ＠ 09g$,H/@8$7!"2<5-$NBP1~$r<B;\I|5l$$$?$7$^$7$?!#(B
> >  
> > $B-!(Bpgpool$B$rDd;_(B
> > $B-"(BDB#1,2$B$N(Bpostmaster$B$rDd;_(B
> > $B-#(BDB#1$B$r ＠ 5$H$7$F!"(BDB#1$B$N%G!<%?$r(BDB#2$B$K(Brsync$B$G%3%T!<(B
> > $B-$(BDB#1,2$B$N(Bpostmaster$B$r5/F0(B
> > $B-%(Bpgpool$B$r3+;O(B
> >  
> > $B"(3F<o%m%0>e!"(Bpgpool$B$r3+;O$7$F$+$i%(%i!<$O8!CN$7$F$*$j$^$;$s!#(B
> >  
> > $B>e5-BP1~8e!"(Bpg_dump$B$K$F(BDB$B%P%C%/%"%C%W$r(BDB#2$B$K$*$$$F<B;\$7$?$H$3$m(B
> > $B2<5-$N%(%i!<$,H/@8$7$^$7$?!#(B
> >  
> > pg_dump: ERROR:  missing chunk number 0 for toast value 8193065
> > pg_dump: SQL command to dump the contents of table "${$B%F!<%V%kL>(B}" failed: PQendcopy() failed.
> > pg_dump: Error message from server: ERROR:  missing chunk number 0 for toast value 8193065
> > pg_dump: The command was: COPY public.${$B%F!<%V%kL>(B} ({$B3F(Bcolumn}) WITH OIDS TO stdout;
> >  
> > $BMM!9$JJ}$,F1MM$N8=>]$r7P83$5$l$F$*$j!"%P%-%e!<%`!"%$%s%G%C%/%9:F:n ＠ .Ey$N=hCV$O(B
> > $BM-8z$G$O$J$$$H$$$&5-;v$r$_$^$7$?!#(B
> >  
> > $B>e5-$N$h$&$J>c32$N>l9g$I$N$h$&$KI|5l$9$l$P$h$$$N$G$7$g$&$+!)(B
> > $B$^$?(BDB#1$B$+$i(BDB#2$B$N%j%9%H%"J}K!$,$=$b$=$b ＠ 5$7$/$J$$$N$G$7$g$&$+!)(B
> 
> $B%(%i!<%a%C%;!<%8$+$i$9$k$H!$(BPostgreSQL$B$NFbIt%(%i!<$N$h$&$G$9$,!$(B
> PostgreSQL$B$O(Bpgpool$B$+$i8+$k$HC1$J$k(BDB$B%"%W%j%1!<%7%g%s$G$"$C$F!$$3$N$h$&(B
> $B$JFbIt%(%i!<$r5/$9$h$&$JA`:n$r9T$J$&$3$H$,$G$-$k$H$O9M$($i$l$^$;$s!%(B
> 
> (3)$B$N(Brsync$B$N%*%W%7%g%s$,ITE, ＠ Z!$$"$k$$$O(Brsync$B$N>c32$H$$$&2DG=@-$O$J$$(B
> $B$G$7$g$&$+!)(B
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan

_________________________________________________________________
$B=)K\HV!*O"5Y$?$/$5$s$N$3$N=)!"$_$s$J$N%*%9%9%a=5KvN99T$r%A%'%C%/$7$h$&(B
http://clk.atdmt.com/GBL/go/112813570/direct/01/
-------------- next part --------------
HTML$B$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
URL: http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20090206/769140e7/attachment.html