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

Tatsuo Ishii ishii @ sraoss.co.jp
2009年 2月 6日 (金) 12:27:38 JST


$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


pgpool-general-jp メーリングリストの案内