[pgsql-jp: 41185] Re: リストアで失敗する

[Tomoaki Sato]

$B:4F#$G$9!#(B

> $B$?$S$?$S$*@$OC$K$J$C$F$*$j$^$9!">.Bt$H?=$7$^$9!#(B
> 
> $B$"$k(BPC$B$G(BPgAdmin$B-7$G%P%C%/%"%C%W$7$?%G!<%?%Y!<%9$r(B
> $BB>$N(BPC$B$K(Bpsql$B%3%^%s%I$G%j%9%H%"$7$?$H$3$m!"(B
> $B2<5-$N%(%i!<$,=P$F%j%9%H%"$G$-$^$;$s!#(B
> 
> syntax error at or near "PGDMP" at character 1
> syntax error at or near "AS" at character 1
> syntax error at or near "
" at character 1
> 
> $BF1$8%P%C%/%"%C%W$r(BPgAdmin$B-7$G%j%9%H%"$9$k$H>e<j$/$$$-$^$9!#(B
> $B$b$A$m$s(B2$B$D$N(BPC$B$K$"$k(BPostgres$B$OF1$8%P!<%8%g%s$N(B
> $B$b$N$G$9!J(B8.0$B$H>/$78E$$$G$9$,!K!#(B
> 
> $B%P%C%/%"%C%W$N7A<0$O(BCOMPRESS$B$G!"(BOID$B$O4^$s$G$$$^$;$s!#(B

COMPRESS $B$*$h$S(B TAR $B7A<0$N%@%s%W$O(B pg_restore $B%3%^%s%I$G%j%9%H%"$7$^$9!#(B
psql $B%3%^%s%I$G%j%9%H%"$G$-$k$N$O(B PLAIN $B7A<0$N$_$G$9!#(B

  pg_restore -d $B%G!<%?%Y!<%9L>(B $B%@%s%W%U%!%$%k(B

$B%@%s%W!&%j%9%H%"$K$D$$$F$O!"(BPostgreSQL $B$N%^%K%e%"%k$r;O$a$H$7$F0J2<$N(B
$B5-;v$J$I$rFI$`$H$$$$$H;W$$$^$9!#(B

$B%P%C%/%"%C%W$N35MW$HJ}<00lMw(B:
  http://lets.postgresql.jp/documents/technical/backup/

> $B0JA0F1$8$3$H$r(BSQL_ASCII$B%U%)!<%^%C%H$N%G!<%?%Y!<%9$G(B
> $B$d$C$?;~$OLdBj$J$/$G$-$?$N$G$9$,!":#2s(BEUC_JP$B$G(B
> $B$d$C$F$3$NLdBj$,5/$3$C$F$$$^$9!J4X78$"$k$+$OITL@$G$9$,!K(B
> 
> $B$3$N7o$K4X$9$k2r7h:v$r$*;}$A$NJ}!"$<$R$465<x(B
> $B$*4j$$$$$?$7$^$9!#(B


----
Tomoaki Sato <sato ＠ sraoss.co.jp>
SRA OSS, Inc. Japan